VS2010 Database Project to Drop Database before deploy?

Question

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.

Any ideas?

Thanks!

Answer 1

You'll need to look up the "Always recreate database" option in the properties of the database project.

Another option "Drop objects that exist in the target database but not in the schema" can also be useful to you.