Re: Comparing Schemas across instances

Check http://www.oramag.com there is a code depot section which has a script that will do this for you.

Kirt Thomas wrote:
>
> Does anyone have a prebuild query :) that will compare two schemas on
> different instances? I have to db's, each containing several custom
> schema, and I'd like a quick and dirty way to find out what's different.
> Ie, I given db A, and db B, each with schema one, two, three, and four -
> and assuming A is the priority db, I need to find out what one_at_b needs to
> achieve parity with one_at_a, etc etc.
>
> I know how to do this using database links, I just am hoping someone else
> has written the sql <G> THanks.
>
> N
> NoWonderNoWonderNoWonderNoWonderNoWonderNoWonderNoWonder
> W
> o "1`2`1 Technical Support 4 Free via
> n 24 hour Email and Message boards
> d http://www.nowonder.com
> e kirtt_at_nowonder.com evangelist_at_nowonder.com
> r kirtt_at_macsrule.com
Received on Fri Feb 27 1998 - 00:00:00 CST