Re: How to compare DB Tables in different Instances - MORE OPTIONS

Martin,

Thanks for the reply.
I'm really looking for a convenient way to compare the Schema of two DB instances to insure that we detect any DB changes between an In-house Development DB and a Client Version (deployed version) of the same DB. We would like a way to compare by connecting to both DBs.

Is there a way to compare the DB schema and list descrepancies via a SQLPLUS script ? by reading user_tab_columns in each instance ? Can a script connect to both DB's and do the compare ?

Or is there an Oracle utility which can do this ?

Alternatively, I may consider a data modeling tool such as ERWIN (synchronization feature) or POWERDESIGNER to load the Development Data Model and compare to the Client DB Instance Data Model.

Regards, Paul

replace this with @ wrote:

> Hi,
>
> >We have a need to compare the data in tables in a base Instance
> >with the new DB instance thats created for a Client.
>
> I'm thinking about a database link, but don't know if this is correct.
>
> >Request suggestions on how to automate comparing tables
> >and possibly listing descrepancies.
>
> I don't know if it's possible to create triggers between instances. It
> sure isn't recommended for performance.
>
> But of course you can use sql-statements to list the discrepancies.
> Maybe you even want to create a generic script using the
> user_tab_columns table.
> -------------------------------------------------------------------------------
> --- Martin Jesterhoudt
> --- martinj(replace this by @)xs4all.nl
> -------------------------------------------------------------------------------
Received on Wed Oct 14 1998 - 00:00:00 CDT