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
Why not just export each database (without data) and import with the "list
contents" option. then you can compare the imports for tables, indexes,
procedures, ect..
I think the only thing you will be missing is the refrential constraints.
Anyone want to comment on this?
Satar
In article <706k3p$h25$1_at_supernews.com>,
"Jeff Keen" <No_Spam_at_For_Me.com> wrote:
> 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.
> >> -------------------------------------------------------------------------
-- Oracle DBA/UNIX System Admin Advanced Enterprise Solutions (949) 756-0588 Oracle Re-Seller -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Sat Oct 17 1998 - 00:00:00 CDT