Database Migration using Data Synchronization and Transactional Replication
Winda Sekar Dewi1, Ema Utami2, Bambang Sudaryatno3
1Winda Sekar Dewi, Department of Magister of Informatics Engineering, AMIKOM University Jl. Ring Road Utara-Condong Catur Sleman, Yogyakarta, 55283, Indonesia.
2Ema Utami, Department of Magister of Informatics Engineering, AMIKOM University Jl. Ring Road Utara-Condong Catur Sleman, Yogyakarta, 55283, Indonesia.
3Bambang Sudaryatno, Department of Magister of Informatics Engineering, AMIKOM University Jl. Ring Road Utara-Condong Catur Sleman, Yogyakarta, 55283, Indonesia.
Manuscript received on 07 August 2019 | Revised Manuscript received on 14 August 2019 | Manuscript published on 30 August 2019 | PP: 2730-2734 | Volume-8 Issue-10, August 2019 | Retrieval Number: J95630881019/2019©BEIESP | DOI: 10.35940/ijitee.J9563.0881019
Open Access | Ethics and Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Database migration is one of the important thing to make the data can be stored optimally and minimize risk of data lost. Data Synchronization and Transactional Replication can be used to do it. Transactional Replication is working on services area to migrate database stored in cloud to another cloud storage. Data Synchronization is used to synchronize migrated database with origin database. Data lost concerns remain as the big consideration to widespread the adoption. Many ways can be done to minimize the risks, one of them is by migrate the database that is already stored in cloud to another database in cloud. This research will conduct database migration using data synchronization and transaction replication. By using Azure and Amazon Web Services as Database Migration Services, these techniques allow SQL Database data to be easily replicated, and allows multiple SQL Databases to isolate mission-critical workloads from analytic queries that run relatively longer. The evaluation is by comparing these two migration services based on the synchronizing time of full loaded database migration. Migration result shows that database migration using transactional replication and data synchronization is influenced by the number of rows as well as size of the table, server location, also uploading and downloading speed in each database migration service.
Keywords: Database Migration, Transactional Replication, Data Synchronization, Azure, AWS.
Scope of the Article: Database Theory and Application