Wednesday, December 4, 2013

Migrate database to Windows Azure

Migrating database with table, store procedure, function, views from SQL server to Windows Azure is tedious job. When direct connection from Azure database to your MS SQL Express is not established then you can follow the below process:

1) Connect with SQL Server Management Studio 2012
2) Download SQL Database Migration Wizard (SQLAzureMW)
3) Convert your script from SQL Server to Windows Azure Compatiable
4) Run the script in Windows Azure


1) Connect with SQL Server Management Studio 2012


2) Download SQL Database Migration Wizard (SQLAzureMW)

http://sqlazuremw.codeplex.com/

Run SQLAzureMW
Fig 1.1: Home UI of SQLAzureMW



















3) Convert your script from SQL Server to Windows Azure Compatiable

4) Open the azure window and run the query over there.

Above steps are helpful when you can not directly connect with Azure database from your SQL server instance.


No comments: