Another “be what’s next” moment

In yet another instance of getting real, I just swapped out the backend database for SnowstormLife.com to a SQL Azure Database. (The website itself is still on a 3rd party host, not on Windows Azure yet.)

It wasn’t that difficult. I simply needed to

  1. Create a SQL Azure Database (I already had an account)
  2. Create the Transact-SQL script for the table schema and data
  3. Run that script against the new SQL Azure database.

Don’t have an Azure account? Microsoft currently has a free trial available: http://www.microsoft.com/windowsazure/free-trial/

For steps 2 & 3, you can find step-by-step instructions with a sample here: http://msdn.microsoft.com/en-us/library/ee621790.aspx

I needed to add one piece to the script generated in step 2: the creation of a clustered primary key, which I discovered is a requirement in SQL Azure. (I didn’t have any primary keys defined in the old database.) It only took a couple of additional lines:

image

For more information about SQL Azure, head on over to the MSDN library: http://msdn.microsoft.com/en-us/library/gg619386(BTS.70).aspx

Another helpful resource is the SQL Azure FAQ: http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-faq.aspx

Enjoy.

— bliz

Have something you’d like to see in a future version of Visual Studio?

I just found out about the Visual Studio UserVoice site, located here: http://visualstudio.uservoice.com. From the site:

Welcome to the Visual Studio UserVoice site. Let us know what you would like to see in future versions of the Visual Studio suite of products. This site is for suggestions and ideas. If you need to file a bug, visit the Visual Studio Connect site: http://connect.microsoft.com/visualstudio.
 
We look forward to hearing from you!
 
Thanks – Doug Turnure
Visual Studio Team