I have a system created that a user at one of our other locations and on their server inserts a record. That data is then replicated to a central server. Users working on the central server are allowed to edit that record which means I have to lock the editing capabilities at the location the record was created.
However, i would like the creator of the record to be able to edit it so I am thinking about redirecting them across servers to edit the record on the central server. IS that bad practice and why??
The reason I only allow editing on one of the copies of the record is to prevent it from being copied over in replication.....
WE are also considering Bi-directional replication.
asked Feb 23, 2010 at 03:36 PM in Default
It does sound like merge replication might work well for you.
To answer your initial question, I'd say ... it depends! Seriously though, here are my thoughts regarding editing data on the central server:
If your central server is local, you might not have any performance issues. I recommend trying some queries and compare performance results from each server.
answered Feb 23, 2010 at 04:08 PM
Tom Staab ♦