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 MySQL stored routine debugger, Query Builder, code snippets, object search, Data Export and Data Import wizards, etc.


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, functions, triggers, and scripts; complex queries creating; intelligent SQL coding with code suggestion feature, 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

SQL Development

MySQL stored procedure debugger No Yes Yes
Query Profiler No Yes Yes
Context-sensitive code completion Updated! Click to view restrictions Yes Yes
Quick information about schema objects Updated! Click to view restrictions Yes Yes
Parameter information for stored routines Updated! Click to view restrictions Yes Yes
SQL code formatting Updated! Click to view restrictions Yes Yes
Support of SQL 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 SELECT statement Click to view restrictions Yes Yes
Visual Query Builder with support of INSERT, UPDATE, and DELETE statements New! No Yes Yes
Visual Query Builder with support of sub-queries No Yes Yes
Quick INSERT statements generation from data grid without opening wizard New! No 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 Snippets Updated! No Yes Yes
Customizable DDL generation wizard No Yes Yes
Execution plan tool No Yes Yes
Database Design

Database Design

Database Designer Click to view restrictions Yes Yes
Database Refactoring New! No No 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 routine editors Updated! Yes Yes Yes
Flat table editor with heuristics support New! 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

Administration

Security Manager to administer user accounts and privileges Yes Yes Yes
Session manager Yes Yes Yes
Server Variables window Yes Yes Yes
Service control for starting and stopping MySQL servers Yes Yes Yes
Table maintenance wizard and flush dialog Yes Yes Yes
Data Pump

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 Updated! 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

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
Automated data report delivery New! No No Yes
General

General

Support of SSL/SSH/HTTP connections No Yes Yes
MySQL pluggable authentication and Windows authentication on connecting to MySQL server New! Yes Yes Yes
Amazon RDS Support New! Yes 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 $119.95 $249.95

1 Context-sensitive object suggestions for SELECT, INSERT, UPDATE, DELETE, and CALL statements.

2 SQL code formatting is available only for SELECT and DML statements.

3 The number of tables in query is limited to 3.

4 The number of schema objects on a diagram is limited to 10.

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

6 CSV format has no restrictions for data export and import, for other formats only first 50 rows are processed. User templates are not supported.



  • dbForge Studio for MySQL version 6.0
  • dbForge Studio for MySQL - Code Completion
  • dbForge Studio for MySQL - Database Administration
  • dbForge Studio for MySQL - Data Management
  • dbForge Studio for MySQL - Refactoring