DbForge Schema Compare for Oracle Product Review

From Oracle FAQ
Jump to: navigation, search
Devart-dbforge-sc-oracle-logo.png

Reviewer: Julia
Date: June 8th, 2011

Contents


[edit] Summary

dbForge Schema Compare for Oracle is a comprehensive tool for database schema comparison and synchronization. This Oracle comparison tool helps identifying the impact of changes made to the database schema by easily pointing out all differences and allowing to generate customized Oracle schema synchronization script.

[edit] What tasks does it solve?

Using dbForge Schema Compare for Oracle, Oracle developers and DBAs can:

  • Compare and synchronize Oracle database schemas
  • Analyze an impact of application upgrades on a database
  • Generate schema comparison reports in Excel and HTML formats
  • Eliminate mistakes in schema changes propagation across the environments
  • Track production database changes and customizations
  • Export Oracle schema to SQL
  • Generate SQL*Plus script to update one schema to match another
  • Make schema snapshots for savepoints in database development process
  • Automate migration of schema changes using command line interface
  • Improve Oracle schema versioning using source control integration

[edit] Full feature list

Supported Oracle server versions

  • Oracle 11g, 10g, and 9i databases
  • Express Edition (Oracle XE) 11 R2, 10 databases
  • Snapshots of schemas (of all Oracle versions listed above)

Supported schema objects

  • Array type
  • Cluster
  • Database link
  • DML trigger
  • Function
  • Java source
  • Materialized view
  • Materialized view log
  • Object type
  • Package
  • Procedure
  • Sequence
  • Synonym
  • Table
  • Table type
  • View
  • XML schema

What else can be compared and synchronized?

  • User comments on schema objects
  • Per-object security permissions

PL/SQL code comparison features

  • Ignore white spaces and comments in code
  • Ignore differences in identifier and keyword case
  • Compare wrapped and unwrapped PL/SQL objects

How can I analyze comparison results?

  • Filter, group, and sort objects in results
  • View DDL differences for each pair of objects
  • Preview schema update script for each object
  • Generate schema comparison report in Excel and HTML formats

Synchronization features

  • Create accurate synchronization scripts
  • Migrate any schema differences (individual, selected, or all)
  • Dependency check to script objects in the correct order for updates
  • Automatic resolving of synchronization issues
  • Warnings on controversial points prior to synchronization

How can I automate my routine tasks?

  • Save comparison project settings for future use
  • Use command line interface for automatic routine synchronizations

Schema snapshots and version control integration

  • 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)

Other features

  • Compare and synchronize multiple Oracle schemas
  • Can work without Oracle client software

[edit] Installation

To install the tool, it is necessary to double-click the exe file and follow the prompts in the wizard. The tool can be upgraded using the built-in wizard. If a new version is available on the Devart website, you are automatically prompted about it when you start the tool.

[edit] Usage

dbForge Schema Compare for Oracle helps comparing database schemas, analyze differences between them, and synchronize these schemas.

[edit] Comparing database schemas

  1. Click New Schema Comparison on the product Start Page to open New Schema Comparison Wizard.
  2. Specify Type for Source and Target, Connection, and select the database schemas you want to compare in the Schema Mapping area.
    Devart dbForge Schema Compare for Oracle: New Comparison Wizard.jpg
  3. Set comparison options and define the objects you want to compare on other wizard pages.
  4. Click Compare to start the comparison process.

[edit] Analyzing comparison results

Comparison results are represented as a schema comparison document, where you can:

  1. Group and filter the results in the grid.
  2. See SQL differences of compared objects in the text comparer under the grid.
  3. Change update operations and include or exclude objects from synchronization directly in the grid.
Devart dbForge Schema Compare for Oracle: Comparison Results.jpg

[edit] Synchronizing database schemas

  1. To open Schema Synchronization Wizard, click Synchronize... on the toolbar.
  2. On the Output wizard page, select what you want to do with the Oracle synchronization script.
  3. Check the dependencies and issues, if any.
  4. Review action plan and warnings.
  5. Click Synchronize.
  6. Run the generated synchronization script by clicking F5 or save it for further usage.
Devart dbForge Schema Compare for Oracle: Synchronization script.jpg

[edit] Price and availability

The product is available in two editions: Standard and Professional.

Standard is a software that includes essential tools for schema comparison and synchronization. Professional is a fully-featured software able to complete any schema comparison and synchronization tasks and provide the best professional tricks to simplify your database management. Each edition is also available in dbForge Compare Bundle for Oracle that also includes dbForge Data Compare for Oracle. dbForge Schema Compare for Oracle license price starts at $149.95.

Benefits

  • 30-day fully-functional product trial
  • 30-day money-back guarantee policy
  • free 1-year subscription for updates and technical support

[edit] Product support

If you have any problems with the product or questions concerning it, you can send an e-mail to its developers or write them at the company forum, and you will be answered shortly. Also you are welcome to provide feedback and take part in different surveys, as well as send us suggestions concerning the product development.

[edit] Conclusion

With a clear GUI and simple logic, dbForge Schema Compare for Oracle is one of the most reliable tools for Oracle schema comparison and synchronization that can be applied by a wide range of people dealing with Oracle databases to accelerate application development, lower its lifecycle costs, reduce application downtime, eliminate errors during database upgrades, and increase the application development efficiency in general.