Re: Data migration Verification

2007-06-05 Thread Joerg Bruehe
Hi ! paulizaz wrote: What do you mean by "same output" ? I have too much data to go through and check if all the data is the same. This is my problem. Sampling would speed this up, but I need something more accurate. All data is important. In Unix / Linux, you would generate similar plain-te

Re: Data migration Verification

2007-06-04 Thread Baron Schwartz
On 6/4/07 12:31 PM, "paulizaz" <[EMAIL PROTECTED]> wrote: I have too much data to go through and check if all the data is the same. This is my problem. Sampling would speed this up, but I need something more accurate. All data is important. Then I think you will also have to write a reverse mi

Re: Data migration Verification

2007-06-04 Thread Olaf Stein
class to migrate data from one SQL database >>> to >>> another slightly differently structured SQL database. >>> >>> Please can anybody suggest ways to verrify that the data has migrated >>> successfully, in whole and acurrate?? >>> >&

Re: Data migration Verification

2007-06-04 Thread Wm Mussatto
abase >>> to >>> another slightly differently structured SQL database. >>> >>> Please can anybody suggest ways to verrify that the data has migrated >>> successfully, in whole and acurrate?? >>> >>> I feel a sample approach would not quite

Re: Data migration Verification

2007-06-04 Thread paulizaz
; I feel a sample approach would not quite be substancial. >> I want to keep it seperate from the migration process itself (having my >> person write a verification script may also not work as he will be using >> the >> same thought processes and knowledge that he used f

Re: Data migration Verification

2007-06-01 Thread Olaf Stein
tancial. > I want to keep it seperate from the migration process itself (having my > person write a verification script may also not work as he will be using the > same thought processes and knowledge that he used for the migration) > > Free Software, scripts, utilities, packages, i

Data migration Verification

2007-06-01 Thread paulizaz
substancial. I want to keep it seperate from the migration process itself (having my person write a verification script may also not work as he will be using the same thought processes and knowledge that he used for the migration) Free Software, scripts, utilities, packages, industry approaches

RE: verification upon update, help, please

2002-07-03 Thread Nilesh Shah
What happens if you put third TIMESTAMP column.?. Will that be updated?. Just curios. Nilesh -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: Paul Tomsic; [EMAIL PROTECTED] Subject: Re: verification upon update, help, please

Re: verification upon update, help, please

2002-07-03 Thread Paul DuBois
At 12:07 -0400 7/3/02, Paul Tomsic wrote: >Does MySQL prevent updates from occurring when the values involved >are the same as the database's current state. I don't know if "prevent" is the word exactly. It doesn't bother to update the row unless you actually change a value. The phenonenon you

verification upon update, help, please

2002-07-03 Thread Paul Tomsic
Does MySQL prevent updates from occurring when the values involved are the same as the database's current state. For instance, if I've got a table create table updater( id int not null primary key auto_increment, is_active int not null default 1 }; insert into updater(is_active) values (1); in

Re: Verification

2001-01-29 Thread Eric Fitzgerald
ED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 29, 2001 3:06 PM Subject: Verification > Hello, > > I just want to make sure that I can do this but would this scenario work > properly. > I build an sql database and perl interface at site www.siteX.com. > > A p

Verification

2001-01-29 Thread Carlos Corzo
Hello, I just want to make sure that I can do this but would this scenario work properly. I build an sql database and perl interface at site www.siteX.com. A person on www.siteY.com is going to utilize this tool The perl interface running on www.siteY.com makes a call to the database from www.si