How to install SQL Server? Need to use USE and SELECT INTO commands.

Question

I have created Azure virtual server where I installed succesfully custom .Net application.

Now I need to create SQL database in Azure. What is optimal architecture?

My requirements are followings: (these features were not supported before June 2012. I did try)
-Should support USE commands
-Should support SELECT INTO commands
-Should support Integration Services
-May support non clustered indexes.

Should I create SQL Database from Azure portal by clicking New? (are USE and SELECT INTO commands supported nowdays?)
Or Should I install SQL Server with my own licenses to created Virtual server? Any other way to meet my requirements? 

---

Kenny_I

Answer 1

use a SQL Server VM.

what you checked as not supported a month ago hasnt changed.

Answer 2

Thanks. It looks good.

Is it possible to create SQL Server Virtual Machine and install there IIS and Customer web application?

---

Kenny_I

Answer 3

its a VM, you can configure it.

however, you need to do some extra steps exposing IIS, see similar thread: http://social.msdn.microsoft.com/Forums/en-US/windowsazureconnectivity/thread/d1ebd51a-6c36-4b8c-a71b-6297434c0ad0/

moving forward though, i would suggest you review your app so you can deploy them on  Web Role/Web Site on Azure SQL Database  instead of a VM.

Answer 4

Have you looked into azure web sites, that actually fits in to your requirement. It provides web installation and sql server as well. You can deploy on shared infrastructor and also on dedicated infrastructure.

Unless you are very specific about having your own VMs for some reason, web sites would be the best fit for your requirement.

Look at this documentation for more details. You have pricing details also there.

---

Please mark the replies as Answered if they help and Vote if you found them helpful.