Best tool for synchronizing MySQL databases [closed]

by

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.

enter image description here

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. What is the error “Every derived table must have its own alias” in MySQL?
  3. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. How to grant remote access permissions to mysql server for user?
  6. Generating a series of dates [duplicate]
  7. How to escape single quotes in MySQL
  8. MySQL comparison with null value
  9. Why is the estimated rows count very different in phpmyadmin results?
  10. Unique constraint that allows empty values in MySQL
  11. Matching all values in IN clause
  12. INTERSECT in MySQL
  13. Having both a Created and Last Updated timestamp columns in MySQL 4.0
  14. MySQL select with CONCAT condition
  15. mysql field name from variable
  16. Multiple select statements in Single query
  17. Which is faster — INSTR or LIKE?
  18. Remove duplicate rows leaving oldest row Only?
  19. Show constraints on tables command
  20. Remove special characters from a database field
  21. Set user variable from result of query
  22. Mysql command not found in OS X 10.7
  23. Reset MySQL root password using ALTER USER statement after install on Mac
  24. See if lat / long falls within a polygon using mysql
  25. MySQL disable all triggers
  26. How do I fix the ‘Out of range value adjusted for column’ error?
  27. MySQL Auto increment primary key increases by 10
  28. Escape line breaks in MySQL output
  29. MySQL Relationships
  30. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance

Leave a Comment