dbForge Data Compare for Oracle Features Overview

Wide support for Oracle server versions and objects to be compared

  • Support for all Oracle versions, from 9i to 18c
  • Can work without Oracle client (Oracle Direct connection)
  • Working with Oracle on Amazon RDS
  • Compare and synchronize data in tables, views, materialized views, custom queries, multiple Oracle schemas
  • Compare databases with different structures
Coding assistance

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
Comparison and synchronization options

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
Data Analysis

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
Automate routine tasks

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
Sync data

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.