When comparing Aqua Data Studio vs SQLyog, the Slant community recommends Aqua Data Studio for most people. In the question“What are the best SQL clients for Linux?” Aqua Data Studio is ranked 11th while SQLyog is ranked 12th.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Comparison tools
Pro Comprehensive list of server and database objects in GUI
Pro Query builder
Pro Rich interface as alternative for DBA queries
Show information that would require type queries with joins such as tool for object search.
Pro Import/Export data
Pro ER modeler
Pro Shortcuts for many actions for server management and security
Pro Tons of features
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.
Cons
Con Very expensive
Con Premium support at an additional cost
Con Cost
Pricing starts at $69 and goes up to $299.