visual studio 2013 - What is recommended to Import Settings in Database project -


i importing created database in visual studio 2013 sql server 2012. import database

but little bit confused why import permissions , import database settings default unchecked.

i think settings important why so.

reason 1: database administrator may want manage permissions , database-level settings directly on server.

reason 2: people put database-level settings in separate database project. useful when have multiple databases on same server, each having own database project, , don't want duplicate scripts logins & settings in each project. (that's how pre-ssdt database projects worked. you'd create server project server-level stuff in addition database projects.)


Comments

Popular posts from this blog

python - argument must be rect style object - Pygame -

c++ - Qt setGeometry: Unable to set geometry -

javascript - How To Make Two Container Heights Match? -