A first peek at the new released SQL Server 2014 CTP1 shows us the ability to use the Azure cloud. In the current version, SQL Server 2012, we already have the feature to deploy to a SQL Database within Windows Azure. A cool new thing is the “Deploy Database to a Windows Azure VM” feature. With this wizard you are able to publish your database to a Azure VM, all with some easy clicking work. In this blog i will show you how.
To use this new feature you have to make sure you have the following things ready
- A Windows Azure subscription
- A Windows Azure storage account
- A Windows Azure Cloud Service
- Publish settings for you Azure account
- Some spare time to play around
So, we will need a Windows Azure subscription. Makes sense if you want to deploy to the cloud you have a subscription. If you don’t have one, there are plenty ways of getting one, in some cases you are able to have 90-days free subscription, which is limited in resources. Or, if you are confident enough (which you should, since we are talking about Azure and SQL Server, duh) go with a payed account. Just sign up, use your credit card to validate and start playing around (and keep an eye on your bill ).
Withtin Azure you have to create a storage account. I can tell you how to do it, but if there is a change at that level within Windows Azure, i have to edit this blog post, so just go and visit