Previous Next

Editions of dbForge Studio for Oracle

Professional is an ultimate package for enterprise-level project management that provides the following functionality: database projects framework, database change management with help of database comparison and synchronization tools, complex queries creating, master-detail data browser, data analysis and reporting tools, tasks automation through the command line.

Standard edition extends the Express edition's functionality with Pivot Table Designer, PL/SQL Debugger, Query Profiler, advanced Coding Assistance features, and database search options. Moreover, this edition includes enhanced Query Builder, Data Export/Import features and command-line interface for data reporting.

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

Features

Pro

Std

Exp



Coding Assistance

SQL Development

PL/SQL formatter
Yes
Yes
No
Formatting code through the command line
Yes
No
No
Context-sensitive code completion
Yes
Yes
Click to view restrictions
Phrase completion
Yes
Yes
No
Quick information about schema objects
Yes
Yes
Click to view restrictions
Parameter information for stored routines
Yes
Yes
Click to view restrictions
Alias refactoring
Yes
Yes
No
Object refactoring
Yes
Yes
No
Navigation to the schema object editor from code
Yes
Yes
No
Code snippets
Yes
Yes
No
Customizable DDL generation wizard
Yes
Yes
No
Highlight occurrences
Yes
Yes
No
Database Design

Database Design

Command-line interface for schema comparison and synchronization
Yes
No
No
Find object in a database
Yes
Yes
No
Object Viewer window
Yes
Yes
Yes
Dependencies tree
Yes
Yes
No
Find and Recompile Invalid Objects
Yes
Yes
No
Administration

Administration



Data Pump

Data Pump

Command-line interface for data comparison and synchronization
Yes
No
No
Data import/export through the command line
Yes
No
No
Schema import/export through the command line
Yes
No
No
Schema snapshot generation
Yes
Yes
Yes
Schema snapshot generation through the command line
Yes
No
No
Integration with version control systems**
Yes
No
No
Data Manipulation

Data Analysis

Creating data reports through the command line
Yes
No
No
Automated data report delivery
Yes
No
No
Find data record in a database
Yes
Yes
No
Data editor with in-place filtering, grouping, and sorting Improved
Yes
Yes
Yes
General

General

Oracle 12c, 11g, 10g, 9i, 8i*, Oracle Express Edition (Oracle XE) 11 R2, 10 databases support
Yes
Yes
Yes
OS authentication
Yes
Yes
Yes
Restore last opened tabbed document
Yes
Yes
Yes
Connection coloring and document categories
Yes
Yes
No
Amazon RDS support
Yes
Yes
No
Direct Oracle database connection (without client)
Yes
Yes
No
Multiple database connections in Database Explorer window
Yes
Yes
Yes
Full shortcut customization
Yes
Yes
Yes
Wizards for exporting/importing user settings
Yes
Yes
No
Single License Price
$399.95
$149.95
Free

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.

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.

* These Oracle versions are not supported in data and schema compare tools.

** TFS and SVN only.