How to Compare two Databases using MySQL Workbench - MySQL DBA Tutorial

How to Compare two Databases using MySQL Workbench

demo explains how you can compare two databases on same MySQL Servers or on different MySQL Servers. Once you run the Compare Database Wizard, you will be able to see which tables are different between Source and Destination, Tables which exists in Source and does not exits in Destination, Tables which exists in destination database and not present in Source database.
Once you validate all the changes, you can generate MySQL scripts to implement changes or you can hit execute and it will synchronize the destination database from destination database.


MySQL Workbench Tutorial - Compare two Databases using MySQL Workbench