Forum Discussion
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 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.
bake13Microsoft
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/
bake13, thanks for the reply, its a virtual windows server with SQL 2014 installed on it
- bake13
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.
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/
