So your developing, and you have to alter a database structure to match from one versiont o another. You want to automate this process…. but how?
MySQLdiff to the rescue:
“MySQLdiff is a little Tool to detect layout differences between two databases.
Almost every developer knows the that changes of the database on the developement system have to be logged in order to update the live-system later on.
To make this easier the tool MySQLdiff has been developed. Not as a real project but …
MySQLdiff will create a SQL-ALTER-Script which has to be run onto the live-system to ‘patch’ it to the state of the developement system. “
I might be in love.