| Full version | Lite version | |||
|---|---|---|---|---|
| Support of MySQL, MariaDB, Percona Server for MySQL, Amazon RDS for MySQL/MariaDB, Amazon Aurora | ||||
| Support of all MySQL objects (Tables, Views, UDFs, Stored Procedures and Functions, Triggers and Events) | ||||
| Support of all MySQL features and extensions | ||||
| Support of Unicode data and metadata | ||||
| Rapid database management and navigation | ||||
| Multiple host/database connections |
|
up to 5
|
||
| 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 | ||||
| Simple management of all MySQL objects | ||||
| Ability to create/drop databases | ||||
| Managing tables and all their subobjects: fields, indices, foreign keys and triggers | ||||
| Managing views, stored functions and procedures, user-defined functions (UDF), scheduled events | ||||
| Duplicating all database objects | ||||
| Debugging of procedures, functions, triggers and events | ||||
| Advanced data manipulation tools | ||||
| View, edit, search, group, sort, filter any data stored in registered database | ||||
| 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 | ||||
| Support of queries returning Multiple Result sets | ||||
| Ability to copy and paste selected records | ||||
| Exporting data to SQL script as INSERT statement | ||||
| Powerful security management | ||||
| Powerful user manager to administer 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, syntax highlight and code folding | ||||
| Large script execution (SQL script editor) | ||||
| SQL Formatter (Available from SQL Editor context menu) | ||||
| Favorite Queries (Save and use your frequently used queries easily) | ||||
| Impressive data export and import capabilities | ||||
| 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 | ||||
| Copying metadata and data from one database to another as a whole or partially | ||||
| Export as PHP page wizard | ||||
| Report designer with clear in use report construction wizard | ||||
| Create Report Wizard allows you to create simple reports in a few clicks | ||||
| Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree | ||||
| 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 | ||||
| Powerful Visual Database Designer | ||||
| Two diagram notations (IDEF1x and IE) | ||||
| 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 | ||||
| Analyzing tables | ||||
| Checking tables | ||||
| Repairing tables | ||||
| Optimizing tables | ||||
| Changing tables' engine | ||||
| Dumping Database | ||||
| New state-of-the-art graphical user interface | ||||
| The possibility to choose different visual schemes | ||||
| Well-described Wizard System | ||||
| Improved database explorer for easy management 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 | ||||
| Support of dark theme | ||||
| Localizable program interface | ||||
| And other useful features | ||||
| Keyboard templates | ||||
| To-do list | ||||
| External tool manager | ||||
