Which synchronization method should you use?

You are a data architect. The data engineering team needs to configure a synchronization of data between an on-premises Microsoft SQL Server database to Azure SQL Database.

Ad-hoc and reporting queries are being overutilized the on-premises production instance. The synchronization process must:

– Perform an initial data synchronization to Azure SQL Database with minimal downtime

– Perform bi-directional data synchronization after initial synchronization

You need to implement this synchronization solution.

Which synchronization method should you use?
A . transactional replication
B . Data Migration Assistant (DMA)
C . backup and restore
D . SQL Server Agent job
E . Azure SQL Data Sync

View Answer

Answer: E

Explanation:

SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi­directionally across multiple SQL databases and SQL Server instances.

With Data Sync, you can keep data synchronized between your on-premises databases and Azure SQL databases to enable hybrid applications.

Compare Data Sync with Transactional Replication

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-sync-data