| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to compare DB Tables in different Instances - MORE OPTIONS
Check out TOAD (www.toadsoft.com).
It has a compare schema feature... great tool, and FREE!
Paul Chu wrote in message <3624CBEE.E869A19B_at_earthlink.net>...
>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.
>> -------------------------------------------------------------------------
 |
 |