What’s New in dbForge Fusion for Oracle, v3.5

The new version of dbForge Fusion for Oracle (formerly known as OraDeveloper Tools) has a different name and includes a whole pack of new features and extended old ones.

Integration

Integrates into Visual Studio 2012, Visual Studio 2013, and supports all IDE skins
One installation file to integrate the add-in into both Visual Studio 2010, 2012 and 2013: the required IDE can be selected during installation
Integrates into dotConnect for Oracle

Oracle Connectivity

Oracle 12c is supported
Working with Oracle on Amazon RDS is possible now

Improved database object editors

Editable column grid in the table editor now allows adding and editing columns without opening the popup dialog
Full-text search in the column grid in the table editor is added
Schema changes can now be viewed before updating database
Editor layout was revised, and now it allows viewing designer and table SQL simultaneously
F7 shortcut can now be used to toggle all editor views
Heuristics is supported: data type of the new column is suggested basing on the column name. For example, for CUSTOMER_ID column NUMBER data type will be suggested, and for CHANGE_DATE column DATE data type will be suggested.

Optimized application performance for working with Oracle servers

Database Explorer works faster now
Database object editors work faster now
Metadata for code completion is described faster now

New code formatter

Multiple formatting profiles
Extended options for formatting different clauses
Preview window for viewing formatted code with support of code highlighting and editing
Option quick search filter
Independent and precise adjustment for SQL-statements

Extended code completion capabilities

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

Suggestion of JOIN statements is added
Extended Oracle grammar support is added
Context-specific suggestions are improved
Full support of suggestions and PL/SQL grammar with context consideration is added
Code Templates features is now renamed to Code Snippets and extended with the manager window for adding and editing SQL templates.

Schema comparison tool

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

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

Newly added features and a few totally redesigned ones provide even more freedom when working with data:

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

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 exporting 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 gett 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 a 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 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 context 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.

Import and Export Settings Wizard

Import and Export Settings Wizard allows you to export and import all your connections, 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.