Denali Contained Databases Not Compatible with Replication

I very much liked the idea of Contained Databases as it would make it much easier to move databases across different servers and even use this feature as part of a disaster recovery strategy. Here is really good article that explains how Contained Databases work in Denali:

http://www.sqldbadiaries.com/2011/02/01/contained-databases-in-sql-server-denali/

While very excited about this feature, I came across a big issue as it is not supported on databases that are either part of Replication, Change Data Capture or Change Tracking.

Now, as most of the databases I have in production are replicated in one way or another, it simply will not be possible to use it.

Leave a Reply

Spam Protection by WP-SpamFree

RedGate SQL-Compare
RedGate SQL-Compare
RedGate Data Compare
RedGate Data Compare
Quest Spotlight
Quest Spotlight
Quest Performance Analysis
Quest Performance Analysis