Tool for extracting diff between two MySQL db structures (including tables, procedures, triggers, functions)?

Question

Hello,

I'm starting to think about some kind of deployment script. So, sometimes we need to ALTER our tables in release etc. I need some kind of tool to compare DB structure on dev and production (or just previous version), find out difference in table's structures and generate appropriate ALTER's.

It will also be great if this tool will support MySQL's triggers, stored procedures etc (I'm not using then, but probably will in future).

I heard "migration" word, but I don't know is it ok to use this word in my case. :)

Thank you.

Answer 1

Hello!

You should try Devart's dbForge Schema Compare for MySQL, a GUI tool for schema comparison and synchronization, analysis of database structure differences, and propagation of changes to a required MySQL Server. It can generate appropriate script for your purposes.

Answer 2

Seems like this has been answered before: http://stackoverflow.com/questions/218499/mysql-diff-tool