Migration Steps

Hello Friends,

Welcome back with another post. Today, we will discuss about the steps that needs to be followed during any migration. Let's see-

1. Evaluate
1. This is the primary step or a Pre Migration Step.Here, we evaluate the intent of migration and define a scope for the data that needs to be migrated. It includes-
1. Data Source
2. Data Types
3. Quantify Packages
2. Plan
1. This the stage where we define the strategy for data migration. It includes-
1. Plan migration strategy
2. Plan downtime
3. Master data source identification
4. Plan the data cleaning
5. Destination data source identification
6. Plan the data verification
3. Extract
1. This is the stage where we define and perform the data extraction from data source(s). Normally, we use Intermediate database (Staging Database) here. It includes-
1. Creating packages to extract
2. Simplify data at source or at intermediate database
4. Clean
1. This is the stage where we cleanup the data before loading to the actual data base. Cleaning is a continuous process. We can perform this process in parallel to other steps as well and at stage. It includes-
1. Identify & Remove duplicate data
2. Remove Garbage data
5. Load
1. This is the stage where actual process of loading the data into production database is performed. This stage is very crucial and needs extensive planning. We need to ensure that the stage should have a minimal impact upon users as well as upon business continuity. It includes-
1. Loading small set of data
2. Ensure everything is OK
3. Push rest of the data
4. Process can be done in using iterative approach
6. Verify
1. This is the final stage of migration or a Post Migration Step. Verification of migrated data is also crucial and a continuous process. It is better to include a Business Application Data Expert to validate the data at different stages. Validation is required-
1. When data is extracted to ensure all the requisite data is accounted for
2. When cleanup is done to ensure relevant data is not removed
3. When data is loaded to ensure all data is loaded in correct and accurate manner

With this, I am concluding this post.

Happy Coding !!!

Will see you again with some new topics.

Stay Safe !

Stay Healthy !