Syncing local db with cloud db

[flashyjunior]

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 day after a backup of the local db is restored on the cloud server.

How can i sync or replicate the local with the virtual server which will be near realtime.

[#2]

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/

[#3]

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

[#4]

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-compatibi...

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/