7

I'm attempting to test-deploy an existing SQL Server 2005 database into SQL Azure using the "Deploy Database to Windows Azure SQL Database" task in SQL Server Management Studio 2014.

enter image description here

When the wizard launches, it has incorrect (outdated) database settings available:

enter image description here

SQL Azure no longer uses "Web" and "Business" models, and when I try to perform the deployment it fails with the error message

The service objective 'Business' specified is invalid. (Microsoft SQL Server, Error: 40804)

I receive the same error when I attempt to run "Import Data-tier Application" using a .bacpac of my database. The settings are also old for that interface.

It appears SSMS is using an older deployment wizard. How do I correct this?


Edit:

I fired up a SQL Server 2014 VM on Azure and tried performing the same task. I observed the VM version of SSMS has a newer version number (right) than my local copy of SSMS (left):

enter image description here

I see no pending updates from Windows Update, however.

3

Use SSMS 2014 SP1. That works. Currently.

  • Yep, SP-1 came out April 2015, so this is now the correct answer. Thanks! – Chad Levy Jan 28 '16 at 22:27
9

I wouldn't have been able to find the solution to this problem if you hadn't decided to open the VM on azure and check the version numbers, so thank you!

After I saw your post, I googled "sql 12.0.2430.0" and found a hotfix from microsoft that fixed the problem.

You can find the hotfix Here

The update added full support for the new Azure SQL database tiers.

Cheers!

1

Microsoft have update the way that we do this now They do not have Deploy Database to Windows Azure any more

You now back up the file and then import the backup on to the azure box I tried multiple version of SSMS and not in them any more. Was last in SSMS 2014, where you need SP1 to get the new azure dbd type as WEB etc was retired.

Ref this person same issue Same Issue on stack exchange

This is link to what MS says about these new method About Data-tier Applications from MS

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.