The best way is to keep track of all individual changes to your staging environment, including fire-and-forget style scripts; and apply those to your production environment as needed. This is part of the process of change management, and generally a very good idea :-)
Lacking that, there are several tools that can generate a differential script to do exactly this. I don't really use them, but I seem to remember that SQLyog and some expensive but excellent Quest tool could do it. On 1/21/10, Price, Randall <randall.pr...@vt.edu> wrote: > 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 > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
