Oracle Data Compare

Oracle Data Compare is a tool for comparing and synchronizing the data in two Oracle databases. You can use it for data migration, auditing, replication verification, populating development databases with production data etc.

Oracle Data Compare supports Oracle 9i, Oracle 10g and Oracle 11g and it is fully functional for a trial period of three weeks.

Highlights


  • Compare tables, regular or materialized views
  • Synchronize simple or complex Oracle data types
  • Safely script LOB fields of any size
  • Generate transactional synchronization script
  • A wide range of options and settings
  • Intuitive GUI with support for one-click re-compare
  • Variable transaction size for script execution
  • Built-in support for Oracle unicode data
  • Command line for unattended comparison

Requirements


Data Compare for Oracle runs on Windows operating systems, client and server, that have the .NET framework 4.0 (full) and Oracle ODP.NET version 11.1.0.6.20 (Oracle.DataAccess .NET version 2.111.6.20) or higher.

Version Information


    Major Version
  • Version Number: 1.0
  • Release Date: October 06, 2011
    Current Version
  • Version Number: 1.2.1.0
  • Release Date: June 03, 2013

Features


Modern GUI - Oracle Data Compare's multi-comparison capable GUI reflects the latest standards in user interface design. Context sensitive ribbon, action panels with clear descriptions, asynchronous implementation of lengthy operations, detailed progress information and more.

Comparison Engine - robust, highly efficient comparison engine handles millions of rows fast while tightly controlling resource utilization. There is no technical limit in the size of databases that Oracle Data Compare can synchronize.

Oracle Data Type support - Oracle Data Compare supports simple and complex data types. Large-object fields (LOB) are properly scripted even when they reach or exceed Oracle inline restrictions for such fields.

One-click re-compare - Oracle Data Compare maintains a comparison session history. A session is a persisted environment that contains all the data related to a comparison operation including databases and the respective credentials, comparison options, mapping rules, excluded objects and many more. It allows the end-user to repeat a comparison with a single click.

Custom mapping - the mapping rules feature allows you to customize the way database objects are paired together. Database objects are mapped based on the selected schemas and a set of "Name mapping rules", which can be customized.

Oracle Connections - Oracle Data Compare supports four types of connections. You can choose between Basic Connection, TNS Identifier, Easy-Connect method or Connect Descriptor method. Built-in parameters control the connection timeout and other Oracle settings.

Custom comparison keys - need to compare tables or views but they are showing as non-comparable because there is no primary key or unique indexes defined on them? Once Oracle Data Compare has analyzed the schema it will allow you to define a unique key (any combination of the fields) to use for the comparison. The rows are paired based on the selected key.

Command Line utility - the included, highly configurable command line utility allows you to perform unattended comparison or schedule comparison and synchronization operations via the Windows Task Scheduler or other third-party scheduler.

Full control over the comparison and synchronization - a wide array of options gives you granular control over the behavior of the comparison engine. Comparing views along with tables, analyzing table dependencies, variable transaction size are just some of the available options.

Handling large databases - Oracle Data Compare has been particularly designed to handle large databases. Custom built algorithms handle serialization of both data rows and script fragments as needed ensuring strict control of the memory utilization.

Script execution engine - the proprietary script execution engine ensures that very large scripts including scripts for LOB fields are executed successfully while providing continuous progress information and allowing you to safely interrupt the script if necessary.

Error handling - systematic error handling aims at eliminate unexpected / unexplained results. Non-critical errors are registered and reported but do not interrupt the operation. Errors are reported via dialog boxes or printed on the output panel. A full error log is created as well.

Pricing
Starting from: $349
Order
Related Products
You might be interested in the these products:
Additional Information