2 SQL Server 2014 Cloud Enhancements (4) : Deploy SQL Server database to Azure

SQL Server 2014 ‘s new hybrid cloud solution make it easy to move the database from on-premises to the Cloud .

We can either move the database to the Microsoft Azure SQL database  or to the VM that on the Microsoft Azure with SQL Server instance. 

PREREQUISITES

• Create the SQL Server VM on Windows Azure
• Create the Windows Azure SQL Database

http://www.sqlpanda.com/2014/10/microsoft-azure-sql-database.html 

Deploy database to Windows Azure SQL Database

Select Database –> Tasks –> Deploy database to Windows Azure SQL database

Deploy database to Windows Azure Virtual Machine

Select Database –> Tasks –> Deploy database to Windows Azure VM

In the first try, I get error :

TITLE: Windows Azure Virtual Machine Settings
------------------------------

The Cloud Adapter port configuration is not valid. Verify the virtual machine endpoint configurations.

------------------------------
BUTTONS:

OK
------------------------------

This is because We need to add the CloudAdapter in the endpoint list.

Reference

http://blogs.technet.com/b/dataplatforminsider/archive/2013/12/10/sql-server-2014-hybrid-cloud-scenarios-migrating-on-premises-sql-server-to-windows-azure-virtual-machines.aspx