dbForge Data Compare for Oracle Features

What Oracle server versions are supported?

• Oracle 11g, 10g, 9i, and 8i databases
• Express Edition (Oracle XE) 11 R2, 10 databases

What can be compared and synchronized?

• Tables
• Views
• Materialized views
• Custom queries

Data comparison setup

• 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 (e.g. in extra large tables)

How can I compare data in two databases with different structures?

• User mapping feature allows comparing tables with different names and column set
• Map one table in source with two or more tables in target (useful when table was split)
• Custom Query feature allows comparing a table with a query result

How can I analyze comparison results?

• Filter and sort objects in results
• 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

How can I export data comparison results?

• Generate data comparison report in Excel and HTML formats
• Include actual data into report
• Report on selected objects only

Synchronization features

• Create accurate synchronization scripts
• 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

How can I automate my routine tasks?

• Save comparison project settings for future use
• Use command line interface for automatic routine synchronizations

Other features

• Compare and synchronize multiple Oracle schemas
• Can work without Oracle client software

View the list of features regarding editions at the Editions page.