Post reply

Whats the diff between merge publication and trnsactional publication with updatable sbscrptions

  • January 8, 2012 at 12:11 am

    #391257

    Experts,

    In simple words, what's the diff between merge publication and transactional publication with updatable subscriptions ?

    Thanks in advance.

    Smith.

  • January 8, 2012 at 12:26 am

    #1430113

    Check this.

    http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/d9d68385-2886-4b31-b92b-c2704da763fe

  • January 9, 2012 at 11:23 pm

    #1430907

    In a word HEAPS.....

    In short . . Merge has collision detection and the ability to implement custom conflict resolvers. There are other differences as well. Design of the tables matters with Transactional replication, primary keys and all. Merge adds a ROWGUIDCOL to the tables in the publication to create uniqueness. I wouldn't use Trans with updating subscribers in a Central subscriber scenario. Merge is more tolerant of network latency, in general, although one could argue that Queued updating subscribers are more so.

    CodeOn and have fun in 2012.

    😛

Viewing 3 posts - 1 through 2 (of 2 total)

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