The mysqldiff and mysqldbcompare utilities were designed to produce a difference report for objects and in the case of mysqldbcompare the data. Thus, you can compare two databases and produce a report of the differences in both object definitions and data rows.
While that may be very useful, would it not be much more useful to have the ability to produce SQL commands to transform databases? Wait no longer! The latest release of MySQL Utilities has added the ability to generate SQL transformation statements by both the mysqldiff and mysqldbcompare utilities.
To generate SQL transformations in either utility, simply use the --sql option to tell the utility to produce the statements.Object Transformations with mysqldiff
If you would like to compare the schema of two databases (the objects and their [Read more...]