CODEWITHSUNDEEP
visual-studiosql-server-data-toolsdatabase-projectschema-compare
Shelly
Shelly

Reputation: 21

"Drop objects not in source" not honored

I'm attempting to use Schema Compare in SQL Server Data Tools to update my project from a database. I deselected "Drop objects not in source" setting but SSDT continues to drop objects that are not in the source (database).

I've tried it with tables and procedures, and I've tried it in the reverse direction (database updating project), as well as database updating a different database, but in every case, objects that do not exist in source are still dropped.

When I open the .scmp file the setting appears to be correct:

<PropertyElementName>
  <Name>DropObjectsNotInSource</Name>
  <Value>False</Value>
</PropertyElementName>

I'm using SSDT Visual Studio 2022 Enterprise. I'm on version 17.6.4.

Upvotes: 2

Views: 602

Answers (0)

Related Questions