如何使用 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
How to Schema Diff two databases using MySQL 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:
如果您没有直接看到此选项,则必须:
- Click
File
andNew model
- On the new model window which has been opened, click
Database
andCompare schemas
.
- 单击
File
并New model
- 在打开的新模型窗口中,单击
Database
和Compare 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.
只需转到文件-> 新模型,然后数据库-> 与任何源同步。您必须在模型视图中才能在“数据库”菜单中看到此选项。