New Data Compare version 5, part of the Oracle comparison tools, is now available.
from
$499

Data Compare for Oracle Database - The Tool to Get the Job Done

Synchronizes Oracle tables and views
Compares simple and complex data types
Handles large data sets quickly and efficiently
Provides plenty of options for fine-tuning the comparison
Generates data differences report
Supports variable transaction size that improves script execution
Includes a command line and a command line wizard
Data and Schema Compare
1-Year Subscription
$499
  • Contains Data Compare, including the Command Line and Command Line Wizard
  • Contains Schema Compare, including the Command Line and Command Line Wizard
  • Receives all patches, updates and major releases
  • Includes priority support via email
Data and Schema Compare
Lifetime, Perpetual License
$799
  • Contains Data Compare, including the Command Line and Command Line Wizard
  • Contains Schema Compare, including the Command Line and Command Line Wizard
  • Latest updates and releases available with a maintenance plan
  • Includes standard support via email
Data Compare Only
Lifetime, Perpetual License
$499
  • Contains Data Compare, including the Command Line and Command Line Wizard
  • Latest updates and releases available with a maintenance plan
  • Includes standard support via email

Top Features

Simple, modern interface

A multi-session capable interface reflects the latest standards in user interface design. Context-sensitive ribbon, action panels with clear descriptions, asynchronous implementation of lengthy operations, detailed progress information, are just of the features provided to you by the data compare.

Processing large data

Robust and highly efficient, our comparison engine handles millions of rows while tightly controlling resource utilization. There is no technical limit in the size of databases that Oracle Data Compare can synchronize.

Oracle type support

Data Compare supports all Oracle types, from simple types to the complex ones, such as user-defined types, nested types and more. Attention to details is a fundamental principal of Data Compare. Large-object fields (LOB), for example, are scripted correctly even when they exceed Oracle inline restrictions imposed on them.

One-click compare

Similar to all our comparison tools, Data Compare for Oracle Databases supports one-click compare via the saved sessions. A saved session contains the Oracle schemas, the login credentials, comparison options and other settings that allow you to repeat a previously-done comparison with a just single click, saving time and effort.

Custom mappings

Oracles tables and views, by default, are mapped with each other by name, and then compared and synchronized. Custom mappings allow you to pair them in any way that is suitable for your environment.

Custom comparison keys

To compare the data, Oracle tables must have a primary key, a unique constraint or a unique index. However, when a key does not exist, you can still compare the data by creating custom keys in Data Compare.

Data differences report

The data difference report, generated as an HTML file, allows you to view data differences or save them for archiving purposes. Various reporting filters, such as by object type or comparison status, make it easy to navigate complex Oracle schemas.

Command Line

The highly configurable Command Line utility allows you to run data comparisons in batch files or schedule them via Windows or third-party schedulers. A compact xml configuration file provides the command line with all the comparison settings, requiring nothing else.

Command Line Wizard

The Command Line Wizard allows you to manage the command line config files via a simple, wizard-based interface. You can also create command line configurations from the Data Compare UI. The wizard hides the complexity of the command line and creates consistent, optimized and always up-to-date config files.

Synchronizing data

Our script execution engine ensures that very large scripts are executed successfully while providing continuous progress information and allowing you to safely interrupt it if necessary. Custom transaction size allows Data Compare to break large scripts into more manageable chunks and execute them more efficiently.

Error handling

Systematic error handling aims at eliminate unexpected / unexplained results. Non-critical errors are registered, saved to files and reported. When possible, they do not interrupt the operation in progress.

Technical Information

Version

Version number: 5.0.0.0
Version date: August 01, 2019
To view the change history, click here.

Oracle Databases Supported

Data Compare support Oracle databases from 9i to 19c.

Subscription vs. Perpetual License

Data Compare can be purchased with a 1-year subscription or a lifetime, perpetual license. The subscription is, in general, a better value than the perpetual license. In addition to Data Compare, it includes Schema Compare for Oracle Databases and it receives all the updates that we publish during the time the subscription is active. A perpetual license can receive these updates only when you include a maintenance plan with it. If you're not certain which license is right for you, send us a note at sales@xsql.com and we will gladly help you.

Requirements

Data Compare for Oracle runs on Windows operating systems, client and server, that have the .NET framework 4.6 or higher installed.

A few additional notes on the comparison tools

For our thoughts as to why you would need the comparison tools and, most importantly, why good tools can make a big difference in your day-to-day activities, please take a look at our database comparison tools overview page.

Online Help

Click here to view the Data Compare online help.

Software License Agreement

Click here to view the Software License Agreement.