PowerDIFF for ORACLE

PowerDIFF for ORACLE is a carefully designed and powerful database inspection and database comparison tool. It compares both structure and data of databases. Similar databases or similar sets of individual database objects (predefined by the user) are comparable to each other - efficiently and object by object.

The following database objects can be 'diffed out':

• Tables Structure - columns, constraints, defaults
• Tables Data - with WHEREs, almost all data types
• Indexes - columns, types
• Constraints - PK, FK, check
• Views - source code, data
• Procedures, Functions - source code, status
• Trigger - columns, source code, status
• User, Roles, Privileges - data
• Database instance parameter - data
• Metadata (storage/size parameter, cache flag...)

By a huge number of comparison settings this tool is highly customizable in order to focus exactly on your requirements. Almost any conceivable 'comparison case' is possible.

The output can either be visualized or reported as total difference script. This SQL script (containing DDL und DML statements) can be applied afterwards to sync one database (or one set of database objects) to the other. For this purpose PowerDIFF comes with a powerful command line interface - based on SQL*Plus.

Application fields of PowerDIFF:

• Database application development + documentation
• Database inspection / verification / quality assurance
• Database distribution / deployment / transportation
• Database application change maintenance
• Migration and administration of databases.
• Optimization and tuning of databases.

PowerDIFF - the ultimate database diff tool.