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 | + | + |