Home Forums SQL Server 2012 SQL 2012 - General Contained database RE: Contained database

  • July 16, 2013 at 9:17 am

    #1632912

    c4ntaloop (7/11/2013)

    Thanks Steve.

    So that makes me think in what real scenario do we want to use contained database? We know that it can have contained users and solve collation issue, which makes a contained db is very portable and can be migrated easily anytime. But in what real case or why one want to sacrifice those features for the sake of easy migration. Can anyone please shed a light.

    Thanks.

    The main reason why contained databases have been implemented is the AlwaysOn Feature. (In fact it can be said that there is one major company with this specific demand)

    So in other words: Contained Databases are meant for AlwaysOn Failover scenarios, even though some of the feature may help in other circumstances. Second one would be deployment to Azure..

    Hope that helps.

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com