Sample Header Ad - 728x90

DACPAC drops existing users and permissions from database when upgrading through SSMS

2 votes
2 answers
2684 views
I'm developing my database through a database project in visual studio, and whenever I need to upgrade the schema of my database I like to use SSMS to do this using a DACPAC. But whenever I use my DACPAC to upgrade the schema of my database, then the current existing Security Users and permissions for these users are being dropped. And I need them to remain in the database. Is there anyway to configure the DACPAC to not drop users and their permissions whenever I upgrade my database using "Upgrade Data-tier Application" in SSMS? Thanks in advance.
Asked by Emil Skovmand (21 rep)
Aug 17, 2022, 09:25 AM
Last activity: Jul 3, 2023, 11:58 AM