A Review on Database Migration Strategies, Techniques and Tools

Abstract

In general, Relational Database Migration (RDBM) has always complex, time-consuming, and magnified process due to heterogeneous structures and several data types of RDB. This paper discusses the categorized literature review of existing migration strategies, surveys the translation techniques, and also discusses the technical issues for making the migration process more effective. This review assesses the impact of existing migration strategies and shows how it has been designed according to the recent trends. In software industries, plenty of Database Migration Tools (DBMTs) are available, but finding the effective one is still a risky job. Hence, some of the DBMTs are reviewed and suggested several basic criteria for evaluating migration toolkits. The discussion of these issues will help the researchers and also database practitioner in planning the migration projects.