RE: Compare Schema with data

From: Louis BROUILLETTE <Louis_Brouillette_at_UQTR.CA>
Date: Tue, 17 Jun 2003 18:54:34 -0700
Message-ID: <F001.005B38DF.20030617182435@fatcity.com>

Rich,

I meant that I would compare the 2 "insert statements" files with the "files compare" of TOAD instead of comparing with sdiff. It's a lot easier to see the differences between the files.

At 13:55 2003-06-17 -0800, you wrote:
Hi Louis,

That sounds cool, but where can you compare table data in TOAD? The only options I see (TOAD 7.5 registered and TOAD 7.5.3.28 BETA w/DBA module) are for the object definitions of schemas and not the data itself. Rich

Rich Jesse                           System/Database Administrator
[EMAIL PROTECTED]                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Louis BROUILLETTE [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 2:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Compare Schema with data
>
>
> I think that's a good way to do it but I would use the
> "Compare files" of
> TOAD which is much nicer to look at than sdiff.
> At 11:04 2003-06-17 -0800, you wrote:
> >TOAD v7.5 will allow you to "export" INSERT statements of
> all the data in a
> >table. I've FTP'd these INSERT statements to a Unix box to
> run "sdiff -s"
> >between the files in order to get the differences. Yes, it's a bit
> >"manual", but the price is right (ours was <$350/copy back
> in the 1900s).
> >You can evaluate TOAD by filling out the contact form at:
> >
> >http://www.quest.com/toad/
> >
> >...and click on the "Download Trial" link on the left.
> >
> >
> >HTH!
> >
> >Rich
> >
> >Rich Jesse System/Database Administrator
> >[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> >
> > > -----Original Message-----
> > > From: Stephen Lee [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, June 17, 2003 1:20 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Compare Schema with data
> > >
> > >
> > >
> > > I think DB Artisan Change Manager will do it.
> > >
> > > > -----Original Message-----
> > > > Is any body know any tools for comparing two schema for only
> > > > data comparison
> > > > & create script for the result

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: [EMAIL PROTECTED] 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Louis BROUILLETTE
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 17 2003 - 20:54:34 CDT