When developing a project, I came across the following situation:
We have a system where users enter information in the course of the production process, and in the end a report is generated.
This data is saved to an in-house SQL Server server. I need to replicate the report data to a server that is in the cloud (Azure).
My idea:
When the report is generated in the company, it would have a method (Async) to send the report to the server that is in the cloud, if something wrong, it would enter a waiting line, to be sent to night at a pre-set time.
But when I started my search, I came across some data replication options between SQL Servers, I already saw and I work with replication between Hyper-V servers, but for SQL? I never saw.
I have some doubts ref. to this replication: