SQL Server Replication

Nagesh CL 621 Reputation points
2021-09-09T16:16:53.323+00:00

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

SQL Server on Azure Virtual Machines
Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,251 Reputation points MVP
    2021-09-09T16:47:36.337+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful