Data migration:

Is a process which involves the migration of data from an existing Db to a new Db

Scope of data migration testing:

·         testing the migration of legacy data to the new db

·         does not violate any referential constraints

·         testing the data that is setup in the master table

Testing life cycle for data migration:

1.      data Migration Requirement Analysis (i.e. size of the source Db, Mapping relationship etc)

2.      Test Strategizing (i.e. process of testing, scope of testing estimated effort timeline)

3.      test Planning

4.      Design of Automated Test Scripts

5.      Test Environment Setup

6.      Test Execution

7.      Result and defect Analysis

Type of Migration:

·         Direct Migration from the Source Db to the Target

·         Migration after performing certain transformations on the source data (i.e do some transformation of the source data before it is migrated to the new db)

·         target Generated Data

·         Reference at target system generated (i.e. primary key, references key constraint)

·         manual setup data in the target db (certain tables have to be populated before the migration takes place)