Client wants to schedule replication of a local database with 2 different servers. On the Schedule view I set the options to any tryXXXX first but it only seems to replicate that server.
Help please
Subject: not a good tactic
What your customer is asking you to do is essentially to use his local machine to create a replication connection between two servers. (Because any changes he receives from the one will get passed to the other, and vice-versa.) It would be more efficient to set up a replication schedule between the two servers, and have his local machine only replicate with one of them. If this is not desirable, then you have to ask yourself “why?”…and I suspect the answer to that question will open up a can of worms.