When doing development, you’ll often have multiple versions of a database on different environments and sometimes it would be useful to be able to check the differences between the data. Did you know you can use the Toad database tool to compare two databases? Simply go to Tools -> Compare -> Data:
The next screen will ask you to map the tables from the first database to those in the second. If you are comparing databases with the same schema, you can simply select “Map all”. Then Toad will analyse the differences and give you a report which tells you how many rows are the same in each table, how many have been removed and how many added:
2 Responses to Comparing two MySQL databases