Editions

dbForge Studio for MySQL Editions

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.

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.

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

Features

Pro

Std

Exp



Coding Assistance

SQL Development

Phrase completion
Yes
Yes
No
Quick INSERT statements generation from data grid without opening wizard
Yes
Yes
No
Execution of scripts, selected SQL fragments, and statements
Yes
Yes
Yes
Customizable DDL generation wizard
Yes
Yes
No
Execution plan tool
Yes
Yes
No


Database Design

Database Design

Dependencies lister
Yes
Yes
No
Visual routine editors
Yes
Yes
Yes
Flat table editor with heuristics support
Yes
Yes
Yes
Partitioning support for table editor
Yes
Yes
No
Object Viewer window for quick browsing of schema object properties
Yes
Yes
Yes
Administration

Administration

Security Manager to administer user accounts and privileges
Yes
Yes
Yes
Service control for starting and stopping MySQL servers
Yes
Yes
Yes
Data Pump

Data Pump

Data comparison and synchronization tool
Yes
No
No
Command-line interface for data import/export
Yes
No
No
Data Analysis

Data Analysis

Data searching on a live database
Yes
Yes
No
Data editor with in-place filtering, grouping, and sorting options
Yes
Yes
Yes
Automated data report delivery
Yes
No
No
General

General

Support for Sphinx and Percona
Click to view restrictions
Click to view restrictions
Click to view restrictions
Support for MySQL 5.6, 5.7 Updated
Yes
Yes
No
Support for MariaDB
Yes
Yes
No
Support for SSL/SSH/HTTP connections
Yes
Yes
No
MySQL pluggable authentication and Windows authentication on connecting to MySQL server
Yes
Yes
Yes
Percona PAM Authentication for MySQL New
Yes
Yes
Yes
Working with MySQL on Amazon RDS and
on Amazon Aurora Updated
Yes
Yes
Yes
Work with MySQL embedded server
Yes
Yes
Yes
Multiple database connections in Database Explorer window
Yes
Yes
Yes
Dynamic MySQL help accessible from the editor
Yes
Yes
No
Enhanced visual data editor
Yes
Yes
No
Connection coloring and document categories
Yes
Yes
No
Full shortcut customization
Yes
Yes
Yes
Rich user settings
Yes
Yes
Yes
Wizards for exporting/importing user settings
Yes
Yes
No
Single License Price
$249.95
$119.95
Free

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.

7 You can connect to Sphinx and work with SQL documents only. Code completion is not supported.