(forgive my cross-posting…I forgot I was in R4 & 5 forum when I first put this in)
Let me start by saying there are good solid reasons we want to do what I am going to describe…there said it. We have been all over the pros and cons of what we would like to have happen, and I can explain it in more detail if everyone wants.
I have two domains. DomainA and DomainB
I have one database, belongs to DomainA. I would like to have a replica acting as a backup on a server in DomainB. I have all of the connections configured to allow this, but I want to see if there is a way to do a one-way “dump” of the data every night via replication. In other words, I want the documents sitting in DomainA to overwrite any MODIFIED documents sitting on the replica in DomainB every time it replicates, and to replace any DELETIONS. I don’t want to have to touch the docs individually in DomainA to force this to happen, because we have a viable use for the real “last updated” value.
I want users in DomainB to be able to see and even temporarily modify (during a demo, for instance) documents on their replica, but the next morning, everything should be back to the way DomainA’s replica is.
Most importantly…I do not want any deletions to ever creep back over to DomainA.
Does this make sense? I can answer any questions that my rambling explanation may have created.
Thanks for anyone who is willing to try to help.
- Matt