Data Migration between Heterogeneous Relational Databases – Oracle, MySQL, PostgreSQL and Microsoft SQL Server

Abstract

All of a source database application's components are changed into their equivalents in a target database environment throughout the migration of database applications procedure. In order to do this, the source schema must be converted into the target one, the source data must be transformed into the target database format, application programmes must be migrated to the new, non-relational DBMS, and queries and update operations must be translated into their equivalents in the target platform. However, software engineering is required to convert application programmes and queries. Consequently, it is believed that database migration will involve both data conversion and schema translation.