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
I don't mean the whole thing. Pick some output that your applications usually produce and see if you can get the same results for both databases. I am not saying that this is the only and best way, just in addition to the mentioned sample approach. If you want to know for sure you will have to wr

Re: Data migration Verification

2007-06-04 Thread Wm Mussatto
On Mon, June 4, 2007 9:31, paulizaz said: > > What do you mean by "same output" ? Can you write a program to access both databases and have it check to see if the data matches. A lot depends on how the structure changed. If the new database rows have a one to one correspondence to the original da

Re: Data migration Verification

2007-06-04 Thread paulizaz
or the migration) >> >> Free Software, scripts, utilities, packages, industry approaches?? >> >> Sorry Im no Tech wizzard, Any ideas appreciated. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > T

Re: Data migration Verification

2007-06-01 Thread Olaf Stein
Besides the sample approach, output data (a set you would output on a live system anyway) from both db setups and see if you can get the same output from both Olaf On 6/1/07 10:35 AM, "paulizaz" <[EMAIL PROTECTED]> wrote: > > Hi all, > > I have somebody creating a C# class to migrate data fr

Data migration Verification

2007-06-01 Thread paulizaz
?? Sorry Im no Tech wizzard, Any ideas appreciated. -- View this message in context: http://www.nabble.com/Data-migration-Verification-tf3852626.html#a10913962 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http