1

When publishing a database from SSDT, there are several options to "do not drop" an object if it is not in the SSDT project. However, it seems that there is no option to avoid dropping schemas. Does anyone know if this is possible to achieve, or do I have to manually edit the published script?

This is the problem when I choose to "do not drop tables", but then it will try to drop schemas that have tables in them.

br Gert

Ehsan HP
2143 silver badges9 bronze badges
asked Jun 7, 2017 at 13:44

1 Answer 1

1

Use this:

https://github.com/GoEddie/DeploymentContributorFilterer

DeploymentPlanModifier for SqlPackager.exe to filter what actual gets deployed from a dacpac, you can choose to ignore or keep specific objects or types

And choose to keep schema's and it won't drop them anymore.

MS now has support for it SQL Server on Codeplex

John K. N.
18.9k14 gold badges56 silver badges117 bronze badges
answered Jun 7, 2017 at 14:08
1
  • This link is no longer active Commented Mar 31, 2023 at 5:40

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.