Search code examples
visual-studiosql-server-data-toolsdacpacssdt-2017

How to exclude user related object from DacPac file

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

Solution

  • 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