Syncing local db with cloud db

%3CLINGO-SUB%20id%3D%22lingo-sub-1431814%22%20slang%3D%22en-US%22%3ESyncing%20local%20db%20with%20cloud%20db%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431814%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20web%20application%20that%20runs%20on%20SQL%202012%20locally%20in%20the%20office%2C%20We%20have%20a%20virtual%20server%20in%20the%20cloud%20hosting%20a%20copy%20of%20the%20web%20application%20so%20management%20connects%20to%20it%20and%20run%20report%20the%20next%20day%20after%20a%20backup%20of%20the%20local%20db%20is%20restored%20on%20the%20cloud%20server.%3C%2FP%3E%3CP%3EHow%20can%20i%20sync%20or%20replicate%20the%20local%20with%20the%20virtual%20server%20which%20will%20be%20near%20realtime.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1431814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EReplication%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1435963%22%20slang%3D%22en-US%22%3ERe%3A%20Syncing%20local%20db%20with%20cloud%20db%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1435963%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685865%22%20target%3D%22_blank%22%3E%40flashyjunior%3C%2FA%3E%26nbsp%3B--%20You%20don't%20mention%20which%20cloud%20the%20virtual%20machine%20is%20hosted%20in%2C%20but%20in%20the%20case%20of%20Azure%20you%20can%20use%20SQL%20Server%20transactional%20replication.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Frepltalk.com%2F2014%2F07%2F28%2Fmicrosoft-sql-replication-between-windows-azure-virtual-machines%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Frepltalk.com%2F2014%2F07%2F28%2Fmicrosoft-sql-replication-between-windows-azure-virtual-machines%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1436004%22%20slang%3D%22en-US%22%3ERe%3A%20Syncing%20local%20db%20with%20cloud%20db%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1436004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F305348%22%20target%3D%22_blank%22%3E%40bake13%3C%2FA%3E%2C%20thanks%20for%20the%20reply%2C%20its%20a%20virtual%20windows%20server%20with%20SQL%202014%20installed%20on%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1437269%22%20slang%3D%22en-US%22%3ERe%3A%20Syncing%20local%20db%20with%20cloud%20db%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1437269%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685865%22%20target%3D%22_blank%22%3E%40flashyjunior%3C%2FA%3E%26nbsp%3B--%26nbsp%3B%20Ok%2C%20that%20is%20a%20supported%20replication%20architecture%20for%20SQL%20Server%20so%20from%20that%20perspective%20it%20would%20work.%26nbsp%3B%20Reference%20the%20replication%20matrix%20at%20the%20link%20below.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Freplication%2Freplication-backward-compatibility%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Freplication%2Freplication-backward-compatibility%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20next%20and%20most%20important%20step%20will%20be%20network%20connectivity%20between%20your%20on-premises%20network%20and%20your%20cloud%20provider%20virtual%20machine.%26nbsp%3B%20For%20Azure%20you%20have%20some%20options%20which%20are%20detailed%20at%20the%20link%20below.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Freference-architectures%2Fhybrid-networking%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Freference-architectures%2Fhybrid-networking%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

3 Replies

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

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/