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.
When the wizard launches, it has incorrect (outdated) database settings available:
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?
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):
I see no pending updates from Windows Update, however.