Title: Application for data migration with complete data integrity

Authors: Sven Blagaić; Marina Bagić Babac

Addresses: Faculty of Electrical Engineering and Computing, University of Zagreb, Unska 3, HR-10000 Zagreb, Croatia ' Faculty of Electrical Engineering and Computing, University of Zagreb, Unska 3, HR-10000 Zagreb, Croatia

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.

Keywords: data integrity; database; data migration; SQL; structured query language; application.

DOI: 10.1504/IJSSE.2022.127988

International Journal of System of Systems Engineering, 2022 Vol.12 No.4, pp.405 - 432

Received: 29 Nov 2021
Accepted: 21 Apr 2022
Published online: 03 Jan 2023 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article