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.
ActiveCompare 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 ActiveChangeManagerTM records all changes that are propagated from one schema to the other.
Screen Shot of ActiveChangeManager
- 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 ActiveCompare are logged into the ActiveChangeManagerTM database, providing control over the change process as well as the ability to rollback the changes if necessary.
- ActiveCompare difference results can be saved in web format and can be scheduled to be published at predetermined time intervals when ActiveCompare is used in conjunction with ActiveSchedulerTM.
- 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. ActiveCompare 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.
Oracle, SQL Server
Operating System Compatibility:
Windows95/98/ME, WindowsNT/2000 client connecting to ANY Database on the corporate network.
Pentium 100 MHz or higher, 10MB hard disk space, 64 MB RAM (128 MB recommended).
Download Screen Cam