Sample Header Ad - 728x90

Replicating to 3 databases one is web server

0 votes
1 answer
35 views
I have a customer that is looking for a very unusual replication configuration. I am hoping for some insight on why this is a bad idea, or even the possibility that it can be done. There are two systems where replication will be deployed, Publisher and Distributor will replicate to Subscriber on a local LAN. Need to populate a cloud server for web site. **Question1:** Could this subscriber become a publisher to another cloud based subscriber? Before you point out that the original publisher can update both local and cloud subscribers, customer doesn't want the work load on publisher system. **Question 2:** Customer suggested sending backup of local subscriber to cloud and restoring on cloud DB server at least daily. I don't believe permissions are replicated, along with other issues. Comments? I could go on and on, but I will wait on any feedback before going further. thanks
Asked by htm11h (123 rep)
Aug 6, 2021, 08:05 PM
Last activity: Aug 7, 2021, 05:21 AM