Compare 2 database schemas on Mysql

Question

I have 2 schemas in a database about the same application (Different versions)

I want to generate a Delta script with the differences

It exists some tool that helps me (Open source solution should be perfect)

Thank you

Answer 1

Navicat for MySQL does this with its "Structure Synchronization" tool, but it is not open source (US$179). It will compare tables showing you all the differences and also provide you with the SQL to sync them up.

There is a free 30-day trial which you could use to do a quick comparison. Windows, Linux, and Mac versions.

Answer 2

http://sourceforge.net/projects/schema-compare/

basic but working

Answer 3

mysql-diff does schema comparison.

Answer 4

Try using dbForge Schema Compare for MySQL. It's not a free tool, though it offers free 30-days trial period.