Data Migration - Methodology
So how we ensure project is under control?
Planning & Phasing
Creating a solid action plan is essential for data migration more details.Detailed process documentation
From Data Migration Strategy & System Phase-Out Plan and through to Data Migration Mapping & Design specifications - all these documents allow backtracking and reusing solution, shorten time needed for data transition and most importantly, allow easy issue resolution.Using proprietary data migration tools
We use proprietary data migration tools to do our job. These are:- Data Cleansing & Issue Reporting tool
- Data Transformation tool
- Data Transformation tool
- Data Loading tools
Ensure project transparency with abundant reporting
- Cleansing reports
- Load reports, separate for each phase
- Data issues reports
Ensuring quality
Apart from code testing we surely are consistent in testing the migrated data. Apart from load reports that are merely statistics, we perform :- Data-sample tests Here tests with use of data samples are performed from the very start (data source or donors) to the target system. The test includes total checking of the data set in the target system.
- Business Process Tests These tests are aimed to ensure that business processes works on the migrated data in the target system.