dbForge Compare Bundle for Oracle について

Oracleデータベースのデータを比較して相違点を検出

dbForge Compare Bundle for Oracle は2つの別個のツール、dbForge Schema compare for Oracle とdbForge Data Compare for Oracleを含んでいます。dbForge Data Compare for OracleはOralceデータベースでテーブルデータを比較して、そして同期することができます。dbForge Schema Compare for Oracle はOracleデータベース用のスキーマ変更マネジメントツールです。

  • 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
      • Package
      • Synonym
      • Table
      • Table type
      • View
      • XML schema
      • Package
      • Procedure
      • Sequence
  • Rich comparison and sync 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.
  • Profound 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 synchronization
    • The bundle tools provide versatile ways to sync 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 tasks automation
    • The 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.