Oracle Database
Compare Tool

Everyone who works with Oracle databases needs to synchronize them regularly. dbForge Studio for Oracle provides functionality that lets you visually detect the differences and set up a safe and accurate database schema synchronization without data loss. By means of dbForge Studio for Oracle, you will be able to save time and perform the sync process automatically.

  • Gain time comparing and synchronizing Oracle database schemas and data
  • Deliver updates from development databases to staging or production
  • Generate SQL*Plus scripts to update a schema or data to match another
  • Minimize system downtime caused by table data replication errors
  • Compare table structure in the same or different Oracle databases
  • Make schema snapshots for savepoints in database development
  • Automate migration of schema or data changes via command-line interface
  • Report schema and table diffs in HTML and Microsoft Excel file formats
  • Refine Oracle schema versioning using source control integration

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

Routine Task Automation

To save hours spent on routine tasks, you can use the command-line interface of dbForge Studio for Oracle and automatically perform schema synchronization and schema comparison, format code, export and import database schema. Besides, you will be able to save the comparison project settings for continued use.

Oracle Database Compare Tool - Automating tasks via command-line interface

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

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 different ways. A comparison report with actual data can be generated in Excel or HTML format.

Oracle Database Compare Tool - Analyzing the results

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 on the Summary page.

Oracle Database Compare Tool - Synchronizing data

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.

Oracle Database Compare Tool - Synchronization Script

Command-line automation

Enhance your efficiency by automating the tasks through the command-line interface of the Studio. This feature enables you to create a command-line execution file and perform routine data comparison and synchronization via an intuitive interface. You can also schedule routine execution with Windows Scheduler or enable Powershell and run automation scripts there.

Setting up command-line execution of routine data comparison and sync

Conclusion

dbForge Studio for Oracle delivers robust functionality that allows users to perform a rich spectrum of comparison and synchronization tasks via a convenient interface and customize the processes to particular needs. You can minimize the time spent on finding differences and delivering updates to production and achieve maximum efficiency in your daily database routines. Oracle Studio has many more useful features that may come in handy and facilitate your database management.

dbForge Studio for Oracle

All-in-one Oracle GUI for efficient database management

Availability in the editions of dbForge Studio for Oracle

Feature

Enterprise
Professional
Standard
Express
Schema comparison and synchronization tool
Yes
Yes
None
None

* Express Edition does not support command line, schema export projects, auto deletion of old export files, compression, schema export files larger than 1MB.