MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:June 4 2007 4:39pm
Subject:Re: Data migration Verification
View as plain text  
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
database then 1st count the rows.  If it passes that test compare the data
in the new row with the corresponding data in the old row.

> 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.
> Olaf Stein-2 wrote:
>> 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" <paulizaz@stripped> wrote:
>>> Hi all,
>>> I have somebody creating a C# 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??
>>> 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 for the migration)
>>> Free Software, scripts, utilities, packages, industry approaches??
>>> Sorry Im no Tech wizzard, Any ideas appreciated.....................
>> --
>> MySQL General Mailing List
>> For list archives:
>> To unsubscribe:

Data migration Verificationpaulizaz1 Jun
  • Re: Data migration VerificationOlaf Stein1 Jun
    • Re: Data migration Verificationpaulizaz4 Jun
      • Re: Data migration VerificationWm Mussatto4 Jun
      • Re: Data migration VerificationOlaf Stein4 Jun
        • Re: Data migration VerificationBaron Schwartz4 Jun
      • Re: Data migration VerificationJoerg Bruehe5 Jun