SQLyog MySQL GUI 8.05

1. Query Profiling Tools

• Query Profiler

2. Visual Tools

• SQL Formatter
• Visual Query Builder
• Visual Schema Designer

3. Migration Tools

• Wizard Driven Migration Toolkit
• Import tasks can be scheduled

4. Synchronization Tools

• Schema Synchronization
• Data Synchronization
• Data Synchronization can be scheduled

5. Other Power Tools

• Scheduled Backups
• Notification Services
• Job Manager

6. Internationalization

• Complete Unicode/UTF8 Support

7. 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
• Table duplication with two clicks

8. Licensing

• Perpetual Licensing
• Company wide Unlimited licensing at very attractive prices

9. Enhanced Productivity

• Smart Autocomplete
• Intelligent Code Completion
• Advanced Connectivity Options
• HTTP Tunneling
• HTTPs Tunneling
• SSH Tunneling
• SSL Connections

11. 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

12. 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

Enhancements:

• SQL Formatter, Query Profiler and Column Width Persistence in Result and Table data tab

Requirements: MySQL