Been looking at Azure a bit as there has been a lot of movement at the moment since this thread.
First up azure now supports full trust
and integrated pipeline mode
so looking good in terms of running SF in a web role..? Has anyone tried squeezing Sitefinity into a web role yet?
Also with the release of SQL azure it looks as if we should be able to host the SF DB in the cloud too.
The feature set of SQL azure is changing. I tried using this migration tool
which helps you migrate an existing DB to the cloud and got some errors:
"Deprecated feature 'More than two-part column name' is not supported in this version of SQL Server"
I went through the script the tool generates and changed the notation. This just means removing the dbo. from the create stored procedures. This allowed me to create all the tables and SP's in Azure without problems :)
However, when I fired up the Sitefinity and set it to use the Azure DB I got the same error, so obviously the calls to the DB from Sitefinity are also using this naming notation?
System.Data.SqlClient.SqlException: Deprecated feature 'More than two-part column name' is not supported in this version of SQL Server.
This seems very close to working! Can anyone see a way around it?