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 …