Oracle Schema Comparison Tool

dbForge Schema Compare for Oracle is a comprehensive tool for comparing and synchronizing schemas from databases, script folders, snapshots, and backups. The Schema Compare tool can become a great assistant when you need to analyze the impact of changes made to your database schema, identify all differences between Oracle databases, and generate a customizable Oracle schema comparison script.

Save time comparing and synchronizing Oracle database schemas
Generate SQL*Plus scripts to update one schema with another
Apply updates from development databases to staging or production
Compare table structure in the same or different Oracle databases
Make schema snapshots for savepoints in database development
Automate migration of schema changes using command-line interface
Report schema diffs in HTML and Microsoft Excel file formats
Improve Oracle schema versioning using source control integration

Features

Fast Schema Comparison

When comparing schemas in the New Comparison wizard, you can disable the dependency analysis option that will allow you to describe only objects you have chosen on the Object Filter tab. In this case, the synchronization script will not be generated.

The Disable Dependency Analysis option will prevent you from wasting your time on analyzing dependencies.

Selecting the Disable Dependency Analysis option

PL/SQL Code Comparison

With dbForge Schema Compare for Oracle, you can easily compare PL/SQL objects and customize the workflow by selecting the options in the Script Objects section on the Options tab:

Compare wrapped and unwrapped PL/SQL objects
Ignore case
Ignore comments
Ignore double quotes in PL/SQL blocks
Ignore white spaces

Routine Tasks Automation

Automating and scheduling routine tasks can help you save time and improve comparing and synchronizing efficiency with the following capabilities:

Save comparison project settings for future use
Use command line interface for automatic routine synchronizations
Code formatting
Schema export and import
Create command line execution files to run routine schema comparison and synchronization tasks
Run PowerShell automation scripts

Automating routine tasks through the command line interface

Comparison Result Analysis

The feature allows generating and customizing a comparison report specific to your needs.

Filter and sort objects in the comparison results grid
View DDL differences for object pair
View a schema update script
Group objects in the comparison results report by status, object type or operation
Exclude the selected schema objects from the comparison report

Actions you can perform with the objects on the comparison results grid

Export Comparison Reports

You can generate a schema comparison report in HTML, Excel, XML, and XML for Excel file formats and specify a name and a locaion where the file will be stored.

In addition, you can include the following objects to the comparison report:

Objects with differences
Objects selected for synchronization
Identical objects and comparison options

and group them by status and object type.

Actions you can perform with the objects in the comparison results grid

Supported Data

To compare and synchronize schemas, you can use the following data types as a source and a target:

Database
Snapshot
Versioned snapshot

After you configure the comparison and mapping settings, the data comparison results will be displayed on the data grid.

Supported Schema Objects

With dbForge Schema Compare for Oracle, the following schema objects can be compared and synchronized:

Array type
Cluster
Database link
DML trigger
Function
Java source
Materialized view
Materialized view log
Object type
Package
View

Schema objects that can be compared and synchronized

Schema Snapshots and Version Control Integration

dbForge Schema Compare for Oracle allows you to drastically simplify the management of schema comparison versions and ensures you can work with the latest and updated snapshot version.

Schema snapshot generation
Schema snapshot generation through the command line
Support for Team Foundation Server, Apache Subversion, Git, Mercurial, Perforce(P4), and SourceGear Vault
Create schema snapshots for audit and rollback purposes

Support for schema snapshots and version control systems

Schema Synchronization

The Schema Synchronization features managing options to make a schema synchronization process more effective.

Multiple ways to synchronize schemas
Migrate any schema differences (individual, selected, or all)
Dependency check to script objects in the correct order for updates
Resolve synchronization issues
Warnings on controversial points prior to synchronization
Create a custom synchronization script
Perform additional scripts before and/or after data synchronization

Review synchronization actions and warnings to be performed when synchronizing Oracle schemas

Schema Comparison and Synchronization Options

If you want to filter a schema comparison process to specific objects and, thus, reduce the time required to perform this process, you can use the following comparison and synchronization options: