From: Hassan Schroeder
Date: January 23 2010 6:48pm
Subject: Re: Best way to synchronize two database schemas
List-Archive: http://lists.mysql.com/mysql/220376
Message-Id: <4eedb92a1001231048y5a84ffcbqaf44939b0deb2b80@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

>> What is the best way to synchronize the database schemas? =A0db_test has=
 had a
>> few indexes and constraints added to several tables and I need to genera=
te a
>> MySQL script to apply these changes to db_prod.

Ruby on Rails comes with tools to dump and load db schemas;
it's trivial to create a skeleton app and point it at your DB if you
want to try it out.

Of course, Rails also uses what are called "migrations" to make
changes to existing DBs, which keeps you out of this problem in
the first place :-)

I haven't looked, but I wouldn't be surprised if other comparable
(i.e., Rails clone) platforms have similar features.

FWIW,
--=20
Hassan Schroeder ------------------------ hassan.schroeder@stripped
twitter: @hassan