Data Migration - industry practices for %tage of data to verify

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • donut
    New Member
    • Jul 2007
    • 1

    Data Migration - industry practices for %tage of data to verify

    Hi, i am currently preparing a Data Migration Plan for migration of existing data from ADABAS to DB2. The data volume can be as huge as 200 GB. Since it is impossible to verify all the data migrated, does anyone know of any industry practices for the percentage of data to be verified for certain record size.

    For example,
    small sys: 0 to 1million records (1%)
    medium sys: 1 to 10million records (5%)
    large sys: 10million records and above (10%)

    Thanks Much!
  • pbmods
    Recognized Expert Expert
    • Apr 2007
    • 5821

    #2
    Heya, donut. Welcome to TSDN!

    What you can do (at least with MySQL) is to dump your database from each server and compare the dumpfiles.

    What database server(s) are you migrating between?

    Comment

    Working...