How to Schema Diff two databases using MySQL Workbench?

mysql database schema mysql-workbench
jjwdesign picture jjwdesign · Apr 20, 2012 · Viewed 37.4k times · Source

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.

Answer

Avión picture Avión · Jul 20, 2017

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.

Related questions

Cannot alter schema name in MYSQL 5.5 w/ MYSQL Workbench

Why I cannot alter my schema name from the MYSQL Workbench? Am i missing something? :( As you can the name is dissabled

Read More
How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
Difference Between Schema / Database in MySQL

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that Create Schema and Create Database do essentially the same thing …

Read More