Legacy Issues in Migrating Data for New Data Warehouse

This paper tries to propose a solution for various issues that uncover while migrating the data from old legacy systems to new systems. Business organizations implement new Software Application System to replace the functionalities of their major processes by their old legacy systems from time to time. Data Migration is the procedure of relocating data from one framework then onto the other while changing the capacity, database or application. Complexities arise when there is a try to take the information (data) right from the legacy framework (system) and change or modify it to fit into the new framework (system). Mostly the structure and the data types of the old legacy systems are different in relation to the new system being implemented; the difference is simply not constrained to the table names, field names, properties or sizes. The types of databases are distinct, as also the entity relationships in the new framework may not compatible with the earlier legacy systems. To get the legacy data into its new application format, a certain number of modifications and transformations must take place. These modifications and transformations are known as 'Data Conversion'. During the implementation of new framework, the current structure which is being used by the old legacy system is taken into account and is mapped to the new framework being designed and implemented. Citation:Sushant S. Sule, SICSR; Pravin S. Metkewar ,SICSR; Syed Khizer ,College of Computer, Qassim University. "Legacy Issues in Migrating Data for New Data Warehouse." Global Research and Development Journal For Engineering 19 2016: 27 - 30.