Automate DB sync from Onprem to Azure SQL Database

Question

Hi Team,

We are planning to automate DB sync from Onprem to Azure SQL Database?

What are the different ways?

Answer 1

Hi @Vijay Kumar ,

If you using SQL Data Sync, please follow the steps from this MS document Tutorial: Set up SQL Data Sync between databases in Azure SQL Database and SQL Server.

>What about Azure Data Factory?

Move data from a SQL Server database to Azure SQL Database via Azure Blob Storage using the Azure Data Factory (ADF): this method is a supported legacy approach that has the advantages of a replicated staging copy.

ADF pipeline that composes two data migration activities. Together they move data on a daily basis between a SQL Server database and Azure SQL Database. The two activities are:

Copy data from a SQL Server database to an Azure Blob Storage account
Copy data from the Azure Blob Storage account to Azure SQL Database.

Please refer to Move data from a SQL Server database to SQL Database with Azure Data Factory.

Best regards,

Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The two main ways are

One-Way Transactional Replication to Azure SQL Database

and

SQL Data Sync for Azure

for one-way batch ETL you can also use

Azure Data Factory

Answer 3

Hi @Vijay Kumar ,

> Can you please describe in few line, that what is main difference between SQL DataSync and Azure Data Factory?

Refer to this similar thread Azure Data factory vs Data sync.

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.