Deploy Database to Azure SQL Database

I was trying the new service tiers for Azure SQL Database (still in preview) at this point.  I wanted to test out “Basic” Edition.

Problem:

When I tried to do a web deploy from VS2013, it failed with error message:

“Failed to import target model <DBName>. Detailed message Unable to reconnect to database.”

Solution:

When I downgraded the Azure SQL Database Edition from “Basic” to “Web”.  The web database deployment succeeded.

image

Problem:

The schema deployed fine.  Now I want to deploy the data as well.  However, the VS 2013 project settings “Package/Publish SQL” seem to be ignored and over ruled by the Web Deploy settings.  The Web Deploy will only compare and update schema.

Solution:

After failing to find a quick way to do this, I resorted back to the good ole SQL Server import and Export & VS 2013 Data Compare to copy data from LocalDb to Azure SQL Database

Note:

I will switch back to “Basic” edition because I want to verify the following features:

  • Point-in-time Restore: Any point within 7 days”
  • Security: Auditing
  • Disaster Recovery: Geo-restore, restore to any Azure region
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s