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

Reputation: 4184

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.

Upvotes: 7

Views: 3903

Answers (2)

Lukasz Szozda
Lukasz Szozda

Reputation: 176144

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

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

enter image description here

Upvotes: 1

user151323
user151323

Reputation:

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.

Upvotes: 6

Related Questions