dbForge Studio for MySQL Editions

dbForge Studio for MySQL has three editions: Express, Standard, and Professional.

Express is a free software that provides basic functionality for working with schema objects, user accounts, SQL scripts, maintenance wizard, and queries.

Standard includes all must-have tools for database administrators and developers, such as a debugger, Query Builder, code templates, object search, export wizard.

Professional is a fully-featured software that facilitates your database management with the following functionality: database projects, accurate comparison and synchronization of database structures (schema comparison) or database content (data comparison), debugging stored procedures and scripts, complex queries creating, etc.

The matrix below compares features of dbForge Studio editions. (See the detailed list of all dbForge Studio features.)

Features Express Standard Professional
SQL Development
MySQL stored procedure debugger No Yes Yes
Query Profiler No Yes Yes
Context-sensitive code completion Click to view restrictions Yes Yes
Quick information about schema objects Click to view restrictions Yes Yes
Parameter information for stored routines Click to view restrictions Yes Yes
SQL code formatting No No Yes
Support of code refactoring No No Yes
Automatic SQL syntax check No No Yes
One step access to a schema object editor from code (go to definition) No Yes Yes
Visual Query Builder with support of sub-queries Click to view restrictions Yes Yes
SQL editor with syntax highlighting, bookmarks, and text searching Yes Yes Yes
Execution of scripts, selected SQL fragments, and statements Yes Yes Yes
Code templates library with the browser window No Yes Yes
Customizable DDL generation wizard No Yes Yes
Execution plan tool No Yes Yes
Database Design
Database Designer Click to view restrictions Click to view restrictions Yes
Schema comparison and synchronization tool No No Yes
Support of command-line interface for schema comparison and synchronization No No Yes
Dependencies lister No Yes Yes
Database project framework No No Yes
Schema object searching on a live database No Yes Yes
Visual editors for all MySQL schema objects Yes Yes Yes
Partitioning support for table editor No Yes Yes
Object Viewer window for quick browsing of schema object properties Yes Yes Yes
Database Administration
Security Manager to administer user accounts and privileges Yes Yes Yes
Session manager Yes Yes Yes
Server Variables window No Yes Yes
Service control for starting and stopping MySQL servers Yes Yes Yes
Table maintenance wizard and flush dialog Yes Yes Yes
Data Pump
Database backup and restore wizards Click to view restrictions Yes Yes
Support of command-line interface for database backup and restore No No Yes
Data comparison and synchronization tool No No Yes
Support of command-line interface for data comparison and synchronization No No Yes
Data import wizard Click to view restrictions Yes Yes
Data export wizard Click to view restrictions Yes Yes
Support of command-line interface for data import/export No No Yes
Data Analysis
Pivot tables No No Yes
Data reports No No Yes
Master-Detail Browser No Yes Yes
Data searching on a live database No Yes Yes
Data editor with in-place filtering, grouping, and sorting options Yes Yes Yes
General
Support of SSL/SSH/HTTP connections No Yes Yes
Work with MySQL embedded server Yes Yes Yes
Multiple database connections in Database Explorer window Yes Yes Yes
Dynamic help on MySQL accessible from the editor No Yes Yes
Full shortcut customization Yes Yes Yes
Rich user settings Yes Yes Yes
Wizards for exporting/importing user settings No Yes Yes
Single License Price Free $99.95 $199.95

1 Restricted to server-side objects only.

2 The number of tables is limited to 3, sub-queries are not supported.

3 The number of schema objects on a diagram in the Express edition is limited to 10, in the Standard edition is limited to 20.

4 It does not support backup projects, auto-deletion of old backup files, compression, and backup files larger than 1MB.

5 Restricted number of strings and supported formats. For Data Import, only import from CSV and ODBC formats is supported. For Data Export, only export to HTML, CSV, and ODBC formats is supported.