0

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

Krzysztof Madej
  • 32,704
  • 10
  • 78
  • 107
Adham Enaya
  • 780
  • 1
  • 11
  • 29

1 Answers1

0

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

Krzysztof Madej
  • 32,704
  • 10
  • 78
  • 107
  • Thank you, this one is ok. Please I have another issue if you can help in it: https://stackoverflow.com/questions/61650390/cant-deploy-dacpac-on-azure-devops-cd – Adham Enaya May 07 '20 at 05:18