Synopsis:
To achieve an effective data migration procedure, data on the old system has been mapped to the new system providing a design for data extraction and data loading. The design relates old data formats to the new system"s formats and requirements. Programmatic data migration does involve many phases but it minimally includes data extraction where data is read from the old system and data loading where data is written to the new system.
After loading into the new system, results are subjected to data verification to determine whether data was accurately translated and formatted, is complete, and supports processes in the new system. During verification, a parallel run of both systems will be performed to identify areas of disparity and forestall erroneous data loss if any.
Automated and manual data cleaning shall be performed in migration to improve data quality, eliminate redundant or obsolete information, and match the requirements of the new system.
Data migration phases (design, extraction, cleansing, load, verification) for applications of moderate to high complexity shall be commonly repeated several times before the new system is deployed.
