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?
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.