in reply to How to synchronize two database tables in MySQL?

Alzabo has schema diffing and altering capabilities. You may be able to automatically import you schemas and then generate the ALTERs required.

It's been a long time since I used Alzabo, so I'm not sure of the current status or whether this plan is feasible. Perhaps someone else can provide more up to date information.

Usually I just diff the schema dumps and migrate by hand. But as I have only one deployment it's easy.

mysqldump dev -d --add-drop-table=false > dev.sql mysqldump live -d --add-drop-table=false > live.sql perl -pi -e 's/^--.*\n//;s{/\*.*\*/;\n?}{}' dev.sql live.sql diff -B -U 5 dev.sql live.sql > schema.diff

Brad