dbForge Studio for SQL Server Editions

dbForge Studio for SQL Server comes in three editions: Express, Standard, and Professional.

Express is a free edition that provides basic functionality for database development. It includes database Object Editor, security configuration tools, advanced Data Editor, and Export/Import from CSV and ODBC. Also this edition has basic support for SQL Coding Assistance and limited Query Builder features.

Standard edition extends the Express edition's functionality with T-SQL Debugger, Query Profiler, advanced SQL Coding Assistance features, and database search options. Moreover, this edition includes enhanced Query Builder and data Export/Import features.

Data Edition comprises all the functionality of the earlier existing product - Data Studio for SQL Server. Data Edition provides a set of dedicated tools to view, edit, analyze data, design data reports, and automate report delivery.


Professional is a fully-featured edition that provides additional functionality such as: database synchronization, Data Reports, Pivot Table Designer, and advanced SQL Coding Assistance. This edition also includes support for command-line interface for some components that allows you to automate routine operations.


The table below represents comparative data of available editions of dbForge Studio for SQL Server.

Features Professional Edition Data Edition Standard Edition Express Edition
SQL Coding Assistance

SQL Coding Assistance

Code completion Yes Click to view restrictions Yes Click to view restrictions
SQL code formatting Yes Click to view restrictions Click to view restrictions Click to view restrictions
SQL snippets Yes No Yes No
Quick database object information Yes Click to view restrictions Yes Click to view restrictions
Code navigation Yes No Yes No
Visual Query Builder Yes Yes Yes Click to view restrictions
Database Design

Database Design

Database diagram tool Yes No Yes Click to view restrictions
Visual table designer Yes Yes Yes No
Instant editing of table DDL in designer Yes No No No
Database Synchronization

Database Synchronization

Schema comparison and synchronization tool Yes No No No
Schema snapshot creation and comparison Yes No No No
Data comparison and synchronization tool Yes No No Yes
SQL Server backup support Yes No No No
Command line interface for database synchronization Yes No No No
Debugging and Diagnostics

Debugging and Diagnostics

T-SQL debugger Yes No Yes No
Query profiler Yes No Yes No
Data Manipulation

Data Manipulation

Data editor with in-place filtering, grouping, and sorting Yes Yes Yes Yes
Data report design and generation Yes No No Yes
Pivot table designer Yes No No No
Master-detail browser Yes No Yes Yes
Export and Import

Export/Import

Data export wizard Yes Yes Yes Click to view restrictions
Data import wizard Yes Yes Yes Click to view restrictions
Command-line interface for data import/export Yes No No Yes
Wizards for exporting/importing user settings Yes No Yes Yes
Security Manager

Security Manager

Visual editors for logins, users and roles Yes Yes Yes No
Visual tool for object permissions setup Yes Yes Yes No
Batch setup of permissions and role membership Yes Yes Yes No
Other Tools

Other Tools

Database Explorer window with multi-selection tree Yes Yes Yes Yes
Object Viewer for browsing of schema object properties Yes Yes Yes Yes
Database search (objects and data) Yes No Yes Yes
Single License Price $499.95 $249.95 $149.95 Free

1 Context-sensitive object suggestions available only for SELECT, DML, DROP, EXEC, SET, and USE statements.

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

3 Only basic information about object is shown.

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

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

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 SQL Server