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.
Highlights
Advancements in technology usually result in database migration, and an example would be for the National Pension Scheme Authority (NAPSA)
In order to build a thorough contextual understanding of the issues at play, this project undertook an assessment of the old database migrator and challenges associated with it
The project developed a new system that addresses the problems being experienced by the current database migration systems
Summary
Advancements in technology usually result in database migration, and an example would be for the National Pension Scheme Authority (NAPSA). A database (DB) is a persistent, logically coherent collection of inherently meaningful data, relevant to some aspects of the real world [1]. A collection of these databases is what forms the Database Management Systems (DBMS). Database Management Systems perform a wide variety of roles such as allowing concurrency, controlling security, maintaining data integrity, providing for backup and recovery, controlling redundancy, allowing data independence, providing a non-procedural query language as well as performing automatic query optimization. Migrating a database involves migrating the tables and records from one database management system to another. Data migration is usually undertaken for the purpose of replacing, upgrading server or storage equipment for a website consolidation, so as to conduct server maintenance or to relocate a data center
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: International Journal of Advanced Computer Science and Applications
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
