SQL Server Replication

Question

Hi Team,

We have an OLTP database which is a SQL hosted in IaaS (Azure VM). Can we have replication set up which runs every end of day to replicate the data on to Azure SQL DB? If yes, can someone share relevant links on how to setup the replication please?

Thanks.

Regards,
Nagesh CL

Answer 1

You may want to consider sync data (1-way or 2-way) between IaaS SQL and Azure SQL PaaS using SQL Data Sync. Visit this link for more information.

You can also get Azure SQL involved as a push subscriber only on a replication configuration as explained here.