How to exclude user related object from DacPac file

633 Views Asked by At

I am creating SSDT project using visual studio, I want to remove the users-related object from the dacpac file before deploying it.

I tried to exclude objects from the 'Advanced Deployment Settings' but as you can see on the following screenshot, all options are disabled. could you please advise on this?

enter image description here

1

There are 1 best solutions below

1
On BEST ANSWER

If you mark DROP objects in target but not in project before you go in Advanced you will get them enabled:

enter image description here