Alternative to Oracle Change Management Pack



Devart Team introduces dbForge Schema Compare for Oracle as an alternative to Oracle Change Management Pack.

These two solutions are intended to help database administrators (DBAs) and application developers to automate the process of promoting planned schema changes from development to production. They also help enterprises easily identify the impact of application upgrades on customizations and can pinpoint and remediate unplanned schema changes that are often the cause of application downtime.

Overview of Oracle Change Management Pack

Oracle Change Management Pack helps enterprises assess the impact of application upgrades by automatically identifying schema changes specific to each customization.

The tool can provide application developers with the specific details on each schema changes such as new columns added to tables, old indexes that were dropped or business logic changes made to PL/SQL based objects, so that they can modify their customization accordingly.

Using Oracle Change Management Pack, DBAs can pinpoint ad hoc changes made to production databases by comparing the current production environment with an established gold baseline standard representing the optimal state of the production database schema.

Upon identifying the missing or misconfigured schema objects, DBAs can restore the production environment to its original state by re-generating the relevant database objects from the established baseline standard.

Overview of dbForge Schema Compare for Oracle

dbForge Schema Compare for Oracle is a powerful, fast and easy-to-use tool for comparing and synchronizing Oracle database schemas. It helps you quickly compare schemas, find differences, generate scripts, and then effortlessly synchronize the Oracle database schemas. All this is done in a clear graphical interface.

The main features of our product are:

  • Broad support of Oracle 9i, 10, 11 R2 Express Edition, Oracle XE
  • Compares database structures across different server versions and correctly downgrades capabilities of the target database to the source database if needed.
  • Compares tables, views, functions, procedures, packages, DML triggers, sequences, synonyms, user types (object types, collections types), materialized views, materialized view logs, XML schemas, database links, Java sources, clusters.
  • Convenient and easy-to-follow wizards for comparison and synchronization.
  • Custom schema mapping.
  • Clear presentation of comparison results, extended opportunities for management.
  • Integrated SQL editor for advanced management of SQL scripts.
  • Customizable UI.

To get acquainted with all features of the tool, refer to the Features page.

Our product is similar to Oracle Change Management Pack, but has some features of its own allowing to:

  • Compare user comments on schema objects.
  • Compare per-object security permissions.
  • Ignore white spaces and comments in code.
  • Ignore differences in identifier and keyword case.
  • Compare wrapped and unwrapped PL/SQL objects.
  • Save comparison project settings for future use.
Schema Compare for Oracle: Customize Schema Comparison
  • Set objects in update scripts in the correct order by performing the dependency check.
  • Automatically resolve the synchronization issues.
  • See warnings on controversial points prior to synchronization.
Schema Compare for Oracle: Review Sync Warnings
  • Use command line interface for automatic routine synchronizations.
  • Create schema snapshots for audit and roll-back purposes.
  • Automatically commit snapshots to version control system.
  • Compare previous versions of schema with current one (source control integration).
Schema Compare for Oracle: Command Line Interface


Being an alternative to Oracle Change Management Pack, dbForge Schema Compare for Oracle will help you to compare Oracle schemas and quickly obtain the comparison results by completing just a few simple steps of Schema Comparison Wizard.

Our product is also stuffed with lots of features that will definitely help to perform the tasks associated with the schema comparison operation.