How to Schema Diff two databases using MySQL Workbench?

Question

Does anyone know how to pull a database Scheme Diff for two databases using MySQL Workbench. v5.2 states it has this feature, but I can't seem to find it. I must use MySQL Workbench.

Solution 1

The database diff tool is part of the MySQL Utilities that you can access through MySQL Workbench in Plugins -> Start Shell for MySQL Utilities. You can find the relevant documentation here.

Solution 2

If you don't see this option directly you have to:

1. Click File and New model
2. On the new model window which has been opened, click Database and Compare schemas.

Solution 3

Just go to File->New Model, then Database -> Synchronize with any source. You have to be in model view to see this option in the Database menu.

Solution 4

you can open "Model view"

and choose "Compare schemas" option

View more solutions