Database Project to Drop Database before deploy?

Is it possible to get VS to drop the destination database before a dep开发者_Go百科loy?

I've tried adding a post deploy script to the project, but it always comes back with active connections.

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.

You should check the Always re-create database option under publish.

DB Project -> Right Click -> Publish -> Advanced