Comparing two MySQL databases

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:

This entry was posted in Databases and SQL, MySQL and tagged . Bookmark the permalink.

2 Responses to Comparing two MySQL databases

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags are not allowed.

517,234 Spambots Blocked by Simple Comments