A Seamless Network Database Migration Tool for Insititutions in Zambia

Abstract

The objective of the research was to efficiently manage migration process between different Database Management Systems (DBMS) by automating the database migration process. The automation of the database migration process involved database cloning between different platforms, exchange of data between data center and different clients running non-identical DBMS and backing up the database in flexible format, such as eXtensible Markup Language (XML). This approach involved development of a “Database Migration Tool”. The tool was developed on a windows platform using Java Eclipse™ with four non-identical dummy Relational Databases (Microsoft Access, MySQL, SQL Server and Oracle). The tool was run in a controlled environment over the network and databases were successfully migrated from source to targeted destination option specified. The developed tool is more efficient, timely, as well as highly cost effective.

Authors and Affiliations

Mutale Kasonde, Simon Tembo

Keywords

Related Articles

An Improvement of FA Terms Dictionary using Power Link and Co-Word Analysis

Information retrieval involves obtaining some wanted information in a database. In this paper, we used the power link to improve the extracted field association terms from corpus by the proposed algorithm to support the...

An Algorithm that Prevents SPAM Attacks using Blockchain

There are many systems and methods for prevent-ing spam attacks. However, at present there is no specific tried-and-true method for preventing such attacks. In this paper, we propose an algorithm, “SAGA BC” to prevent sp...

QR Code Recognition based on Principal Components Analysis Method

QR (Quick Response) code recognition systems (based on computer vision) have always been challenging to be accurately devised due to two main constraints: (1) QR code recognition system must be able to localize QR codes...

Text Summarization of Multi-Aspect Comments in Social Networks in Persian Language

Now-a-days, there are increasingly huge amount of user generated comments on the web. The user generated comments usually contains useful and essential information reflecting public’s or customers’ opinions. Since the in...

The Impact of Analytical Assessment of Requirements Prioritization Models: An Empirical Study

Requirements prioritization is one of the important parts of managing requirements in software development process which plays its role in the success or failure of a software product. A software product can go wrong or...

Download PDF file
  • EP ID EP261530
  • DOI 10.14569/IJACSA.2018.090126
  • Views 66
  • Downloads 0

How To Cite

Mutale Kasonde, Simon Tembo (2018). A Seamless Network Database Migration Tool for Insititutions in Zambia. International Journal of Advanced Computer Science & Applications, 9(1), 191-199. https://europub.co.uk/articles/-A-261530