Database Migration using Data Synchronization and Transactional Replication
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.