question

NageshCL-5231 avatar image
0 Votes"
NageshCL-5231 asked AlbertoMorillo commented

SQL Server Replication

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

azure-sql-databaseazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AlbertoMorillo commented

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @AlbertoMorillo
Will try out the options suggested and get back in case of any issues / questions.

0 Votes 0 ·

Perfect. Let me know any blocking points.

0 Votes 0 ·