Data Migration Project Planning: 10 Best Practices to Implement

 
 
By Chris Preimesberger  |  Posted 2012-09-05
 
 
 

Determine the Purpose of Your Data

Analyze the information environment, identifying where and how the data will be leveraged—and who will actually use the data—while thoroughly assessing the information environment. Determine how data could be used differently tomorrow, in analytics, for example.

Determine the Purpose of Your Data

Take an As-is Assessment Before Moving Data

Data is dynamic—changing all the time—and it is tied directly to business processes and uses. Establish data standards and define business rules for migration and ongoing data use with owners and subject matter experts.

Take an As-is Assessment Before Moving Data

Account for Data Quality, Especially in Legacy Systems

Migrating involves more than moving data. Perform a thorough quality assessment to ensure standardization that supports new uses and users today and tomorrow. This should include deduplication, removal of other non-relevant files and possibly a master data management-type process.

Account for Data Quality, Especially in Legacy Systems

Validate and Redefine Business Rules

Data must comply, and be compatible with, current business and validation rules. Define rules for one-time data conversion and migration, while designing them for adaptability to future regulatory and policy requirements.

Validate and Redefine Business Rules

Ensure that Governance Rules are Established Early and Define Who Is Responsible for the Data

After determining who owns and has final say-so over information, establish strategic and operational data "stewards" aligned to "C-level" sponsors for continuing guidance on scope, direction and support.

Ensure that Governance Rules are Established Early and Define Who Is Responsible for the Data

Take Responsibility for Your Data Migration

The company, not only the systems integrator, must live with the results of data migration. Based on aptitude and attitude, find the right people to manage processes and technology correctly.

Take Responsibility for Your Data Migration

Dont Rely 100 Percent on the Tool

Tools are only that. Tailor fields and business rules to your company's needs with internal experts leveraging tools while obtaining the right information to complete data migration.

Dont Rely 100 Percent on the Tool

Validate Throughout the Process

Don't wait until migration is completed to look for problems. Fixing mistakes after the fact are exorbitantly expensive. Carefully choose testing and evaluation personnel based on critical participant and data consumer needs.

Validate Throughout the Process

Engage the Business

As migration takes place and nears completion, be ever mindful of which users, customers and business partners have to live with the results. Choose carefully and accurately who makes the final decision whether the migration is "good enough."

Engage the Business

Measure Impact

Take your time in determining who should be involved in testing, evaluation and final sign-off of the data migration, while being keenly aware of the data's ultimate consumer. After "go-live," focus on operational business processes to maintain relevant, high-quality data.

Measure Impact

Rocket Fuel