同步MySQL数据库的最佳工具 [英] Best tool for synchronizing MySQL databases

问题描述

我只是想合并两个MySql数据库的结构.有没有使用Red-Gate的SQL Compare功能的工具?有免费的替代品吗?

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?

推荐答案

我一直在使用 SQLyog 几年了.最近，他们发布了v8.0，其中包括更新的界面和Query Profiler和SQL Formatter的两个非常酷的功能.格式化程序是我今年升级的原因.

I've been using SQLyog for 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.

http://www.webyog.com/en/sqlyog_feature_list.php

博客帖子，其中包含正在运行的SQL Formatter的视频和动画gif http://www.webyog.com/blog/2009/02/02/profile-and-format-mysql-queries-with-the-new-sqlyog-80/

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/

几年前，我尝试使用Navicat和mysql管理器，但决定使用SQLyog.我确定此后两个产品都已更新，但是我对定期更新的SQLyog仍然感到满意.

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 8 MySQL，并没有留下深刻的印象

[Update] - Just downloaded and installed NaviCat 8 for MySQL and was not impressed

添加此帖子后，我查看并下载了适用于MySQL的NaviCat v8.与SQLyog的用户界面相比，没有可比性. SQLyog更好，更直观.特别是具有前面提到的两个最新功能.我立即注意到，当尝试查看表数据时，SQLyog如何将您留在一个窗口中，而Navicat则生成一个新窗口.报表生成器和查看器是将Navicat置于SQLyog IMHO之上的唯一方法，而且我已经有了使用ASP.NET处理报表的其他方法.尝试两种产品，我想您会同意我的.

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.

这篇关于同步MySQL数据库的最佳工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！