Open AccessDatabase Migration using Data Synchronization and Transactional Replication
Author(s) -
Winda Sekar Dewi,
Ema Utami,
Bambang Sudaryatno
Publication year - 2019
Publication title -
international journal of innovative technology and exploring engineering
Language(s) - English
Resource type - Journals
ISSN - 2278-3075
DOI - 10.35940/ijitee.j9563.0881019
Subject(s) - database , computer science , replication (statistics) , data migration , sql , data synchronization , distributed database , upload , rollback , transaction log , synchronization (alternating current) , database transaction , cloud computing , cloud database , database tuning , database server , database design , view , operating system , computer network , process (computing) , channel (broadcasting) , statistics , mathematics
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.