"Deploy Database to SQL Azure" Task missing

Microsoft has changed the procedure. What you need to do is Export/Import a Data-tier Application via a BACPAC file. Microsoft explains it here (in the section Backup Package (.bacpac): http://msdn.microsoft.com/en-us/library/ee210546.aspx

Here it is in a nutshell:

  • Use SQL Server Management Studio 2014
  • Right-click your local database name, then Tasks / Export Data-tier Application
  • Follow the wizard to create a BACPAC file on your local disk. This will contain your complete DB schema as well as your data.
  • In SSMS, connect to your existing Azure SQL account (tcp:xxxxxxxxxx.database.windows.net,1433)
  • Under the Azure account, right-click on the word Databases and select Import Data-tier Application
  • Using the wizard, import your BACPAC file "from local disk" When it is finished, you will have an Azure-based replica of your original database, schema, data and all.

This is not present in SQL Server Express 2014 - see https://connect.microsoft.com/SQLServer/feedback/details/859491/deploy-database-to-windows-azure-sql-database-missing