Does anyone have any ideas for scipt that can validate an array / XML of table definitions against the current database tables and make the appropriate changes / create queries to keep them in sync? I am currently using php5 and mysql 5.
I have a feeling that MySQL Workbench is capable of generating alter / diff SQL scripts
choose some database migration infrastructure or write your own. and read this http://www.codinghorror.com/blog/archives/001050.html