Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Merge Replication - Agent jobs maintaining data


Merge Replication - Agent jobs maintaining data

Author
Message
Shaira
Shaira
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 276
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 Unsure 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!
Nils Gustav Stråbø
Nils Gustav Stråbø
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2013 Visits: 3575
Data modifications done by an agent job are handled the same way any other modifications are.
happycat59
happycat59
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3563 Visits: 3101
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search