TechQA.

How to exclude user related object from DacPac file

635 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

visual-studio sql-server-data-tools dacpac ssdt-2017
Original Q&A
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

Related Questions in VISUAL-STUDIO

Related Questions in SQL-SERVER-DATA-TOOLS

Related Questions in DACPAC

Related Questions in SSDT-2017

Popular Questions

Popular Tags

javascript python java c# php android html jquery c++ css ios sql mysql r reactjs node.js arrays c asp.net json python-3.x ruby-on-rails .net sql-server swift django angular objective-c pandas excel

Trending Questions