Friday, October 10, 2014

1 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

image

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

image

image

image

image

image

image

Deploy database to Windows Azure Virtual Machine

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

image

image

image

image

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
------------------------------
image

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

image

image

image

image

image

image

image

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

1 comments:

  1. best windows azure online training in hyderabad with work support and job assistance and high quality training facilities and well expert faculty
    to Register you free demo please visit
    windows azure training in hyderabad

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates