Database project to delete a database before deployment?

Question

Is it possible to get VS to delete the destination database before deployment?

I tried to add a post-deployment script to the project, but it always returns with active connections.

Answer 1

You need to find the Always recreate database option in the properties of the database project → Deploy → Deployment configuration file → Edit dialog.

You may also find it useful another option: "Drop objects that exist in the target database, but not in the schema."

Answer 2

You must select the Always re-create database option when publishing.

Database Project → Right Click → Publish → Advanced

Answer 3

In your post-deployment scenario, did you try to kill active connections first?

There's a good answer to this script to kill all database connections (more than RESTRICTED_USER ROLLBACK)