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

1 Answer 1


Use this:


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

  • 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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.