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

Click Add

Click Server and Create a New server

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

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

 

Open SSMS On-Premises and Connect to Azure database Server

Connect to On-Premises SQL Instance

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

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

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

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