Windows Azure – Migration of on premise SQL Server 2014 database to Azure

While planning to move your existing applications to Azure, one of the key considerations is how to move your existing on premise SQL server database to cloud. There is more than one way to accomplish this based on the specific requirement. For example, if you cannot afford down time between migration, the way forward is to use transactional replication setting your on premise database as publisher and your Azure SQL database as subscriber.

If real time migration isn’t a concern, you can go for exporting export your data (as .bacpac file that encapsulates a database’s schema and data) and importing it in your Azure database. Another solution is to deploy your on premise database directly to Azure as described below.

The feature to deploy database from SSMS to Azure was introduced in SQL Server 2012 and is available in SQL Server 2014 as well.

Deploy Database to Windows Azure SQL database

 

Note that the firewall settings for your Azure database server should be allowed to accept connections from your client IP.

Untitled21

The deployment wizard will let you to specify the connection and migration options as below.

Untitled17

Untitled18

Click on Finish to let the deployment/migration to complete

Untitled19

 

 

 

 

Advertisements

One thought on “Windows Azure – Migration of on premise SQL Server 2014 database to Azure

  1. Pingback: Windows Azure – Migration of on premise SQL Server 2014 database to Azure – Part 2 | MSBLOGS | Biju Paulose

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s