Re: Compare Schema with data

The below links are pretty good for compare tools. I recommend dbdiff, it seems to be pretty complete.

http://www.torry.net/tools_dbcompare.htm http://www.dkgadvancedsolutions.com/dbdiff.htm

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 10:24 PM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  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).