DB deployment - Create if not exists

paraggadkariparaggadkari Posts: 21
edited December 19, 2013 11:13AM in Deployment Manager
For DB deployment, there are two options for each environment:
- Upgrade
- Drop and Create

Is there a way to create the DB if not exists otherwise upgrade the existing DB?

Thanks!
· Share on Twitter

Comments

  • Mike UMike U Posts: 316 Gold 1
    Upgrade mode will do what you want. Drop and create always drops any existing database before recreating it, while upgrade just applies whatever changes are necessary. This includes creating the database if it doesn't exist.
    Development Lead
    Redgate Software
    · Share on Twitter
  • paraggadkariparaggadkari Posts: 21
    Unfortunately, "Upgrade" mode looks for a DB and fails with network error if DB doesn't exist.

    After searching through the documentation, I did find this behavior documented in the below link:
    · Share on Twitter
  • Mike UMike U Posts: 316 Gold 1
    Would you be able to post the deployment log from the failing deployment? If you go the deployment details page and click the 'Raw' link, you'll get a plain text version of the log you can copy and paste.
    Development Lead
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.