SQLyog Features

Features of SQLyog

Compare between the editions of SQLyog MySQL Visual Editor
The following table shows the features included in the different editions of SQLyog.

EditionsUltimateEnterpriseProfessional
Features:
Core Features (See list below)
Optimizing Tools
Redundant Index Analyzer New!--
Schema Optimizer--
Query Profiling Tools
Query Profiler--
Advanced Connectivity Options
HTTP/HTTPs Tunneling
SSH Tunneling
SSL Connections
Visual Tools
SQL Formatter-
Visual Query Builder-
Visual Schema Designer-
Enhanced Services
Priority access to BETAs, new versions and patches
Installation support for 1 month
Unlimited Priority Support (Optional)
Enhanced Productivity
Smart Autocomplete
Intelligent Code Completion
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
Compressed Scheduled Backups New!-
Notification Services-
Job Manager-


SQLyog Core Features:

Internationalization

  • Complete Unicode/UTF8 Support

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

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

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