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.