Previous Next

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 synchronization process to achieve safe and accurate synchronization of database schemas without data loss.

Set up comparison process

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

Analyze 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. What is more, you can save comparison settings for future use and also generate comparison report.

Select synchronization options

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

Synchronization script

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

Availability in editions of dbForge Studio for Oracle





Schema comparison and synchronization tool