Unable To Import/deploy Database To Sql Azure: "the Service Objective (business/web) Specified Is Invalid."

I'm trying to move my databases to a newer Azure subscription. I used to simply click 'Deploy to Azure' on a local database from SSMS and have it deployed to a specified Azure serv

Solution 1:

You are getting this error because the latest V12 servers are not supporting the Web and Business Editions anymore. If you don't want to upgrade to SSMS 2014, you can create a V11 server and import your DB on this server. However this is only a temporary solution as Web and Business edition databases will be retired in September. At this point you will have to work with the latest tools to avoid this problem.

Solution 2:

There is a Hotfix for it you can download and install on your machine. Please navigate to: https://support.microsoft.com/en-gb/kb/2936603 You need to enter your email then download link will be sent to your email address. Then install it on your machine and you can see the following options:

Solution 3:

Install the database as a Data Project into Visual Studio, Set the target framework in the properties window to SQL Azure, Build the project and resolve any unsupported issues. Publish to your azure site.

I have tried the above and did not work for me - this solution worked!