Is it possible to get VS to drop the destination database before a deploy?
I've tried adding a post deploy script to the project, but it always comes back with active connections.
Is it possible to get VS to drop the destination database before a deploy?
I've tried adding a post deploy script to the project, but it always comes back with active connections.
You should check the
Always re-create database
option under publish.DB Project -> Right Click -> Publish -> Advanced
You'll need to look up the
Always recreate database
option in the properties of the database project -> Deploy -> Deployment configuration file -> Edit Dialog.Another option "Drop objects that exist in the target database but not in the schema" can also be useful to you.