EMS logo

Products Navigation

SQL Manager for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

On-line Documentation

Feature matrix


The FREE Lite version of SQL Manager for MySQL does not include all features of the Full version and has some limitations concerning the number of the databases that can be registered and the set of data manipulation and server maintenance tools. The detailed feature matrix is given below.

 

Note that when using the FREE Lite version of SQL Manager for MySQL you can activate a 30-day period of fully-functional usage. After the period expires, you will be able to continue using the Lite version.

 

For more information on activating the Full version features see Full Mode activation.

 

Full version Lite version
Full support of MySQL versions from 4.1 to 8.0
Support of all MySQL objects (Tables, Views, UDFs, Stored Procedures and Functions, Triggers and Events)
+
+
Support of all MySQL features and extensions
+
+
Support of UTF8 data
+
+
New state-of-the-art graphical user interface
Office 11 and Windows XP visual schemes support
+
+
Well-described Wizard System
+
+
Improved database explorer for easy managing of all MySQL objects
+
+
Windows Toolbar to switch between windows easily, like in Windows Task Bar
+
+
Navigation bars with hot actions in most of the windows
+
+
Ability to save all program settings
+
+
Customizable toolbars for all program windows
+
+
Fully customizable program interface
+
+
Powerful visual options module
+
+
Localizable program interface
+
+
Rapid database management and navigation
Multiple host/database connections
+
+
Connection to MySQL Server through HTTP
+
+
Connection to MySQL Server through SSH
+
-
Connection to MySQL Server using SSL
+
+
Registering selected databases to work with
+
+
Projects to work with the selected database objects only
+
+
Multiple user-defined tabs for any tree node to access it in one-click
+
+
Working with multiple selected objects at a time
+
+
Grouping/Ungrouping registered databases by host name
+
+
Easy management of all MySQL objects
Ability to create/drop databases
+
+
Duplicating all database objects
+
+
Managing tables and all their subobjects: fields, indices, foreign keys and triggers
+
+
Managing views, stored functions and procedures, user-defined functions (UDF), scheduled events
+
+
Debugging of procedures, functions, triggers and events
+
-
Duplicating all database objects
+
+
Renaming all database objects
+
+
Viewing dependencies between database objects
+
+
Advanced data manipulation tools
Powerful BLOB viewer/editor with several types of viewing BLOB data
+
-
Master-detail view to work with two linked tables at the same time
+
-
Table and card views to see data the way you like
+
-
Ability to copy and paste selected records
+
-
Exporting data to SQL script as INSERT statement
+
-
Support of queries returning Multiple Result sets
+
+
View, edit, search, group, sort, filter any data stored in registered database
+
+
Effective security management
Powerful user manager for administering users and privileges
+
+
Grant manager displaying all database object grants in the form of a grid
+
+
Excellent visual and text tools for query building
Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
+
-
Multiple SQL editors with code completion and syntax highlight
+
+
Large script executing (SQL script editor)
+
+
SQL Formatter (Available from SQL Editor context menu)
+
-
Favorite Queries (Save and use your frequently used queries easily)
+
+
Report designer with clear in use report construction wizard
Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree
+
-
Create Report Wizard allows you to create simple reports in a few clicks
+
-
Impressive data export and import capabilities
Copying metadata and data from one database to another as a whole or partially
+
-
Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc
+
-
Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
+
-
Wizards for copying data from/to file on server
+
-
Export as PHP page Wizard
+
-
Powerful Visual Database Designer
Useful diagram navigation tool
+
-
Reverse engineering
+
-
Several pages in one diagram to divide diagram into different subject areas
+
-
Ability to create/edit/drop database objects, visually set links between them
+
-
Virtual objects such as comments and virtual relationship
+
-
Saving as image or printing database diagram
+
-
A lot of visual customization options
+
-
Easy-to-use wizards performing MySQL services
Dumping database
+
+
Restoring database
+
+
Backing up tables
+
-
Restoring tables
+
-
Analyzing tables
+
-
Checking tables
+
-
Repairing tables
+
-
Optimizing tables
+
-
Changing tables’ engine
+
-
Other useful tools to make your work with MySQL server as easy as it can be
Extracting metadata into text files or SQL script editor
+
+
Powerful print metadata module for creating customizable metadata reports
+
-
HTML report generator to create a detailed HTML report about your database quickly
+
-
SQL Monitor
+
+
Server Properties tool to view and change system variables, to view server status information
+
-
Comparison and synchronization of database structure
+
-
...and other useful features
Keyboard templates
+
+
To-do list
+
+
External tool manager
+
+