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

Improve this question

1 Answer 1

Reset to default
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

Improve this answer
1
  • This link is no longer active Commented Mar 31, 2023 at 5:40

Your Answer

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.