SQLServer Replication, dealing with updating data in a subscriber without merging with the publisher
- by FlySwat
To simplify my problem, picture two databases, one is a publisher, one is a replicated subscriber.
Most of the time, changes are configured in the publisher, and pushed to the subscriber once per day using transactional replication. (The subscriber is the main production database).
However, on a rare occasion, we need to make a change directly to…