I'm looking for a utility that can compare two database structures and
generate a SQL statement that will duplicate the differences.
I'm using mySQL and I have both live and development databases. While
working on the development database, I frequently make changes to table
structures, adding/removing tables or columns, changing column types, or
adding/removing indexes.
When I'm ready to move my changes to the live site, I'd like to just
compare the two databases, and have it generate a SQL statement that I
can run on my live database, so that it's structure will match my
development database. This would be much easier than trying to make all
of the changes manually, or writing my own script to make the changes
(how would you test this? Can't test it on the development database, the
changes are already there. Can't test it on the live database, what if
there's a mistake of some kind?)
Anybody out there know of a (or a couple) of utilities to do this?
Thanks,
Mikey
