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

No More Transactional Replication with Updatable Subscriptions Expand / Collapse
Author
Message
Posted Thursday, May 24, 2012 12:49 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 10:58 AM
Points: 2,706, Visits: 3,426
So, Microsoft decided that they were deprecating Transactional Replication with Updatable subscriptions. In that case, you have 2 options (if I am correct): Pay for Enterprise (if you are already not) and use peer-to-peer or use bidirectional transactional replication which is basically setting up a transactional from db1 to db2 and also transactional from db2 to db1.

The issue I see in both cases is conflict resolution. With updatable subscriptions, you could specify how to handle the conflict. With either of these 2 options (from what I can tell) you cannot allow the engine to handle this for you. You must do it manually.

Any thoughts? Seems like a slap in the face to those who have been using MS for years and a damn good reason for companies that rely on updatable subscriptions to not upgrade to 2012.


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1306071
Posted Thursday, May 24, 2012 3:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 10:58 AM
Points: 2,706, Visits: 3,426
For those interested... It seems that they did not "deprecate" the feature of Transactional Replication with Updatable Subscriptions, but removed the option from the Wizard. You can still create a publication through sp_addpublication and then add the subscription (with the same settings) either through the wizard or manually. Seems kind of silly to me.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1306190
Posted Thursday, May 31, 2012 3:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 10:58 AM
Points: 2,706, Visits: 3,426
Does anyone know if the feature is mentioned my MS as deprecated, or was this just noticed by some in the Wizard? I cannot find any actual MS documentation on the feature being deprecated.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1309372
Posted Thursday, May 31, 2012 3:16 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 10:58 AM
Points: 2,706, Visits: 3,426
Well... As a final update I have found that it will in fact be removed later on an MS site.

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1309374
Posted Thursday, May 31, 2012 3:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:51 AM
Points: 20,807, Visits: 32,742
SQLKnowItAll (5/31/2012)
Well... As a final update I have found that it will in fact be removed later on an MS site.


Do you have a link to this info?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1309376
Posted Thursday, May 31, 2012 3:27 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 10:58 AM
Points: 2,706, Visits: 3,426
Sorry... Clicked send before I pasted it

http://msdn.microsoft.com/en-us/library/ms143550%28v=SQL.110%29.aspx


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1309381
Posted Monday, August 25, 2014 5:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 17, 2014 4:02 PM
Points: 19, Visits: 236
That link shows a number of features of updatable subs that are removed - while this says the entire feature (itself) is being deprecated:
http://msdn.microsoft.com/en-us/library/ms151718.aspx




Post #1607299
Posted Tuesday, November 4, 2014 4:11 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 9:49 AM
Points: 215, Visits: 652
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





Lee Everest

Post #1630909
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse