How to exclude user related object from DacPac file

609 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 answers

1
Krzysztof Madej 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