Diff-ing database to test data migration?

rubyonrails-talk
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.