Restricted access
 
 

December 20, 2010

Testing Your Data Migration Solution

Filed under: Data Migration — Katherine Vasilega @ 8:32 am

Data migration solutions should be carefully tested before and after the migration process starts. A well-organized testing strategy must include the following stages to ensure data quality in the data migration process:

Testing before Migration

During this stage you should verify scope of source/target systems and data with business users and IT department. It is also useful to test source and target system connections from the data migration platform.

Data Migration Design Review

The design review of the data migration specifications can include:

    • Source data sets and queries
    • Data mappings
    • Number of source records
    • Identification of supplementary sources
    • Data cleansing requirements

The outcome of this stage of data migration should be summarized in a list of open issues, which have to be resolved before the actual migration starts.

Testing after Data Migration

Post-migration is typically performed in a test environment and includes:

    • Testing the migration process (number of records per unit time)
    • Comparing migrated records to records generated by the destination
    • Comparing migrated records to sources

It is recommended that you use both automated tools and skilled data migration resources for successful solution testing.

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment