Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Can you please explain any one brief about the merge replication? and what is the difference b/w transaction replication with updatable subscription and merge replciation

Answered Can you please explain any one brief about the merge replication? and what is the difference b/w transaction replication with updatable subscription and merge replciation

  • Friday, January 04, 2013 6:36 PM
     
     
    Sign In to Vote
    0

    Can you please explain any one brief about the merge replication?and how it works and what is the difference b/w transaction replication with updatable subscription and merge replciation




    • Edited by g2sk1986 Friday, January 04, 2013 6:38 PM
    • Edited by g2sk1986 Friday, January 04, 2013 6:44 PM
    •  
     

All Replies

  • Friday, January 04, 2013 6:43 PM
     
     Answered
    Sign In to Vote
    0

    They don't really do the same things.

    Basically with merge replication when a synchronization occurs, the final state of the rows is what is merged with the other side. So if I have a stock tracking table which each stock is updated thousands of times between synchronizations only the last value of the stock will be replicated.

    With transactional replication with updateable subscribers the changes (the DML) will be replicated as transactions. So if a row in our stock table is updated 1,000 times there will be 1000 indivdual transactions will be replicated.

    Now updateable subscribers is being deprecated and will likely not show up in SQL 11 and peer to peer is the desired upgrade path.

    So if you need transactions replicated transactionally you would want updateable subscribers, if you want bi-directional synschronization between nodes which are frequently disconnected - merge replication is the way to go.

    SRC: MSDN

     
  • Friday, January 04, 2013 7:34 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    You may find this link helpful.

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

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941