sql-servervisual-studiosql-server-2008visual-studio-2010drop-database

Database Project to Drop Database before deploy?


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.


Solution

  • 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.