SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Updatable Subscriptions Deprecated in SQL Server 2012

After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will officially be deprecated in SQL Server 2012.  According to Books Online, Microsoft is recommending that users switch to Peer-to-Peer Replication instead.  This is a shame considering Peer-to-Peer is an Enterprise-only feature and will cost significantly more than Standard Edition.  On the other hand, we will still be able to achieve updatable subscriptions in Standard Edition via Merge Replication.

Here are the screenshots comparing the SQL Server 2008 R2 New Publication Wizard with the SQL Denali CTP3 New Publication Wizard:

SQL Server 2008 R2 vs. SQL Server Denali CTP3

SQL Server 2008 R2 vs. SQL Server Denali CTP3 - New Publication Wizard

Hopefully Microsoft will still provide a way to implement Bidirectional Transactional Replication in SQL Server 2012 for all the little guys out there.  Although at this point, I'm unsure if that will be the case.  I'll be sure to update this post when I know more.


A blog about SQL Server Replication.


Posted by Anonymous on 31 October 2011

Pingback from  Dew Drop – October 31, 2011 | Alvin Ashcraft's Morning Dew

Posted by lmacdonald on 12 August 2014

This is so old that you are probably aware.  Bidirectional replication still works in 2012, you have to setup the publication and subscription via tsql.

Leave a Comment

Please register or log in to leave a comment.