Diff-ing database to test data migration?

Rails
1

Hi All,

Is there a tool for diff-ing the before and after state of a database
(both table structure and data) for the purpose of ensuring a Rails
migration has the desired effect?

If that’s not possible, is there a way to see the SQL statements
executed by a migration, for the same purpose?

Thanks,
Eric

2

Answering my own question, I found diff-ing the output of MySQL
Administrator’s backup functionality gives pretty concise summary of
the schema and data changes.