"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