dbForge Fusion for SQL Server Editions

Professional is an ultimate package for database development and data management. The Professional edition provides the following functionality: database administration, database change management with help of database comparison and synchronization tools, complex queries creating, pivot table, data analysis, and reporting tools. The Professional edition also comprises all tools that are available in the Standard edition.

Standard includes all must-have tools for T-SQL developers, such as integrated SQL debugger, cutting-edge SQL editor with advanced code completion powered by SQL Complete, highly customizable code formatter, flat table editor, master-detail data browser, database objects browser, and database diagram.

Features

Pro

Std


Coding Assistance

SQL Coding Assistance

Code completion
Yes
Yes
SQL code formattings
Yes
Yes
SQL snippets
Yes
Yes
Quick database object information
Yes
Yes
"Go to definition" for database objects
Yes
Yes
Alias refactoring
Yes
Yes

Database Design

Database Design

Visual database editor
Yes
Yes
Database diagram tool
Yes
Yes
Visual table designer
Yes
Yes
Table DDL instant editing in T-SQL view of Visual table designer
Yes
No
View Dependencies
Yes
Yes

Database Synchronization

Database Synchronization

Schema comparison and synchronization tool
Yes
No
Schema snapshot creation
Yes
Yes
Schema snapshot comparison
Yes
No
Data comparison and synchronization tool
Yes
No
SQL Server backup support
Yes
No

Debugging and Diagnostics

Debugging and Diagnostics

T-SQL debugger
Yes
Yes
Query profiler
Yes
Yes

Data Manipulation

Data Manipulation and Reporting

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

Administration

Administration

Copy Database wizard
Yes
Yes
Database backup
Yes
Yes
Database restore
Yes
Yes

Data Pump

Data Pump

Data export wizard
Yes
Yes
Data import wizard
Yes
Yes
Schema export (Generate Scripts wizard)
Yes
No

Security Manager

Security Manager

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

Other Tools

Other Features

Database Explorer window with multi-selection tree
Yes
Yes
Filter settings at Database Explorer
Yes
Yes
Object Viewer for browsing of schema object properties
Yes
Yes
Database search (objects and data)
Yes
Yes
Connections coloring
Yes
Yes

General

General

SQL Server 2017, 2016 connectivity support
Yes
Yes
SQL Server 2014-2000 support
Yes
Yes
SQL Azure support
Click to view restrictions
Click to view restrictions
Amazon RDS support
Yes
Yes
Support for command-line interface*
No
No
Shortcut customization
Yes
Yes
Exporting/importing user settings
Yes
Yes
Single License Price
$499.95
$149.95

1 Limited functionality.

* Command-line interface support is available in dbForge Studio for SQL Server.