Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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)?

like image 777
Nic Rodgers Avatar asked Aug 12 '09 12:08

Nic Rodgers


People also ask

How do I compare data between two databases in MySQL?

Getting data differences of two MySQL databasesClick New.. on the product Start Page or New Data Comparison on the Standard toolbar to open New Data Comparison Wizard. Specify the needed connections to MySQL servers in the Connection fields. Select the databases you want to compare in the Database fields.

What databases does Redgate support?

Redgate produces specialized database management tools for Microsoft SQL Server, Oracle, MySQL and Microsoft Azure.

How can I compare the schema of two databases?

To compare database definitions. On the Tools menu, select SQL Server, and then click New Schema Comparison. Alternatively, right-click the TradeDev project in Solution Explorer, and select Schema Compare. The Schema Compare window opens, and Visual Studio automatically assigns it a name such as SqlSchemaCompare1 .


2 Answers

Red Gate now has MySQL Compare & MySQL Data Compare

like image 166
Stephen Harrison Avatar answered Oct 14 '22 17:10

Stephen Harrison


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

Maatkit also support several different RDBMS

like image 22
Sadegh Avatar answered Oct 14 '22 15:10

Sadegh