Enhanced Connectivity Options:
HTTP/HTTPs Tunneling
SSH Tunneling
Migration Tools:
Wizard Driven Migration Toolkit
Import task can be scheduled for transferring data at regular intervals
Synchronization Tools:
Structure Synchronization
Checksum based Network Efficient Data Synchronization
Data Synchronization can be scheduled
Other Power Tools:
Scheduled Backups
Notification Services
Job Manager
Developer / User Productivity:
HTML Schema Documentation
Shortcuts to quickly generate SQL statements and paste object names
Learn MySQL by looking at the SQL generated by SQLyog
Multi-tab Query Editor and Result-set Editor
Multiple Query Execution
Multi-threaded Query execution with option 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
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
Dialogless 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
Profiling
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
Changes in SQLyog 8.1:
- the massive speed improvements in the following areas:
* Data synchronization
* Auto complete
* Export as SQL (including Scheduled Backups), CSV and XML
- the following major features:
* Completely revamped Objects tab. The tab has been renamed to Info. The contents are now available in nicely formatted HTML in addition to the old text format
* Direct import of Access, Excel and CSV files. Now you dont need to create ODBC DSN to import these file types. Just point to the files and SQLyog does the rest
- the following GUI changes:
* Added an option to preview SQL in CREATE/ALTER TABLE
* Column width in all GRIDs (not only DATA and RESULT tabs) are now persistent
* New GUI for defining ENUM and SET columns in Create/Alter GUI
* Some reorganisations of menus, improved captions and explanations in dialogues and wizards etc
Homepage - http://www.webyog.com
