Oracle Database Compare Tool

Everyone who works with Oracle databases has to synchronize them from time to time. dbForge Studio for Oracle provides functionality that lets you visually see the differences and set up a safe and accurate database schema synchronization process without data loss.

Comparing schemas

Setting up the comparison process

Before synchronizing schemas, you should first compare them. For this, you can use the schema comparison functionality provided in dbForge Studio for Oracle. The New Schema Comparison wizard enables you to compare databases, snapshots, or versioned snapshots. A rich set of comparison options and an object filter make the comparison process highly customizable.

Oracle Database Compare Tool - New Schema Comparison Wizard

Analyzing the comparison results

After the comparison is completed, a neat grid with comparison results will be presented to you. You can manage the results as required: filter, group, view differences between objects, exclude objects from synchronization, etc. You can also save the comparison settings for future use and generate comparison reports.

Oracle Database Compare Tool - Comparison Results

Selecting synchronization options

Now, you can proceed to schema synchronization. Click the Synchronize... button to open the Schema Synchronization Wizard, where you can set options, select dependencies, view synchronization issues and the summary. The wizard prompts you to select one of the three output options to manage synchronization scripts.

Oracle Database Compare Tool - Schema Synchronization Wizard

Synchronization script

If you choose Open the synchronization script in the internal editor, the generated synchronization script will be opened in SQL Editor. You can review the script, make changes, and execute the script to finish synchronization.

Oracle Database Compare Tool - Synchronization Script

Comparing data

Setting up the comparison process

First, you should compare the data contained at the source and the target. The Data Comparison wizard allows you to quickly compare chosen sets of data and fine-tune the comparison process - it provides various comparison Options (for example, comparing views in addition to tables) and the ability to customize Mapping.

Setting up the comparison process
Analyzing the results

Analyzing the results

When the comparison process is finished, a Data Comparison document will be presented. Here, you can filter and sort the resulting information, perform full-text search in data differences, hide unmodified columns to simplify further analysis and generally manage the results in dfferent ways. A comparison report containing actual data can be generated either in Excel or HTML format.

Synchronizing data

Now, you can use the Data Synchronization wizard. You can manually specify which tables and even which records to synchronize. You can view any synchronization warnings and other information at the Summary page.

Synchronizing data
Synchronization script

Creating a synchronization script

The Data Synchronization wizard also allows you to create an update script for the target database and save it to a file - you can view the script structure and edit it at the Action Plan tab.

Availability in editions of dbForge Studio for Oracle

Feature

Ent

Pro

Std

Exp

Schema comparison and synchronization tool
Yes
Yes
No
No