Geek asks and answers

What is the real use of the contained databases

In SQL Server 2012, they entered the contained database. What is the real purpose of this feature? What are the disadvantages of previous versions fixed?

+3
source share
1 answer

They are designed to simplify the migration of databases between systems (both your databases and SQL Azure databases, which they need to move to balance resources). Everything that has a dependency outside the database is considered a risk, because it is the additional scaffolding that must come with the database - easy to forget, easy to make mistakes, easy to fall out of sync.

For example, in Denali these problems are addressed:

  • , , SQL - , SID . , SQL Server, , , , , .. .

  • , , , #temp, #temp , . , COLLATE , #tempdb , .

  • THROW() , sys.messages . , , , , , sys.messages. , .

  • , "", DMV, , , . , - .

. :

  • SQL Server . , SQL, , , , , script ( , msdb ). SQL Server , () , () , , , . , Azure, - ..

  • . , , , / .

, .

+8

More articles:


All Articles