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