http://www.sqlservercentral.com/blogs/sqlrepl/2011/10/29/updatable-subscriptions-deprecated-in-sql-server-2012/

Printed 2014/11/01 05:16AM

Updatable Subscriptions Deprecated in SQL Server 2012

By Brandon J Williams, 2011/10/29

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.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.