In this blog post we will see how we can deploy SQL Server database to Windows Azure SQL Database. Both SQL Server 2012 and 2014 has a wizard to deploy a database to another SQL Server instance running in Windows Azure Virtual Machine. According to the white paper on the reference section “there is no performance overhead for this operation because the major factor in defining deployment time is the size of the database itself.”
Let us see how we could deploy a database to SQL Server running on windows Azure in action:
Right click on SQL Server, click on Tasks then click on Deploy to SQL Azure…
On the next dialog box click on connect and enter your SQL Azure account credentials.
Then click on connect on the above dialog box then click next
On the next dialog box verify the specified settings and click on Finish
The import process might take a while and wait for it to finish patiently
Oops in our first attempt the deployment failed. If you remember from our last blog every table in the database is required to have clustered index in SQL Azure. So let us create a clustered index for it and try again.
This time the deployment succeeded.
The deployment from SQL Server 2014 to SQL Server on Windows Azure has similar process
After you successful deployed your database you will see the same exact database on SQL Server running on Windows Azure.