Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Merge Replication - Agent jobs maintaining data Expand / Collapse
Posted Friday, January 11, 2013 12:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:47 AM
Points: 65, Visits: 259
I am just learning about replication, as I have been asked to set up a merge replication for one of our databases. Besides being completely overwhelmed by the whole thing I do have a question that I cannot seem to find an answer for.

The database I plan to set up replication for has several SQL Agent jobs that add/update/maintain the data within the tables. How are Agent jobs handled with merge replication? Are jobs on both the publisher and the subscriber, or do they run only on the publisher and then the data is updated when synchronization occurs?

As a side note - I have learned lots from the Stairway to Replication by Sebastian Meine. Excellent reading – and for a newbie like me, written in language I can understand. Kudos to Sebastian!
Post #1406217
Posted Thursday, February 7, 2013 11:09 AM



Group: General Forum Members
Last Login: Wednesday, September 17, 2014 2:30 AM
Points: 1,869, Visits: 3,454
Data modifications done by an agent job are handled the same way any other modifications are.
Post #1417259
Posted Thursday, February 7, 2013 8:12 PM


Group: General Forum Members
Last Login: 2 days ago @ 1:00 AM
Points: 2,993, Visits: 2,590
As far as merge replication is concerned, the SQL Agent Jobs that are updating data are no different to any other client application that is updating data. All that merge replication cares about is whether an INSERT, UPDATE or DELETE has occurred - not what process caused the INSERT/UPDATE/DELETE to be done. It also doesn't care which database is modified. Merge replication will make the equivalent changes to all other databases it knows about.

Post #1417436
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse