When comparing SQLyog vs Navicat for MySQL, the Slant community recommends Navicat for MySQL for most people. In the question“What are the best MySQL client applications for Windows?” Navicat for MySQL is ranked 2nd while SQLyog is ranked 7th. The most important reason people chose Navicat for MySQL is:
Navicat can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Easy to use and elegant UI
The UI is uncluttered and intuitive.
Pro Visual design of queries
Query builder is very intuitive and easy for designing very complex queries.
Pro Community version
There is a free/community version available here.
Pro Power tools
There are very useful power tools to do task like database synchronization, visual data comparison, Schedule backup with email notification. One can also schedule task with scheduler and will get report of task completion or error in email.
Pro Session restore
User can enable session restore to avoid loss of unsaved work.
Pro Data visualization
Pro Store model in project file
Pro Discounts for multiple users
Pro Free upgrades for 1 year included
Pro Unconditional 90-day money back policy
Pro Premium support option
Pro Personalized themes
Pro Fast and stable
Completely written in c/c++ using win32 api gives is edge in performance over other clients.
Pro Advanced connection options
It's possible to connect to any MySQL server with these powerful connection options - HTTP, SSH, SSL.
Pro Excellent choice of import/export options
Navicat can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc.
Pro HTTP/SSH tunnel
Navicat can upload a PHP script to enable HTTP tunneling or choose a SSH tunnel instead.
Pro Easy to use
Navicat manages an intuitive, easy to use UI without sacrificing functionality.
Pro Unicode support
Navicat has full unicode support.
Pro Data and structure synchronization
Navicat can compare and synchronize your data and structure between local and remote databases.
Pro User management
Navicat allows for simple user and access management.
Pro Light-weighted
Pro Cross-platform
Originally released on Windows, it has been ported to OS X and Linux.
Pro SQL code completion
Navicat supports auto-complete for SQL queries.
Pro Server monitoring
Allows you to monitor your server for inefficient queries, etc.
Pro Batch job scheduling
Navicat can schedule things like backups, restores, data transfers or report building.
Pro Visual query builder
Create and edit queries without writing SQL.
Pro Visual report builder
Navicat can build reports in a visual way. Once set up, the process can be scheduled.
Cons
Con Premium support at an additional cost
Con Cost
Pricing starts at $69 and goes up to $299.
Con Buggy
Navicat tends to release builds that have some problems, but they usually release a patched version soon after. Also have had issues with import/export and tunneling.
Con Still buggy, not getting better with updates
This software is way to buggy for a premium priced product. Have done many payed upgrades but I will not do a next payed upgrade. I am done with all the crashing and me losing time with this piece of software. Looking for an alternative.
Con Cost
The cost of a license ranges from $119-$299.