Home Forums SQL Server 2012 SQL 2012 - General No More Transactional Replication with Updatable Subscriptions RE: No More Transactional Replication with Updatable Subscriptions

  • SQLKnowItAll (5/31/2012)


    Well... As a final update I have found that it will in fact be removed later on an MS site.

    Hi,

    Have you researched your go-to for replacing this feature? I did not know that bi-directional needed a custom conflict resolution, but did with p2p. I had a question posed today about a topology requiring a 'local' server in London, and another set of servers in the US, their thinking was that they wanted to update only a local server. In that case P2P would work, but I can't guarantee only 'limited' DML.

    Any other things that you've uncovered that you can share? Sort of a tough nut to crack; Oracle has some good arguments for their built-in methods to handle this. Seems that we have to do a 'hack' in order to match their features (ie mirroring combined with clustering, hag, etc).

    Thanks

    Lee