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.
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.
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:
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:
You can now export data to SQL format.
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:
Explore and analyze master-detail data in a convenient browser with the following features:
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.
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.
Schema Export wizard has been totally redesigned to provide more freedom for exporting schemas. It features the following:
Object Viewer provides an easy way for analyzing objects and their structure right from Database Explorer. It offers:
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’.
Query Profiler tool was reworked for more convenient usage and extended with session statistics:
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 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 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.
New functional start page providing the easiest way to learn the product’s features and to run the most frequently used ones added.
Four new UI skins are added to improve the application appearance.
SQL Intellisense functionality is improved to make coding easier. Extended code completion, quick object information, code snippets will simplify your work.
The following search and replace functionality is added:
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.