Editions of dbForge Studio for Oracle

dbForge Studio for Oracle 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), 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

SQL Development

PL/SQL editor with syntax highlight, bookmarks, and text search Yes Yes Yes
PL/SQL debugger 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
Visual Query Builder Click to view restrictions Yes Yes
Navigation to a schema object editor from code No Yes Yes
Code snippets No Yes Yes
Customizable DDL generation wizard No Yes Yes
Query Profiler No Yes Yes
Highlight Occurrences No Yes Yes
Database Design

Database Design

Visual editors for schema objects Yes Yes Yes
Database projects No No Yes
Schema comparison and synchronization tool No No Yes
Database Diagrams Click to view restrictions Click to view restrictions Yes
Find object in a database No Yes Yes
Object Viewer window Yes Yes Yes
Dependencies lister No Yes Yes
Database Administration

Database Administration

Security Manager Yes Yes Yes
Session Manager Yes Yes Yes
Event Monitor Yes Yes Yes
Data Pump

Data Pump

Data comparison and synchronization tool No No Yes
Data import and data export Click to view restrictions Yes Yes
Schema export and import (dump) Click to view restrictions Yes Yes
Data Analysis

Data Analysis

Pivot tables No No Yes
Data reports No No Yes
Master-Detail Browser No Yes Yes
Find data record in a database No Yes Yes
Data editor with in-place filtering, grouping, and sorting Yes Yes Yes
General

General

Command-line interface No No Yes
Direct Oracle database connection (without client) No Yes Yes
Multiple database connections in Database Explorer window Yes Yes Yes
Full shortcut customization Yes Yes Yes
Wizards for exporting/importing user settings No Yes Yes
Single License Price Free $149.95 $299.99

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

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

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

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



dbForge Studio for Oracle