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
Last activity: Jul 3, 2023, 11:58 AM