Comparing two databases

Any suggestions or third party tools that will compare objects in one database to another database. This would include: tables, indexes, triggers, stored procedures, database links, grants, synonyms, views, constraints, sequences, and user definitions. Basically, anything that makes one database different from another.

This would be used to compare development to production or a customized db to the plain vanilla db. Or a pre-upgrade db to a post-upgrade db.

In my mind's eye, it would be nice if a before image could be stored. Thus, take a before picture, developers do their stuff or run an upgrade, take an after picture, then compare. Rather than needing both db's running together.

Another idea would be take an export full=y rows=n of both db's then have a unix script to compare them. But, optionally, ignre differences due to extent sizing and such.

Any ideas.

Ron Beery
NCR
"Everything is computerized. What could possibly go wrong?" Received on Thu Jun 27 1996 - 00:00:00 CEST