From Louis_Brouillette@UQTR.CA Tue, 17 Jun 2003 18:54:34 -0700 From: Louis BROUILLETTE Date: Tue, 17 Jun 2003 18:54:34 -0700 Subject: RE: Compare Schema with data Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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).