Active Compare

Product Focus

Compare multiple instances of the database schema and data for discrepancies and further provide a mechanism for propagating SQL to adjust the differing objects in the instances.

Product Description

Active Compare compares multiple schemas and flags objects that differ in the schemas. It also provides the exact differences between the objects and the SQL and further provides a mechanism for executing the generated SQL in either schema in order to set them equal. The Active ChangeManagerTM records all changes that are propagated from one schema to the other.

Product Architecture

The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.

  • Database Compatibility:

    Oracle

    SQL Server

    DB2

  • Operating System Compatibility:

    Windows95/98/ME

    WindowsNT/2000 client connecting to ANY Database on the corporate network

  • Technical Requirements:

    Pentium 100MHz or higher

    10MB hard disk space

    64 MB RAM (128 MB recommended).

Benefits

  • Compare objects in multiple instances and identify the differences.
  • Generate the alter scripts for the objects that are different and allow the user to execute the SQL in either instance to sent them equal.
  • Compare procedure and packages and the dependencies among these objects, providing the user the order of the compile for the procedures and packages.
  • Compare grants and synonyms on database objects across instances to identify missing as well as invalid privilege settings.
  • Security privilege comparisons guarantee that across multiple database instances the security privilege settings are identical and sufficient.
  • Changes made via Active Compare are logged into the Active Change Manager database, providing control over the change process as well as the ability to rollback the changes if necessary
  • Active Compare difference results can be saved in web format and can be scheduled to be published at predetermined time intervals when Active Compare is used in conjunction with ActiveSchedulerTM

Application Area

  • Application systems are developed in the DEVL instance, tested in the TEST instance, and implemented in the PROD instance. How can one guarantee that the test is valid unless it can be certified that the three instances during the tests were identical. Active Compare identifies the differences between instances and allows the user to make the required changes in the instances and make this certification.
  • Performing an index comparison between multiple instances to flag missing indexes that could be critical for long running queries immediately identifies performance-tuning bottlenecks