Oct 18, 2011 at 3:38 AM
Edited Oct 18, 2011 at 3:39 AM
I have an existing Azure database in production. I use a Data-Tier application (dacpac) to make changes to the schema. On Azure it is very slow (I am physically loacted a long way from data centre and Azure support has confirmed this is a problem with
current DAC engine).
I thought I might be able to use the bacpac as a means to upgrade the db, so I upgraded a local DB and used the -Extract argument to export the schema. But when i use the -Deploy argument on my Azure DB i get "Database 'DBName' already exists. Choose
a different database name."
Obviously if I choose a new name then I will have an empty DB with correct schema and a DB with data and old schema...
Is it possible to upgrade schema and not the data?