Data migration: scorecard

The ability of a data migration to measure the progress of its stages through the quality loads of the data loads is critical to the success of the project. It is a means by which an organization can monitor, communicate and enforce the risk management education plan hype.

Measuring the progress of data migration allows for tracking over time to ensure the continued performance of the team and staff in this area, thus enabling an efficient data organization that can effectively monitor and progress from development to development phases. test and transition of the project.

A dashboard approach to measuring makes it easier to see current performance and identify data conversion progress. The scorecard will include resources working on data conversion, steps along the way, approval obtained, security, deployment readiness, key dates, entry and exit criteria, etc.

The dashboard for data migration occurs at the detail and summary levels. At the lowest level, each data conversion object can be measured to ensure that all steps are met. At a higher level, the summary of all data conversion objects can be used to communicate and monitor the overall status of the data conversion project.


In general, data migration can be divided into three stages:

  1. Data extraction / collection
    1. Extraction describes the procedure for extracting data that needs to be migrated from source systems or collected at source for upload.
  2. Transformation
    1. The transformation describes the procedure for translating data from the language of the source system to the language of the target system according to defined mapping rules.
  3. Loading
    1. The upload describes the procedure for creating data in the target system.

The following types of data can be distinguished:

Historical data

Historical data is data that belongs to business processes, which were completed in the old system. Examples are closed production orders, material documents and individual postings to accounts, sales history for planning purposes, etc.

Basic data

Master data is data that remains unchanged longer and serves as input for daily business information. It includes objects such as material, master customer master record, vendor master record, work orders, primary and secondary cost items, and more.

Transactional data

Transactional data describes the current business process. It changes frequently and includes objects like sales orders, inventory, and more. The only transaction data that is migrated are “in progress” items. Finance also typically migrates all transactions from the last period or, sometimes, year to date.