The following table shows the features included in Community & Enterprise Editions. Please use this as a guide to determine which edition is more suitable for you.
| Editions |
Enterprise |
Community |
|
Nag Screen and Text Links |
Nag Screen on startup displaying SQLyog Enterprise features |
|
|
Rotating text links showcasing SQLyog Enterprise features |
|
|
Visual Tools |
Visual Schema Designer |
|
|
Visual Query Builder |
|
|
Enhanced Services |
Priority access to BETAs, new versions and patches |
|
|
Unlimited ticket-based support for one year |
|
|
Enhanced Productivity |
Smart Autocomplete |
|
|
Intelligent Code Completion |
|
|
Advanced Connectivity Options |
HTTP/HTTPs Tunneling |
|
|
SSH Tunneling |
|
|
SSL Connections |
|
|
Migration Tools |
Wizard Driven Migration Toolkit |
|
|
Import tasks can be scheduled |
|
|
Synchronization Tools |
Schema Synchronization |
|
|
Data Synchronization |
|
|
Data Synchronization can be scheduled |
|
|
Other Power Tools |
Scheduled Backups |
|
|
Notification Services |
|
|
Job Manager |
|
|
Internationalization |
Complete Unicode/UTF8 Support |
|
|
Developer / User Productivity |
Favorites Manager |
|
|
HTML Schema Documentation |
|
|
Shortcuts to generate SQL DML statements from schema definition |
|
|
Creating/Dropping/Altering tables |
|
|
Multi-tab Query Editor and Result-set Editor |
|
|
Multiple Query Execution |
|
|
Multi-threaded Query execution - Ability to stop long running queries |
|
|
SQL Templates |
|
|
Excel-style grid interface to view/update resultsets |
|
|
Multi-format Blob editor |
|
|
View data in Grid/Text Mode |
|
|
ResultSet/Data Export to CSV/XML/HTML/Excel |
|
|
Full Support from 3.23.38 to the latest 5.x |
|
|
Support for all MySQL table handlers |
|
|
Excel friendly resultsets/table-data export to clipboard/file |
|
|
Dialog-less table and resultset editor |
|
|
DBA Productivity |
Restoring / Importing large SQL dumps |
|
|
MySQL 5.x objects support |
|
|
User Management |
|
|
Managing hosted MySQL |
|
|
Connection Manager |
|
|
Index Management |
|
|
Relationship/Foreign Key Manager |
|
|
Reorder Columns |
|
|
Copy objects to another Host with single click |
|
|
Table diagnostics |
|
|
Flush Tools |
|
|
Object Browser |
|
|
Creating/dropping database |
|
|
Optimized for managing Hosted MySQL |
|
|
Multiple database connections |
|
|
Technology |
Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way to communicate with MySQL server |
|
|
100% keyboard friendly |
|
|
Small compact binary |
|
|
Minimal use of Registry - easy migration of User Preferences by dragging and dropping config files. |
|
|
Non-cluttered look and feel, ability to show/hide panes |
|
|