About dbForge Compare Bundle for Oracle

Compare data in Oracle databases to detect changes.

dbForge Compare Bundle for Oracle includes dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle. dbForge Schema Compare for Oracle is a comprehensive tool for database schema comparison and synchronization that can be used both by application developers and database administrators (DBAs). This Oracle comparison tool helps you identify the impact of changes made to your database schema. It easily points out all differences and allows you to generate a customized Oracle schema synchronization script. dbForge Data Compare for Oracle is a powerful, fast, and easy-to-use tool for Oracle database comparison and synchronization. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data. All this is done in a clear graphical interface.

  • Advanced support for schema objects - With 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 comparison and synchronization options - Handy comparison wizards will help you to tune data and schema comparisons up to your needs. In particular, you can:
    • Compare multiple schemas
    • Include tables or views into data comparison by mask or individually
    • Exclude objects from data comparison by mask or individually
    • Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables)
    • Round float types
    • Ignore Case and Ignore Trailing Spaces options for string comparison
    • Ignore differences in identifier and keyword case
    • Compare wrapped and unwrapped PL/SQL objects
  • Analysis of comparison results - Both tools of the bundle feature Comparison Document, that is designed for convenient analysis of comparison results. It will help you to:
    • Filter and sort objects in result
    • View data differences for each pair of objects
    • Perform full-text search in data differences
    • View number of changes per column
    • Hide unmodified columns to simplify analysis
    • Generate data comparison report in Excel and HTML formats
    • Include actual data into report
    • Report on selected objects only
  • Smart sync - The bundle tools provide versatile ways to synchronize schemas and data and include flexible settings to customize the process to your needs.
    • Multiple ways to sync data: create and open, execute, save synchronization script
    • Migrate individual records, groups of records, or all data differences
    • Toggle synchronization direction to apply data changes to both databases
    • Rollback changes on error
    • Synchronize LOBs via files
    • Warnings on possible problems prior to synchronization
  • Routine task automation - Our Oracle compare tools provide the following features to optimize routine schema and data diffs management tasks:
    • Support for the command-line interface
    • Support for PowerShell
    • Saving comparison project settings for future use
    • Saving settings to a command line arguments file
    • Creation of command line execution file
    • Data report generation