"Deploy Database to SQL Azure" Task missing

I recently installed SQL Server 2014 Express on a workstation I have and am trying to deploy to SQL Azure. I've done this before on a previous workstation using SQL Server 2012 Express by doing the following:

Right click the database > Tasks > "Deploy Database to SQL Azure"

On SQL Server 2014, the option is completely missing and is instead replaced a new option: "Deploy Database to a Windows Azure VM"

I can't figure out why the option for deploying to SQL Azure is missing. Is there something that needs to be installed separately now for SQL Server 2014? From what I've read online, both options should be present for 2014 editions. Did Microsoft remove this option for SQL Server 2014 Express?

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.

StackExchange Database Administrators Q#64876, answer score: 11