| 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
In large complex environments a third party tool is the best way to go. I helped beta test Schema Manager from Quest and found it the best schema management tool out there. Schema comparisons is just the start. Putting your entire set of db's and schemas in configuration control really pays off down the line. In article <708uuu$ijl$1_at_nnrp1.dejanews.com>, satar_at_my-dejanews.com wrote:
> 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.
> > >> -------------------------------------------------------------------------
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 19 1998 - 00:00:00 CDT
 |
 |