dbForge Data Compare for Oracle （英語版）

Oracleデータベースをすばやく安全に比較・同期

Devart 社の製品
2005 年より日本国内にてComponentSourceで販売中。

価格:¥ 47,740 (税込)〜 バージョン: 5.5.172 新機能 更新日: Feb 19, 2024

dbForge Data Compare for Oracle （英語版） のスクリーンショット

dbForge Data Compare for Oracle について

Oracleデータベースをすばやく安全に比較・同期

dbForge Data Compare for Oracle はパワフルで、高速、そして手軽なツールとしてOracle データベースの比較、同期ができます。テーブル中のデータ比較で相違の発見、データを期させるためのスクリプトの作成を素早く支援します。クリアなグラフィックインターフェース中で操作ができます。データベースのプロは dbForge Data Compare for Oracleを以下のように利用します:自動テーブルデータ同期化&比較で、時間を節約、データの相違を分析して、レポートの生成、同期しなくなった2つのデータベースを速く一致、開発用データベースから製品用データベースにルックアップデータをコピーSQL*Plusに互換性のある同期化スクリプトの生成等。

dbForge Data Compare for Oracle Features

  • Wide support for Oracle server versions and objects to be compared
    • Compare and synchronize data in tables, views, materialized views, custom queries, multiple Oracle schemas.
    • Compare databases with different structures.
  • Comparison and synchronization options
    • Include tables or views into comparison by mask or individually.
    • Exclude objects from comparison by mask or individually.
    • Ignore columns by mask (e.g. don't compare ModifiedDate column in all tables).
    • Float types rounding option.
    • Ignore Case and Ignore Trailing Spaces options for string comparison.
    • LOB comparison options.
    • WHERE filter for limiting data that needs to be compared.
    • User mapping allows comparing tables with different names and columns.
    • Map one table in source with two or more tables in target.
    • Custom Query feature allows comparing a table with a query result.
  • Data comparison and analysis
    • 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.
  • Automate routine tasks
    • Save comparison project settings for future use.
    • Save settings to a command line arguments file.
    • Compare data.
    • Multiple ways to sync data (execute script, save synchronization script).
    • Generate data report.
    • Execute script.
    • Format script.
  • Sync data
    • 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.

Standard Edition Includes:

  • Tables comparison.
  • Views comparison.
  • Materialized views comparison.
  • Custom mapping of tables (compare data with different structures).
  • Custom query comparison.
  • Compare columns with different data types.
  • Compare multiple schemas at once.
  • PL/SQL code completion.
  • PL/SQL code formatter.
  • Command-line interface for PL/SQL code formatting.
  • Query execution pane.
  • Command-line interface for data comparison and synchronization.
  • Data synchronization in LOB, BFILE and XML_TYPE columns.
  • WHERE filter for data filtering.
  • Data comparison reports.
  • Bi-directional data synchronization.
  • Generation of SQL*Plus-compatible synchronization scripts.
  • Work without an Oracle client.
  • Data comparison projects (save data comparison settings for the next usage).
  • Start page with recent comparison projects.
  • Additional comparison options.
  • Additional synchronization options.
  • Rollback synchronization on an error.
  • Restore last opened documents.
  • Connection coloring and document categories.