migrating to a contained database in sql server 2012
DESCRIPTION
This screencast discusses the benefits derived by the new feature of Contained Databases in SQL Server 2012 and demonstrates how you can migrate an existing database in SQL Server 2012 to a Contained Database. -- Subscribe to The SQL Server and .NET TV! http://bit.ly/Rk7abL Follow me on Twitter! http://twitter.com/artemakis Find me on my Blog! http://aartemiou.blogspot.com/TRANSCRIPT
Artemakis Artemiou SQL Server MVP
CDNUG Lead
INETA Country Leader (CY)
http://aartemiou.blogspot.com
Migrating to a Contained Database
December 20th, 2012
SQL Server 2012
Screencast Series
What are Contained Databases
• Isolated from other DBs and the SQL
Server Instance
• Majority of the metadata that describes the
database is maintained within the
database
• Users in contained DBs no longer
associated with SQL Server Logins
• Simplified security model
• Portability
Authentication
• Contained User
– Contained User with Password
– Windows Principals
• Enable Contained DB Authentication sp_configure 'contained database authentication', 1;
• Disable Contained DB Authentication sp_configure 'contained database authentication', 0;
Traditional DB Migration Scenario (I)
Application
SQL Server Instance 1
DB DB DB AW
DB
SQL
Login
Access Granted
Traditional DB Migration Scenario (II)
Application
SQL Server Instance 2
DB DB DB AW
DB
SQL
Login
Access Denied ** If the SQL Login is not migrated
Contained DB Migration Scenario (I)
Application
SQL Server Instance 1
DB DB DB AW
DB
Access Granted
Contained
Database
Contained DB Migration Scenario (II)
Application
SQL Server Instance 2
DB DB DB AW
DB
Access Granted
Contained
Database
Contained DB Migration Scenario (N)
Application
SQL Server Instance N
DB DB DB AW
DB
Access Granted
Contained
Database
Demo 1: Migrating a Traditional DB
Demo 2: Migrating a Contained DB
Demonstration
Summary
• Contained Databases Introduce a New Security
Model
• Isolated from other DBs and the SQL Server
Instance
• Users in contained DBs no longer associated with
SQL Server Logins
• Authentication
– Contained User with Password
– Windows Principals
• Portability = More Robust Data Applications
Resources
• Contained Databases on MSDN Library – http://msdn.microsoft.com/en-us/library/ff929071.aspx
• Microsoft SQL Server Official Website – http://www.microsoft.com/sqlserver/en/us/default.aspx
• SQL Server Blog
– http://blogs.technet.com/b/dataplatforminsider/
• The SQL Server and .NET Blog
– http://aartemiou.blogspot.com
• The SQL Server and .NET TV – http://www.youtube.com/sqlserverdotnetblog
• Follow me on Twitter! – http://twitter.com/artemakis