When comparing SQLyog vs SQL Workbench/J, the Slant community recommends SQL Workbench/J for most people. In the question“What are the best SQL clients for Linux?” SQL Workbench/J is ranked 9th while SQLyog is ranked 12th. The most important reason people chose SQL Workbench/J is:
Any changes to the database generate SQL statements that you can review and edit before running.
Specs
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 Allows you to edit changes before they are executed.
Any changes to the database generate SQL statements that you can review and edit before running.
Pro Works with almost any SQL database
Can work with any database with a jdbc driver.
Pro Can edit data in table mode.
Easy to make changes when viewing data.
Cons
Con Premium support at an additional cost
Con Cost
Pricing starts at $69 and goes up to $299.