Re: Database Comparision

nsonawal_at_interserv.com wrote:
: Hi,
 

: I am trying to compare two identical databases residing on different servers. The databases have to
: be the same since they use the same DDL scripts. I have been thinking about different ways of doing it
: and was wondering if anybody has tried to do it before. If anybody has any experience or scripts to
: share i would appreciate that. My email address is nsonawal_at_interserv.com. Thanks.
 

: Nuruddin

i've wrote a script using oraperl to do the comparison. it finds differences in tables, synonyms, indexes, views and triggers.

it's not that hard...just write some queries into the data dictionary tables and loop into the other database to compare the objects.

before writing it in oraperl, i wrote a few SQL scripts which will doing a select from a local DD table minus select from remote DD table to give the differences.

jc Received on Wed May 24 1995 - 00:00:00 CEST