PowerDIFF for ORACLE
- Compare Wizard Settings

The following key features are implemented in PowerDIFF:

• Customizing in PowerDIFF: For the visualization and comparison of objects you can select among a huge number of options. The most important settings are the following:

  Tables Settings	Trigger Settings
  Indexes Settings	Sequence Settings
  Constraints Settings	Compare Schema Settings
  Views Settings	Compare Data Settings
  Procedures Settings	Compare Globals Settings

• Structural comparisons: Almost all types of database objects are comparable to each other, with respect to their structural definition. This includes tables, indexes, constraints, views, triggers, procedures (for Oracle this means: functions, stored procedures, packages and package body definitions), sequences, users and finally (for Oracle) granted roles and privileges. The output of the comparison can be achieved visually in a browser tree (object by object) or by the creation of a total difference script.

  Table structure comparison	Procedure comparison
  Index comparison	Sequence comparison
  Constraint comparison	User comparison
  View structure comparison	Role comparison
  Trigger comparison	Privilege comparison

  1 => 2

  Total structure comparison script

  2 => 1

• Data comparisons: For tables (and views) a comparison of the table data (data behind the view) is possible. Data comparison is done line by line and column by column. Data comparison is further refinable by WHERE, ORDER BY and GROUP BY clauses following the object (table or view). Thus very individual compare runs - with a lot of special options - can be launched.

  Table data comparison

  Table data comparison + WHERE + ORDER BY

  Table data comparison based on only certain columns

  View data comparison

  1 => 2

  Total data comparison script

  2 => 1

• Define an arbitrary compare set: Arbitrary subsets of database objects can be selected in the first step (customizing step, predefinition step). In the second step, the objects of these 'compare sets' are then compared to each other. Therefore not the whole database (or schema) is compared, but only the 'application unit' of interest. Thus very individual compare runs are possible by PowerDIFF. This is a key advantage for many comparison requirements and not found in other products on the market - which makes this tool especially efficient, useful and unique.

  Arbitrary subset comparison

• Distinguish types of constraints: When comparing constraints, primary key (PK), check (C) and referential integrity (RI) constraints are distinguished. For Oracle even a further differentiation into internal and external (=cross schema) RI constraints is possible and done by default. This is a key advantage for many comparison requirements and not found in other products on the market.

  Distinguish referential integrity constraints

• Tables with LOB data types comparable: All ORACLE LOB (long object binary) data types are supported (up to 16 MB) in the visualization (database browser) mode. All rows of these tables can be compared with respect to their definition and data (columns) up to the LOB columns. This is a key advantage for many comparison requirements and not found in other products on the market.

  LOB data type comparison

• Advanced structural and meta data comparison: Besides the usual structural comparison, even a further comparison of additional and often very important other structural details is possible, too. Examples are storage clauses for tables and indexes or statistical data like object (segment) sizes in Oracle blocks, time of last statistics gathering etc. thus making almost every information obtainable from the database dictionary ready to be compared. This is a key advantage for many comparison requirements and not found in other products on the market.

  Meta data comparison

• Comparison of global database parameters: Global database parameters as e.g. INIT.ORA parameters like memory sizes, database operating modes, optimizer settings, file and directory paths and statistical data of databases can be compared. Thus a comparison of two database instances with respect to their dimensional parameters (SGA, PGA, buffer cache sizes, hit ratios, statistical and other efficiency parameters) is possible, too. This is extremely useful when dealing with test and productive instances of a database where a performance check must be done. Please note that migration problems (as e.g. from version X to Y or from test to production database) are still the most frequent reason for performance bottlenecks in Oracle applications. A lot of these problems can be identified by this utility. This is a key advantage of this tool and not found in other products on the market.

  Comparison of global database parameters

PowerDIFF - the ultimate database diff tool.