What’s New in dbForge Studio for Oracle, v.3.0

Schema Comparison Tool

Being first released as a separate tool, dbForge Schema Compare for Oracle was integrated into dbForge Studio to provide even greater schema change management capabilities. It is a comprehensive tool for database schema comparison and synchronization that can be used both by application developers and database administrators (DBAs). This tool can become a great assistant when you need to identify the impact of changes made to your database schema, as it easily points out all differences and allows generating customized Oracle schema synchronization script.

Data Comparison Tool

Being first released as a separate tool, dbForge Data Compare for Oracle was integrated into dbForge Studio to provide smooth integration with the rest of functionality. It is a powerful, fast, and easy-to-use tool for Oracle table data comparison and synchronization. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data.

New Query Builder

Query Builder was completely re-designed to meet user needs. Now it allows you to build any complex queries visually. You can create sub-queries, add tables, create joins, or edit conditions with several clicks of the mouse. Following are the new features:

  • The state-of-art diagram with zooming and keyboard support
  • Preview and printing of the diagram
  • Visual addition of sub-queries to any part of the main query
  • Query outline (Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creating complex conditions
  • Copy/Paste for tables on the diagram
  • Undo/Redo support

Greatly Enhanced Data Editor

Over 50 new features and usability improvements were made to Data Editor to provide maximum freedom when working with data. Here are some of them:

  • Quick filtering feature is added
  • Foreign Key lookup editor is added
  • Server-side sorting and filtering is implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
  • Few indications are added to inform user about Data Editor’s state
  • Editing of tables in join statements is enabled now
  • Option for numbering records is added
  • Copying data to clipboard with header is added
  • Integration with charts, data reports, and pivot table component

Data Export to SQL

You can now export data to SQL format.

Powerful Data Export and Import

With Data Export and Import tools, you can export data from tables or views of your Oracle database, and after that you will be able to insert the exported data into the table you need. Data Export and Data Import provide the following features:

  • Easy-to use Data Export Wizard for exporting data to HTML, MS Excel, RTF, XML, ODBC, Text, MS Access, PDF, CSV, and DBF formats.
  • Highly customizable Data Import Wizard for importing data from CVS, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML formats.
  • Ability to export data from several tables at once
  • Possibility to export and import data from command line

Master-Detail browser

Explore and analyze master-detail data in a convenient browser with the following features:

  • Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
  • Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
  • The document allows saving and loading data and diagram for future use
  • Sorting and filtering data in the Data view
  • Ability to analyze self-referencing tables

Data Reports

Every user can benefit from a modern way of generating reports. Less time and manual work is required to get required data from a database, analyze, and print it as a smart, clear, and stylish report tuned for each particular case.

Pivot Table

Users can convert large amounts of data into compact and informative summaries - pivot tables. They can rearrange any obscure data by a simple drag of the mouse to get the layout that is best for understanding data relations and dependencies.

Redesigned Schema Export Wizard

Schema Export wizard has been totally redesigned to provide more freedom for exporting schemas. It features the following:

  • Capability to save export options for future use
  • Support of command line interface
  • Automatic archiving of schema backup scripts
  • Writing a report about export process into a log file
  • Automatic removing of old backup files based on date or quantity

Object Viewer - a simple way to view object’s details

Object Viewer provides an easy way for analyzing objects and their structure right from Database Explorer. It offers:

  • Three views to display properties, DDL (text), and data of the selected object
  • Inner navigation through object hierarchy
  • History with previously viewed objects
  • Extended information about each object in the Properties view

Quick generation of template SQL scripts for database objects

Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template CREATE, DROP, DROP and CREATE, SELECT, INSERT, UPDATE, or DELETE scripts for tables. This option is available in the shortcut menu and called ‘Generate Script As’.

Reworked Query Profiler

Query Profiler tool was reworked for more convenient usage and extended with session statistics:

  • Query plan is displayed in tree-list control in order to show execution step properties
  • Session statistics changes are captured to reflect query impact
  • Profiling history that can be saved for further analysis
  • Compare statistics results with differences highlight
  • Profiling results printing

Wizard for execution of large SQL scripts

The new version provides a special Execute Script Wizard to enable quick and convenient execution of large SQL scripts without waiting for their opening in the editor. It takes only to select a script and enjoy the executed result.

Code Snippets Manager

Code Templates feature is now renamed to Code Snippets and extended with the manager window for adding and editing SQL templates.

Import and Export Settings Wizard

Import and Export Settings Wizard allows you to export and import all your settings, layout, toolbars, keyboard shortcuts. Wizard also allows you to reset settings to their default values. You may export, import, and reset settings completely or partially.

Brand new start page

New functional start page providing the easiest way to learn the product’s features and to run the most frequently used ones added.

New state-of-the-art skins

Four new UI skins are added to improve the application appearance.

SQL Intellisense functionality improved

SQL Intellisense functionality is improved to make coding easier. Extended code completion, quick object information, code snippets will simplify your work.

Improved Security Manager

  • Ability to edit permissions for several users is added
  • Editing users and working with Security Manager window is simplified

Database Projects Improved

  • Building project to a single script
  • Building project to a collection of scripts
  • Multiple build configurations
  • Easy object deleting from project

Search and Replace Extended

The following search and replace functionality is added:

  • Search in data
  • Search in Data Viewer and LOB Editor
  • Search and replace in project files
  • Search and replace in files on disc

Filter toolbar in the Error List window

Filter toolbar is added to Error List window to show the quantity of errors, warnings, and messages. Also it filters the list of records, so that you can access the records of the selected type in one click.