Post reply

Replication Agents

  • January 28, 2009 at 12:18 am

    #204554

    Comments posted to this topic are about the item Replication Agents

  • January 28, 2009 at 12:22 am

    #933648

    Could someone please explain why "Applies data changes to subscribers" is wrong?

    Thanks!

    Best Regards,

    Chris Büttner

  • January 28, 2009 at 2:10 am

    #933663

    Christian Buettner (1/28/2009)

    Could someone please explain why "Applies data changes to subscribers" is wrong?

    Thanks!

    Hi Chris,

    I guess the short answer would be "because only the other three are verbatim quotes from the BOL page referenced in the answer explanation".

    The longer answer will probably be different. It will be either a long and philosophical discussion trying to convince people that, even though merging changes from the distributor is in fact a way to apply changes to the subscribers, the latter is more generic and blah blah blah. Or, more probable, it will be an apology and points awarded back. 🙂

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • January 28, 2009 at 2:19 am

    #933667

    That was a very nice explanation, thank you.

    I just wanted to make sure I did not miss anything and will NOT start a long discussion;-)

    Best Regards,

    Chris Büttner

  • January 28, 2009 at 6:36 am

    #933753

    If the Merge agent does not apply data changes to the Subscriber, then what does? There is not Distribution Agent in Merge Replication, is there?

  • January 28, 2009 at 7:28 am

    #933801

    DIRECT QUOTE FROM BOL: "By default, the Merge Agent uploads changes from the Subscriber to the Publisher and then downloads changes from the Publisher to the Subscriber"

    Merge Replication is 2-way. Basically all choices are valid.

  • January 28, 2009 at 7:32 am

    #933806

    That was the way I read it also. It doesn't explicitly say in BOL that it applies data changes to the Subscriber but from reading the description it seems to me that it performs this function.

  • January 28, 2009 at 8:58 am

    #933888

    Apologies. A case of a made up answer colliding with a real one.

    Question corrected, all points awarded back, as predicted by Hugo.

  • January 28, 2009 at 9:55 pm

    #934385

    Hugo Kornelis (1/28/2009)

    Christian Buettner (1/28/2009)

    Could someone please explain why "Applies data changes to subscribers" is wrong?

    Thanks!

    Hi Chris,

    I guess the short answer would be "because only the other three are verbatim quotes from the BOL page referenced in the answer explanation".

    The longer answer will probably be different. It will be either a long and philosophical discussion trying to convince people that, even though merging changes from the distributor is in fact a way to apply changes to the subscribers, the latter is more generic and blah blah blah. Or, more probable, it will be an apology and points awarded back. 🙂

    You should get 1 bonus point for your prediction...:)

  • December 7, 2010 at 8:38 am

    #1259579

    Nice question, I learned something (it's very easy me to learn something new about merge replication, as I've never used it).

    Tom

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply