I have a two databases, one in a production environment (let's call it db_prod) 
and the other in a testing environments (Let's call it db_test).

What is the best way to synchronize the database schemas?  db_test has had a 
few indexes and constraints added to several tables and I need to generate a 
MySQL script to apply these changes to db_prod.  So basically I want to dump 
the schemas of the two database, compare, and generate the necessary script to 
apply to db_prod.

Thanks,
Randall Price

Reply via email to