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)?
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.
Redgate produces specialized database management tools for Microsoft SQL Server, Oracle, MySQL and Microsoft Azure.
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 .
Red Gate now has MySQL Compare & MySQL Data Compare
you can use Toad for MySql , it has a compare features
Maatkit also support several different RDBMS
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With