Summary:
Keeping up with latest trends technology helps to improve the overall performance of different institutions.
Database Migration is such technology, it is the process of moving data from one platform to another platform.
Migration is necessary for
· Including server or storage equipment replacements
· Maintenance and upgrades
· Website consolidation
· Disaster recovery
· Data center relocation
· Saving expenses
· Reduce data redundancy
· Security fixes
Different applications using database are updated from time to time to allow new features and fix existing problems.
Along with applications databases are also need to be updated. Data Migration is also a way of updating database but by entirely migrating the data to another database.
Let's dive in and know more about Database Migration.
Challenges In migration:
Since database migration is a complex process there are challenges that require attention, Like
· Identification of data stored in different places
· Data analysis at the earliest
· Devising a migration strategy
· Lack of integrated process
· Data cleaning and coding
· Not evaluating final results in a timely manner
· Lack of collaboration
· Emphasize more on data analysis
· Securing data and systems.
Types of Data Migration
1. Storage Migration
Migrates data from one storage location to another.
2. Database Migration
Database migration involves moving from one DBMS to another or upgrading the current version of DBMS.
3. Application Migration
Moving data from one computing environment to another.
4. Cloud Migration
Movement of data or applications from an on-premises location to the cloud or from one cloud environment to another.
5. Business Process Migration
Movement of business applications and data on business processes and metrics to a new environment.
6. Data Center Migration
Migration of data center infrastructure to a new physical location or to the updated infrastructure at the same location.
How does it work:
1.Pre migration
Steps that needto be followed before actually starting the migration.
Planning
Structuring
Understanding the requirements
Finalising the process.
2.Migration Analysis and Design
Understanding the source database
Analysing the data complexity
Define norms and rules
Evaluate data quality
Selecting proper tools
3.Migration implementation
Building and deploying new database schema
Adding a new data access object
4.Post Migration
Validation test and repair
Designing and tuning for performance
Simple Example
Consider an application in our mobile, if a new version is developed for this application the data that is stored in the database of older version will be migrated to database of new application.
In doing so, the procedure mentioned above is followed.
Conclusion:
While performing an actual database migration, it is a very complicated task because of loads of data across multiple servers, it's difficult to migrate all the data at once.
We need to perform one step at a time in order to test the process.
However, database Migration becomes really easy if the procedure is well planned and executed with proper resources.