Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

vs2015 ssdt : publish could not drop table from db (deleted from package)

I am successful to add create a table in SSDT project and publish to DB. The Publish could not drop that table from database when it has been deleted from project.

enter image description here

Even 'Drop objects in terget but not in project' checked in project\Properties\Debug\Deployment options.

However, it is working when upgrading the database from the .dacpac (in review the upgrade plan).

enter image description here

Could not find 'Drop objects in terget but not in project' in project\My Advanced Publish Settings:

enter image description here

Any idea please?

like image 921
beewest Avatar asked Dec 06 '25 07:12

beewest


1 Answers

It is in tab Drop of Publish\Advanced

enter image description here

like image 153
beewest Avatar answered Dec 07 '25 23:12

beewest



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!