3
When developing a project, I came across the following situation:
We have a system, where users enter information during the production process, and in the end a report is generated.
This data is saved to an internal SQL Server company. I need to replicate the report data to a server in the cloud (Azure).
My idea:
When the report is generated in the company, it would have a method (Async) to try to send the report to the server in the cloud, if of that something wrong, would enter a queue, to be sent to night at a pre-defined time.
But when I started my research, I came across some data replication options between SQL servers, already seen and work with replication between Hyper-V servers, but for SQL? never seen.
I have some doubts ref. to this replication:
- If a report is edited on the enterprise, I need the cloud data updated (Zure).
- Replication is available for any version of SQL Server? or for example, with express versions it is not possible to replicate?
- Data will only be manipulated on the enterprise, the cloud server is for viewing only.
The snapshot server precisely for reporting cases and view-only databases. Try to see if keeping the 2 connections (Azure and Server) in Management Studio, it is possible for Azure to create a snapshot of the other server’s database.
– Onaiggac
You may also try to create a Linked server among the 2 serevidores (https://imasters.com.br/data/linked-server-pra-que-serve-quando-use)
– Onaiggac