192a, Klochkovskaya St.,
Kharkiv,   61145 Ukraine
www.devart.ua

Solution Name

dbForge Studio for Oracle

Solution Summary

Powerful Oracle Database Development IDE

Solution Profile

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.

Distinguishing Features


PL/SQL coding assistant
Automatic code completion
Code snippets
Quick information on schema objects
Document outline for navigation
Smart formatting of SQL code

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

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

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

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

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)

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.

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

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

Database Administration
Tools for Oracle database administration and management serve for:
Managing user privileges
Managing server sessions
Monitoring events
AutoCommit mode

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.

Enterprise Edition Data Generator Database Documenter

Solution Name

dbForge Studio for Oracle

Solution Availability

Asia Pacific

Europe, Middle East, Africa

Latin America

North America

Industries

  • High Technology

Oracle Products

  • Database
  • Oracle Database Enterprise Edition
  • Oracle Database 11g Enterprise Edition
  • Oracle Database 11g Standard Edition
  • Oracle Database 12c Enterprise Edition
  • Oracle Database 12c Standard Edition
  • Windows

Company Size Solution is Targeting

No data available.

Open Source Solutions

No data available.

About Private scientific and production enterprise "DataSoft" (Private scientific and production enterprise "Data)

The partners listed in the Oracle PartnerNetwork (OPN) Solutions Catalog are part of the Oracle PartnerNetwork Program, however Oracle does not endorse any of the partners or their software, solutions, services or training listed on this site. Oracle disclaims any and all liability arising out of your use of the Oracle PartnerNetwork Solutions Catalog, including use of partners, software, solutions, services and training listed on the site.