I just observed a difference in the result of publish vs schema compare. I made changes to visual studio database project - some of which involved deleting tables.
- Pushed changes to VSTS, build successful, release successful to Azure DB
- Inspected said Azure DB. Tables were not dropped that were deleted in the project. Double checked the publish script - this didn't include any of the drops.
- Ran SchemaCompare - this exposed all of the missing drops, and when executed gave me the result I expected (the applicable tables were dropped).
The same results were observed on local DB when manually publishing vs schema compare. What am I doing incorrectly? I thought publish would drop the tables.