Best tool for synchronizing MySQL databases

Question

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?

Answer 1

although i dont have any experience with it, i hear that navicat would be the tool to use:

http://mysql.navicat.com/

also toad for mysql i hear isnt bad:

http://www.quest.com/toad-for-mysql/

Answer 2

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

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/

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.

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

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.

Answer 3

Nob Hill's Database Compare tool, (for data or Schema compare) its cheaper than Red gats's, and the tools can work with different kind of databases (SQL, MySQL, Excel..)

Answer 4

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.

You can find a visual tutorial about Navicat's data/ structure synchronization at http://support.navicat.com/visual_tutorial/data_sync.html.