Migration solution definition
Establish a data migration approach that is appropriate for your project scope.
“Successful system migrations hinge on rigorous implementation plans.” - Mike Walczak, Director.
Whether you’re looking at a staged or a one-time big-bang migration, the key to every successful data migration solution is to first define an approach that is appropriate for the scope of your project, and your tolerance level for impact on business or ongoing customer services. After that, there are several stages you need to consider;
- Profiling legacy data and establishing a data map that defines the translation of data from the legacy system to the new system and any manipulations, validations or criteria that need to be applied to the data as part of this translation.
- Developing and testing data migration routines, including extract, validation and load routines
- Ensuring a high level of data quality by identifying, developing and testing data cleansing requirements, routines and queries.
- Planning and performing trial data migration tests including full go-live trials tests.
- Managing and executing the actual data system cutover, and conducting associated conversion testing and reconciliations to confirm the conversion has been completed successfully.
Providing early-life system support to resolve any post-live issues quickly.