Compare Diffs and Sync Oracle Table Data

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 two or more tables, find the differences at a glance, and generate a script to effortlessly synchronize data. All this is done in a clear graphical interface.

Wide support for Oracle server versions and objects to be compared

Support for all Oracle versions, from 8i to 12c

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

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