Data Comparison for Oracle Databases is a tool that allows you to compare the data content of Oracle schemas. Whether the entire schema or specific tables, simple or complex Oracle types, millions of rows, or just a subset of them, data comparison is performed.
Data Comparison for Oracle Databases is a tool that allows you to compare the data content of Oracle schemas. Whether the entire schema or specific tables, simple or complex Oracle types, millions of rows, or just a subset of them, data comparison is performed.
It improves transaction handling, supports custom settings for Oracle connections, includes a new command-line utility, and a wizard for managing command-line configurations.
Overview
Lights
Requirements
Data Compare for Oracle runs on Windows, client, and server operating systems, which have the .NET framework or higher installed.
Resources
Modern GUI - A GUI with multiple comparison capability reflects the latest patterns in UI design. Context-sensitive ribbon, action dashboards with clear descriptions, asynchronous implementation of time-consuming operations, detailed progress information, and more.
Comparison engine - The robust and highly efficient comparison mechanism handles millions of rows quickly while tightly controlling resource utilization. There is no technical limit on the size of the 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 scripted appropriate even when they reach or exceed Oracle's inline constraints for those fields.
One-click comparison - Oracle Data Compare maintains a history of comparison sessions. A session is a persistent environment that contains all data related to a comparison operation, including databases and their credentials, comparison options, mapping rules, deleted objects, and more. It allows the end user to repeat a comparison with a single click.
Custom mapping - The mapping rules feature lets you customize the way database objects are paired. 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 three types of connections. You can choose between Basic Connection, Easy-Connect method, or Connect Descriptor method. Built-in parameters control the connection timeout and other Oracle settings.
Custom comparison keys - is it necessary to compare tables or visualizations, but are they shown as non-comparable because there are no primary key or unique indexes defined in them? After Oracle Data Compare analyzes the schema, you can define a unique key (any combination of fields) to use in the comparison. The lines are paired based on the selected key.
Command-line utility - The included highly configurable command-line utility lets you perform standalone comparisons or schedule comparison and synchronization operations through the Windows Task Scheduler or another third-party scheduler.
Command-line wizard - The wizard allows you to manage the command-line configuration file. It creates a consistent, optimized, and always-up-to-date xml configuration file, even for the most complex comparison scenarios.
Full control over comparison - A wide variety of options provides granular control over the behavior of the comparison engine. Comparing visualizations with tables, analyzing table dependencies, variable transaction size are just some of the options available.
Manipulating Large Data - Oracle Data Compare is specially designed to handle large data sets. Custom algorithms deal with big data, ensuring strict control of memory usage.
Script execution engine - The proprietary script execution engine ensures that very large scripts, including scripts for LOB fields, run successfully, providing continuous progress information and allowing the script to be safely disruptive if necessary.
Error handling - systematic error handling aims to eliminate unexpected/unexplained results. Non-critical errors are logged, saved to files, and reported, but do not interrupt the ongoing operation.
System requirements:
CPU: 1.8 GHz dual core processor
RAM: 2 GB
HDD / SSD: 50 GB of free space on the main drive
Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit
Resolution: 1024×768
You don't know what software you need or you haven't found what you were looking for? We have a team ready to help you choose the right software for your company.