Migrate an On-Premises SQL Server 2012 Database to Windows Azure SQL Database – Part 1

How do you take an on-premises database and move it to Microsoft Azure Cloud?

You can migrate the On-Premises SQL database to Private Cloud SQL Server or Public Cloud (SQL VMs,SQL Database(Shared)). In this post we are migrating the On-Premises SQL Server database to Azure Shared SQL Server (PaaS). You can do this in 3 ways

1. SSMS : Deploy Database to Microsoft Azure SQL Database
2.Export Data-tier Application
3.Using SQL Azure Migration Wizard Tool- Download from CodePlex
4. SSMS : Deploy Database to a Microsoft Azure VM

SSMS : Deploy Database to Microsoft Azure SQL Database

Windows Azue SQL Database have some real advantage when it comes to cost and manageability. To have Database as a service is good for small scale business or websites which do not have lot of data to manage and do not want to manage the databases or servers of there own.The service replicates three copies of your data, and in the case of a hardware failure, it provides automatic failover.

Login to Azure Portal.Create SQL Database Server

MAzure1

Click Add

MAzure2

Click Server and Create a New server

MAzure3

MAzure4

MAzure5

MAzure6

Select the Database which is created above (dbMigration) and click Properties

MAzure7

Enable Server-level Firewall Rule using Azure Portal (https://manage.windowsazure.com)

MAzure8

 

MAzure9

Open SSMS On-Premises and Connect to Azure database Server

MAzure10

MAzure11

Connect to On-Premises SQL Instance

MAzure12

MAzure14

Click Next and Specify Target Connection (Azure SQL Database Connection)

MAzure15

Click Sign in and Add your on premises IP address to Azure firewall rule

MAzure16

Provide the Database Name for Target Server and Temporary file name location

MAzure17

MAzure18

MAzure19

After successful  completion of migration , connect to the Azure database and verify

MAzure21

 

Leave a Reply

Your email address will not be published. Required fields are marked *