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?
Best Answer
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