Saturday 27 December 2014

Contained Databases - SQL Server 2012

SQL Server 2012 introduced a new feature called Contained Databases.
Database is a collection of data objects, views, sps and users also. If you move database from ServerA to ServerB then we might not able to access the database using ServerB Logins because there is a dependency between server and database, logins will be stored under server level and users are stored at database level.
Hence database is not a individual component, This contained database can break the barrier of dependency.

If we migrate the contained database into other server (from ServerA to ServerB) then we need not to createa any logins to make use of it.
 

No comments:

Post a Comment