What are the means of replicating tables between SQL servers?

3

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:

  • If a report is edited in the company, I need to update the data in the cloud (azure).
  • Is replication available for any version of SQL Server? or for example, with express versions it is not possible to do replication?
  • The data will only be manipulated in the company, the server in the cloud is for viewing only.
  • asked by anonymous 18.07.2017 / 13:30

    0 answers