同步 MySQL 数据库的最佳工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/52583/
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
Best tool for synchronizing MySQL databases
提问by cordis
I'm on a little quest of merging the structure of two MySql databases. Is there a tool for this with the might of Red-Gate's SQL Compare? Are there any free alternatives?
我正在尝试合并两个 MySql 数据库的结构。有没有像 Red-Gate 的 SQL Compare 那样强大的工具？有没有免费的替代品？
回答by Brian Boatright
I've been using SQLyogfor years now. Recently they released v8.0 which includes an updated interface and two very cool features the Query Profiler and SQL Formatter. The formatter was the reason I upgraded this year.
我多年来一直在使用SQLyog。最近，他们发布了 v8.0，其中包括更新的界面和两个非常酷的功能：查询分析器和 SQL 格式化器。格式化程序是我今年升级的原因。
http://www.webyog.com/en/sqlyog_feature_list.php
http://www.webyog.com/en/sqlyog_feature_list.php
Blog post with video and animated gif of the SQL Formatter in action http://www.webyog.com/blog/2009/02/02/profile-and-format-mysql-queries-with-the-new-sqlyog-80/
带有 SQL 格式化程序的视频和动画 gif 的博客文章 http://www.webyog.com/blog/2009/02/02/profile-and-format-mysql-queries-with-the-new-sqlyog-80 /
A few years ago I tried Navicat and the mysql manager but decided on SQLyog. I'm sure both products have been updated since but I'm still happy with SQLyog which is updated regularly.
几年前，我尝试过 Navicat 和 mysql 管理器，但最终决定使用 SQLyog。我确信这两个产品都已更新，但我仍然对定期更新的 SQLyog 感到满意。
[Update] - Just downloaded and installed NaviCat 8for MySQL and was not impressed
[更新] - 刚刚下载并安装了NaviCat 8for MySQL，并没有留下深刻的印象
After I added this post I reviewed and downloaded v8 of NaviCat for MySQL. In comparison with user interface of SQLyog there is no comparison. SQLyog is better and more intuitive. Especially with the two latest features mentioned earlier. Immediately I noticed how SQLyog keeps you in one window when trying to view the data of a table, while Navicat spawns a new window. The report builder and viewer is the only thing that would put Navicat above SQLyog IMHO, and I already have other means to handle reports using ASP.NET. Try both products and I think you'll agree with me.
添加这篇文章后，我查看并下载了 NaviCat for MySQL 的 v8。与 SQLyog 的用户界面相比，没有可比性。SQLyog 更好更直观。尤其是前面提到的两个最新功能。我立即注意到 SQLyog 如何在尝试查看表数据时将您保持在一个窗口中，而 Navicat 会生成一个新窗口。报告生成器和查看器是唯一能让 Navicat 高于 SQLyog 恕我直言的东西，我已经有了其他方法来使用 ASP.NET 处理报告。尝试这两种产品，我想你会同意我的看法。
回答by John Boker
although i dont have any experience with it, i hear that navicat would be the tool to use:
虽然我没有任何经验，但我听说 navicat 将是使用的工具：
https://www.navicat.com/en/products/navicat-for-mysql
https://www.navicat.com/en/products/navicat-for-mysql
also toad for mysql i hear isnt bad:
我听说还不错的 mysql 蟾蜍：
回答by Petah
Toad for MySQLcan do both a "Schema Compare" as well as a "Data Compare" (and a lot more).
Toad for MySQL可以进行“架构比较”和“数据比较”（以及更多）。
It used to be freeware, but the latest versionsare not. You can still find the old versions though.
它曾经是免费软件，但最新版本不是。您仍然可以找到旧版本。
回答by Petah
I've used Navicat for more than 3 years. It provides all the features that I need and save me tons of time for managing and developing MySQL and Oracle.
我已经使用 Navicat 超过 3 年了。它提供了我需要的所有功能，并为我管理和开发 MySQL 和 Oracle 节省了大量时间。
You can find a visual tutorial about Navicat's data/ structure synchronization at http://support.navicat.com/visual_tutorial/data_sync.html.
你可以在http://support.navicat.com/visual_tutorial/data_sync.html找到关于 Navicat 数据/结构同步的视觉教程。
