Über dbForge Schema Compare for Oracle

Oracle-Schemata vergleichen und synchronisieren.

dbForge Schema Compare for Oracle is a tool that makes the comparison and synchronization of schemas quick and easy. It can compare multiple database schemas at once, completes the comparison process in seconds, provides a clear grid to analyze differences and generates an update script for accurate synchronization.

dbForge Schema Compare for Oracle Features

  • Schema Objects Support
    • With dbForge Schema Compare for Oracle, you can compare and synchronize the following schema objects:
      • Array type
      • Cluster
      • Database link
      • DML trigger
      • Function
      • Java source
      • Materialized view
      • Materialized view log
      • Object type
      • Materialized view log
      • Object type
      • Package
      • Synonym
      • Table
      • Table type
      • View
      • XML schema
      • Package
      • Procedure
      • Sequence
  • Rich Schema Comparison and Synchronization Options
    • User comments on schema objects.
    • Per-object security permissions.
    • Multiple Oracle schemas.
    • Ignore white spaces and comments in code.
    • Ignore differences in identifier and keyword case.
    • Compare wrapped and unwrapped PL/SQL objects.
  • Comparison Results Analysis
    • 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.
  • Schema Synchronization
    • Multiple ways to synchronize schemas.
    • 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.
  • Routine Tasks Automation
    • Save comparison project settings for future use.
    • Use command line interface for automatic routine synchronizations.
    • Code formatting.
    • Schema export and import.
  • Schema Snapshots and Version Control Integration
    • Schema snapshot generation.
    • Schema snapshot generation through the command line.
    • Integration with TFS and SVN.

Standard Edition includes:

  • Major schema objects comparison and synchronization.
  • Start page with recent comparison projects.
  • Schema comparison projects (saving schema comparison settings for the next usage).
  • Rich comparison options.
  • Cluster objects support.
  • Java source objects support.
  • Schema comparison reports in Excel and HTML formats.
  • PL/SQL code completion.
  • PL/SQL code formatter.
  • Schema snapshot generation and comparison.
  • Restore last opened documents.
  • Connection coloring and Document categories.
  • OS authentication.
  • Work without an Oracle client.
  • Query execution pane.
  • Schema export and import.

The Professional Edition includes everything in the Standard Edition plus:

  • Wrapped PL/SQL objects: compare and sync.
  • Permissions on schema objects: compare and sync.
  • Integration with version control systems.
  • Command-line interface for schema comparison and synchronization.
  • Formatting code through the command line.