Forum Discussion

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

bake13

Microsoft

Jun 03, 2020

Hi flashyjunior -- You don't mention which cloud the virtual machine is hosted in, but in the case of Azure you can use SQL Server transactional replication.

https://repltalk.com/2014/07/28/microsoft-sql-replication-between-windows-azure-virtual-machines/

flashyjunior

Copper Contributor

Jun 03, 2020

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

bake13
Microsoft
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/