What are the disadvantages of contained database in Microsoft SQL Server 2017? I want to introduce contained database in my organization. I would like to know what limitations exist. Reasons why I should not implement it would be useful too.
Asked
Active
Viewed 30 times
1
-
That is a pretty broad question; it would depend on all sorts of things, such as size of your company, type of data, etc. – Mark Stewart Nov 20 '19 at 18:00
-
I think this question could essentially be "what limitations exist?" which would make it a more answerable question. This would answer a similar question of when contained databases are not a solution. @Azirila, if that addresses your question, you might try editing your question to take that alternate approach – AMtwo Nov 20 '19 at 19:01
-
There are several limitations listed in the docs: https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases?view=sql-server-ver15#Limitations – David Browne - Microsoft Nov 21 '19 at 03:46