Often, when developing a database as a data-tier application package (more commonly known as DACPAC), you will need to execute regular deployments onto a local SQL Server instance, to verify that you haven’t accidentally broken anything when changing your database. Where this can get potentially complicated is when you are also managing security objects (contained user accounts, database…
Continue Reading The CRM Chap’s Article on their blog
Using Publish Profiles to Deploy a DACPAC Database Without User Accounts
Often, when developing a database as a data-tier application package (more commonly known as DACPAC), you will need to execute regular deployments onto a local SQL Server instance, to verify that you haven’t accidentally broken anything when changing your database. Where this can get potentially complicated is when you are also managing security objects (contained user accounts, database roles, etc.)
Blog Syndicated with The CRM Chap’s Permission