This is WAY out of my comfort area so I was hoping someone could explain how this works in easy terms.
We have an SQL server behind our firewall. On that server are SQL tables we need to replicate to the cloud server we are setting up.
We tried setting up replication and because it was not set up properly the SQL server's logs filled up and the server basically stopped running.
I was told by someone that a better way would be to set up a proxy server also behind the firewall and have the cloud server replicate with the proxy. My question is how does the data get from the main server to the proxy server? Does the proxy server pull the data or does the main server push the data? The goal is to have nothing mess with the main server because that is the production server.
Ideally what I envision (and like I said I know very little) is that a proxy server pulls the data over (so the main server really is not doing anything) and that the server on the cloud connects thru our firewall on port 1433 (which is set to only accept the proxy's IP and the cloud server's IP)