Unable to deploy DB from local SQL Server

Question

I'm trying to export a DB from my local SQL Server to Azure SQL.

So far I've tried

Tasks > Deploy Database to Windows Azure SQL Database

I then connect to the Azure DB, give the new DB a name and then let it run.

However, it fails with the message

A project which specifies Microsoft Azure SQL Database v12 (Preview) as the target platform cannot be published to Microsoft Azure SQL Database.

Having followed this page, I'm pretty sure that I have the latest of whatever I need on my local.

So what am I missing? How do I get a DB from a local instance of SQL Server to Azure SQL?

As it still in preview, you'd better get in touch with Azure Support Team. — Thiago Custodio
– Thiago Custodio, Commented Mar 10, 2015 at 14:35

awj · Accepted Answer · 2015-03-27 15:33:10Z

3

Although there are several means to upload a local DB to Azure, I found that all but one of these fails with the same error message.

The one which worked is the SQL Database Migration Wizard.

answered Mar 27, 2015 at 15:33

awj

8,01917 gold badges77 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1