RE: Compare Schema with data

2003-06-18 Thread Robson, Peter
I've been watching this thread with interest, feel obliged to report in my experiences. Came of replicating data (once per day) between several instances. Needed a way to validate that post-replication all data was identicial. Dynamic scripts do it, driven from a table which lists the tables being

Re: Compare Schema with data

2003-06-17 Thread Jay
tself. > > > >Rich > > > >Rich Jesse System/Database Administrator > >[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > > > > -Original Message- > > > From: Louis BROUILLETTE [mailto

RE: Compare Schema with data

2003-06-17 Thread Louis BROUILLETTE
/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 bu

RE: Compare Schema with data

2003-06-17 Thread Jesse, Rich
[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 > > &g

RE: Compare Schema with data

2003-06-17 Thread Louis BROUILLETTE
t; 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

RE: Compare Schema with data

2003-06-17 Thread Jesse, Rich
tor [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Gudmundur Bjarni Josepsson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 2:19 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Compare Schema with data &

RE: Compare Schema with data

2003-06-17 Thread Jesse, Rich
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

Re: Compare Schema with data

2003-06-17 Thread Gudmundur Bjarni Josepsson
Is any body know any tools for comparing two schema for only data comparison & create script for the result Isn't Change Mangement Pack in OEM able to do this? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] F

RE: Compare Schema with data

2003-06-17 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROT