Forum Discussion

flashyjunior's avatar
flashyjunior
Copper Contributor
Jun 01, 2020

Syncing local db with cloud db

I have a web application that runs on SQL 2012 locally in the office, We have a virtual server in the cloud hosting a copy of the web application so management connects to it and run report the next ...
replication
flashyjunior's avatar
flashyjunior
Copper Contributor
Jun 03, 2020

bake13, thanks for the reply, its a virtual windows server with SQL 2014 installed on it

bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jun 03, 2020

Hi flashyjunior --  Ok, that is a supported replication architecture for SQL Server so from that perspective it would work.  Reference the replication matrix at the link below.

https://docs.microsoft.com/en-us/sql/relational-databases/replication/replication-backward-compatibility?view=sql-server-ver15

 

The next and most important step will be network connectivity between your on-premises network and your cloud provider virtual machine.  For Azure you have some options which are detailed at the link below.

https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/hybrid-networking/

Resources