“Data Migration is the act of moving data from one location to another on a platform while changing the database, storage or application. About the Extract-Transform-Load process, data migration often needs at least Extract and Load steps. “
Usually, data migration happens amid an upgrade of existing hardware or migration to an entirely new system. Cases include transfer to or from a hardware system; replacing a database or moving to new software; or organization mergers when the parallel platforms in the two organizations need to be combined into one.
There are three principle approaches to carry out data migration:
Combine the systems from the two organizations into a brand new system.
Transfer one of the systems to the next one.
Leave the systems as they are; however develop a central view over them – a data distribution center.
Difficulties of Data Migration…
May we describe the data transfer difficulties further? Data migration can be an easy procedure; nevertheless, there are difficulties one may encounter in execution.
Database migration is relatively straightforward; perhaps the database is utilized as similar as storage. It only needs transferring the data into another. Nonetheless, even this might be a challenging assignment.
The major problems one may experience include:
Dissimilar data forms (date, number sub-information)
Diverse sets of character (encoding)
Various data forms can be taken care of efficiently by approximating the nearest form from the actual database to maintain an accuracy of data. Should a source database supports comprehensive data designs, for instance, sub-record, but the actual database does not, revising the applications utilizing the database is essential.
Correspondingly, if the source database supports distinctive encoding in every section for a specific table but the actual database does not, the applications utilizing the database ought to be revised.
At a point when a database is utilized not just for storing data, but also to be used as a business strategy in the form of stored processes and activations, close consideration must be paid when carrying out a feasibility investigation of the migration to the actual database. Once more, if the actual database does not remain compatible with some of the characters, the adjustment may be executed by applications or by middleware programming.
Capacity migration can be carried out in a way peculiar to the application as long as the application utilizes just broad interfaces to access the data. In some networks, this isn’t a problem. Nonetheless, proper consideration is important for old applications running on restrictive platforms. Much of the time, the source code of the application isn’t accessible, and the application seller may not be in the market any longer. In such scenarios, capacity or storage migration is somewhat tricky and ought to be appropriately examined before releasing the solution into production.
Should we go back to past two cases, you may see that the procedure is somewhat straightforward. This process nonetheless, is to a greater extent not common in the application migration process. The reason is that the applications, even when developed by the same merchant, greatly store information in diverse structures and designs which cause simple migration of data difficult.
Trouble may occur when transferring data from centralized computer platforms or applications utilizing personal data storage. Centralized computer platforms utilize record based configurations to store information. Storage-based configurations are easy to manage; nonetheless, there are common optimizations incorporated into the centralized computer data storage which make migration of data difficult.