MySQL Diff Tool

Question

Does anyone know any visual MySQL diff tools?

I have about 10 machines all with their own instance of MySQL. No replication is taking place, since each machine acts independently of the others. However, their table structures must be identical, and I would like a quick way to verify their table structures.

I'm not so concerned about the data in the tables. However, if the tool supports table data comparisons, I'd definitely like to check that out, too.

If you've worked with a good command-line tool, I'm open to that as well.

Answer 1

Toad® for MySQL can do both a "Schema Compare" as well as a "Data Compare" (and a lot more).

By the way: the software is freeware - in case somebody asks.

Answer 2

Maatkit has a tool for ensuring tables on two database instances are in sync, but operates on data rather than just schema. Doing something with diff and the output of show create table <table>; on the two nodes you're trying to compare would seem to be the easiest way of doing what you're talking about.

Answer 3

Try mysql-diff. It does good job comparing table structures, but does not support all modern MySQL features. It is command line and free.

Answer 4

Try Database compare tool by Nob Hill. Its for Schema compare like you wish and also data compare. (for MySQL or SQL)

Answer 5

In case you use hibernate then you can also do it with SchemaValidate.

Answer 6

I just accomplished this with the "Structure Synchronization" tool in Navicat. It analyzed two databases, presented the differences in a color-coded tree, and offers to run the SQL to bring the target up-to-date with the source.

It lets you save synchronization profiles, which I'm sure will come in handy for deploying updates to the Django (python manage.py syncdb stinks!) app I'm working on.

One catch was I had to turn off comparing indexes because the unique identifiers on each host were different:

  `group_id_refs_id_f116770`(group_id) != `group_id_refs_id_fee9890`(group_id)

Answer 7

Here's a Perl module that can diff two MySQL database schemas:

SQL Translator: sqlt-diff

http://search.cpan.org/~ribasushi/SQL-Translator-0.11005/script/sqlt-diff

Answer 8

Zidsoft CompareData can compare both table data and/or structure. It is based on ODBC so it works with any DBMS that has an ODBC-compliant driver including MySQL.

Answer 9

You should take a look at Devart's database compare tools for MySQL:

• dbForge Schema Compare for MySQL
• dbForge Data Compare for MySQL