Application for data migration with complete data integrity
by Sven Blagaić; Marina Bagić Babac
International Journal of System of Systems Engineering (IJSSE), Vol. 12, No. 4, 2022

Abstract: The process of data migration is used to equalise database content when it starts do differ due to database use for different purposes. It is a process that often takes some time because large quantities of data are usually migrated. However, the time that it takes the user to select migration options and the way that it is done can be reduced and simplified, respectively. This paper shows that the process of selecting migration databases, their corresponding changes, and database management in general, can be user-friendly by using the MigrationTool. Through an intuitive user interface, the MigrationTool allows the user to select the source and target environments and schemas whose content will be migrated, followed by a selection of structured query language (SQL) orders which will be applied to the target database. They are presented in a way that it is easy to see which differences exist and on which tables they could potentially be applied. This application also offers a set of additional functionalities which enable a lot of database and user management to be done directly from the application itself.

Online publication date: Tue, 03-Jan-2023

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

 
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of System of Systems Engineering (IJSSE):
Login with your Inderscience username and password:

Username:        Password:          Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email subs@inderscience.com