如何使用 MySQL Workbench 对两个数据库进行架构区分?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/10248072/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 13:02:47  来源:igfitidea点击:

How to Schema Diff two databases using MySQL Workbench?

mysqldatabaseschemamysql-workbench

提问by jjwdesign

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.

有谁知道如何使用 MySQL Workbench 为两个数据库提取数据库方案差异。v5.2 声明它具有此功能,但我似乎无法找到它。我必须使用 MySQL Workbench。

采纳答案by Sergio

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.

数据库差异工具是 MySQL 实用工具的一部分,您可以通过Plugins -> Start Shell for MySQL Utilities. 您可以在此处找到相关文档

回答by Avión

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

如果您没有直接看到此选项,则必须:

  1. Click Fileand New model
  2. On the new model window which has been opened, click Databaseand Compare schemas.
  1. 单击FileNew model
  2. 在打开的新模型窗口中,单击DatabaseCompare schemas

回答by Max

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.

只需转到文件-> 新模型,然后数据库-> 与任何源同步。您必须在模型视图中才能在“数据库”菜单中看到此选项。

回答by jmhostalet

you can open "Model view"

您可以打开“模型视图”

enter image description here

enter image description here

and choose "Compare schemas" option

并选择“比较模式”选项

enter image description here

enter image description here