Migrate and transfer schema and data across multiple databases

Abstract

In instances when software is made to interact with multiple databases the upgrade of the software requires data migration. In addition, there are also software’s that move schema and data between databases through migration. Database migrations normally take very long time to execute and it is an error prone process. Many commercial and open sourced database migration products are available, but the effectiveness ofa tool always depends on featuresthat it supports, however these features do not fully support for database migration projects’ requirements. Based on our studies, we design and implement the solution which automates database migration for migrating and transferring schema and data through different types of vendor databases such as MySQL, Oracle, PostgreSQL and MS SQL Server. The solution is developed on top of Java technologies such as NetBeans Platform APIs and Java Database Connectivity API. Creating a Java Swing application on top ofNetBeans Platform can largely reduce development time. The NetBeans Platform is an open source framework forJava Swing application. The Java Database Connectivity API is the main standard for database independent connectivity among a Java application and different types of vendor databases. The proposed solution supports project based mechanism to manage the migrations and it caters simple userfriendly wizard based GUI for migration. The solution also provides a set of automated database migration features, which allows migration of complicated database schema and data from one vendor database to another vendor database. The solution automates up to ninety percent ofthe manual work ofdatabase migration. It gives full migration solution for different types of vendor databases such as MySQL, Oracle, PostgreSQL and MS SQL Server. This automated database migration solution helps to save migration effort and costs involved in database migration projects.