Is there an equivalent of Redgate SQL Compare for MySQL databases?

Question

Joel is always talking about how great SQL Compare from Redgate software is. SQL Compare only works with Microsoft SQL Server databases, but is there a good piece of software that works with MySQL and the other common databases that are part of the LAMP stack (PostgreSQL, Oracle, etc)?

Answer 1

you can use Toad for MySql , it has a compare features

Maatkit also support several different RDBMS

Answer 2

Winsql is a good windows application that uses odbc to connect to any db and has compare tools. Here's the address: http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp

Answer 3

RedGate now have an Early Access Release of MySQL Compare

Answer 4

Spectral Core released Omega Sync. It can natively compare and synchronize MySQL, SQL Server, Access, Interbase, Firebird - and almost anything else via ODBC. Data can be synchronized even between databases of different type, for example - SQL Server with MySQL.

See http://www.spectralcore.com/omegasync/

Answer 5

Zidsoft CompareData is ODBC-based and works with MySQL and any DBMS that has an ODBC 3.5 compliant driver