Previous Next

Powerful Oracle Database Development IDE!

dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data. This tool allows to synchronize data between different Oracle servers and automate schema change management process during development. It also adds lots of features wrapped into a smooth management GUI consistent with Microsoft Visual Studio.

PL/SQL coding assistant

  • Automatic code completion
  • Code snippets
  • Quick information on schema objects
  • Document outline for navigation
  • Smart formatting of SQL code
More on SQL coding

Database Project

Database project greatly helps you facilitate your database development:

  • Create a database project either empty or with imported database objects
  • Manage SQL scripts and query files in the project
  • Deploy either an entire project or only required changes to the server

More on database project

Database Change Management

When modifying Oracle database structure, transferring data between servers, analyzing differences between databases, you will:

  • Compare and sync data and schemas
  • Schedule regular database sync tasks
  • Generate comparison report

More on data comparison

Object Manager

Database objects are displayed as a tree in Database Explorer. To edit any object, you can call the corresponding visual editor from this window. You can:

  • Manage tables from one window
  • Use Undo option for object editor
  • Use ability to browse schema objects in a single editor (pin document)

More on object editors

Oracle PL/SQL Debugger

PL/SQL debugger serves for step-by-step execution of stored program units and SQL scripts. Use breakpoints, evaluate and modify variables in the Watches window, and analyze the currently active stack of your PL/SQL program calls in the Call Stack window.
More on PL/SQL Debugger

Query Profiler

Improve multi-second queries using Query Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:

  • Offers visual query profiling
  • Compares profiling results

More on query profiling

Schema Import/Export

Export full schema structure or selected schema objects, copy database objects using schema export/import wizards. While using the wizards, you can benefit from the following features:

  • Oracle export and import utility wizards
  • Schema export projects
  • Zip compression for export output files
  • Command-line support

More on schema export/import

Database Administration

Tools for Oracle database administration and management serve for:

  • Managing user privileges
  • Managing server sessions
  • Monitoring events

More on database administration

Database Designer

Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your Oracle databases and for:

  • Viewing foreign key relations
  • Displaying DB objects with properties
  • Execution of stored routines

More on database designer

Import/Export Data

Import and export Oracle data for filling databases. dbForge Studio can export data to 11 popular formats and import it from 8 formats. Data export/import process is customizable, and can be automated via the command-line interface.

More on data import/export

Report and Analysis

Data analysis and reporting are performed with the help of data reports, pivot tables, and viewing master-detail relations. Comprehensive wizards and tools can display data as charts and tables, and provide means for adjusting data layout, grouping, sorting, etc.

More on data reporting

What people say

This one fully meets my requirements towards database development. An excellent solution! Principally revised and improved as compared to OraDeveloper Studio. I am now happy with absolutely everything and moving to this product from Oracle SQL Developer. Thank you!

Boris Chernysh, System Administrator, PROFI Instrument

The product features an excellent functionality. The one thing it actually lacks is an option to export selected strings as an insert/update script in the Export from Grid mode.

Pavel Vinogradov, Leading Developer, ISD Ltd.