Data Compare for Oracle 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 eliminating unexpected / unexplained results. Non-critical errors are registered and reported. When possible, they do not interrupt the operation in progress.

Schema Compare for Oracle Features:

• Simple and intuitive interface: The user-interface, elements of which are shared by all xSQL Software comparison tools, has been designed for simplicity. The context-sensitive ribbon, action panels with clear descriptions, context-sensitive menus, all these elements provide a quick and easy access to Schema Compare functions and operations.
• One-click compare: Similar to all our comparison tools, Schema 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.
• Plenty of options: A comparison tool is not much without options to tailor its operations, even more so when handling a complex database system such as Oracle. Schema Compare exposes over 100 comparison options that control every feature from comparison to scripting and execution. Options are organized into categories, with the more complex ones listed under the advanced options.
• Standardized, version-safe scripts: The change script, generated by the comparison engine, includes warnings and a synchronization log that keeps track of the objects that are being changed. The version-aware principle of the scripting engine ensures that the change script contains only features supported by the target Oracle schema.
• Html schema differences report: The schema differences report, generated as an Html file, allows you to explore schema difference or archive them for later viewing. The report provides filtering and other features that make it easy to navigate complex Oracle schemas.
• Command Line: The highly configurable Command Line utility allows you to run schema 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 Schema Compare UI. The wizard hides the complexity of the command line and creates consistent, optimized and always up-to-date config files.
• Schema snapshot: Schema snapshot saves the Oracle schemas, without data, in a file with a proprietary format. It allows you to not only maintain a history of the schema changes, but it also provides a safe way for reversing schema changes if necessary. Simply compare the schema to a snapshot of itself, taken right before the changes were made, and generate the script for reversing changes made after the snapshot was taken.