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
Last activity: Aug 7, 2021, 05:21 AM