dbForge Data Compare for Oracle

Oracle 데이터베이스의 빠르고 안전한 데이터 비교 및 동기화.

Devart사에서 공개
2005년 부터 ComponentSource에서 판매중

가격: ￦ 320,700 버젼: 5.5.183 업데이스 날짜: Jul 9, 2024

dbForge Data Compare for Oracle 스크린샷

dbForge Data Compare for Oracle 관련 정보

Oracle 데이터베이스의 빠르고 안전한 데이터 비교 및 동기화.

dbForge Data Compare for Oracle is a powerful, fast, and easy tool for comparing and synchronizing Oracle databases. 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. Database professionals use dbForge Data Compare for Oracle to: save time with automatic table data comparing & synchronization, analyze data differences and generate reports, quickly reconcile two databases that went out of sync, copy look-up data from development databases to production, generate SQL*Plus-compatible synchronization scripts and more.

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.