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.
Add a comment
|
2 Answers
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.
3 Comments
Ignacio Soler Garcia
Just what I was looking, as always they do it first :) Thanks!
Herman Cordes
Sometimes there's more to it... check last reply of 'noonie' on social.msdn.microsoft.com/Forums/en/vstsdb/thread/…. "And I've found out why you are getting the drop database in your script. If you have not set a Target connection (or subsequently cleared the previous setting) the deploy process adds the drop & create statements to the .sql file regardless of the setting in the Database.sqldeployment file."
William Jockusch
I'm not seeing this in VS 2019. Where is the setting?
You should check the Always re-create database option under publish.
DB Project -> Right Click -> Publish -> Advanced
