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

Re: Data migration Verification

2007-06-04 Thread paulizaz
For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/Data-migration-Verification-tf3852626.html#a10953205 Sent from the MySQL - General mailing list archive at Nabble.com

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

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

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

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

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 from one