How to redeploy the Azure DB

with No Comments

Times that you would want to this, is probably after significant DB changes, or if you just want to start off with a shiny new DataBase

  1. On your DB project, select show all files, and include the azure.publish.xml in the project

  2. Now just double click it. You should see the following screen

  3. Click on Advanced
  4. Select re-create database

  5. Set the SQLCMD variable, DeployToAzure to 0
  6. Select the publish, and wait approx 10-15 minutes for your DB to be deployed

Leave a Reply