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

Replication Agents Expand / Collapse
Author
Message
Posted Wednesday, January 28, 2009 12:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:38 PM
Points: 31,018, Visits: 15,453
Comments posted to this topic are about the item Replication Agents






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #644713
Posted Wednesday, January 28, 2009 12:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:05 AM
Points: 2,842, Visits: 3,875
Could someone please explain why "Applies data changes to subscribers" is wrong?

Thanks!


Best Regards,
Chris Büttner
Post #644714
Posted Wednesday, January 28, 2009 2:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:36 PM
Points: 6,002, Visits: 8,267
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #644734
Posted Wednesday, January 28, 2009 2:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:05 AM
Points: 2,842, Visits: 3,875
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
Post #644741
Posted Wednesday, January 28, 2009 6:36 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 8:36 AM
Points: 3,918, Visits: 3,638
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?
Post #644855
Posted Wednesday, January 28, 2009 7:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 18, 2013 8:39 AM
Points: 1,219, Visits: 226
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.
Post #644913
Posted Wednesday, January 28, 2009 7:32 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 8:36 AM
Points: 3,918, Visits: 3,638

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.
Post #644918
Posted Wednesday, January 28, 2009 8:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:38 PM
Points: 31,018, Visits: 15,453
Apologies. A case of a made up answer colliding with a real one.

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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #645006
Posted Wednesday, January 28, 2009 9:55 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,371, Visits: 1,391
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...:)



Post #645578
Posted Tuesday, December 7, 2010 8:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:36 AM
Points: 7,688, Visits: 9,412
Nice question, I learned something (it's very easy me to learn something new about merge replication, as I've never used it).

Tom
Post #1031271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse