I am a relative newbie when it comes to SQL Azure!! I was wondering if there was a definitive list somewhere regarding what is and is not supported by SQL Azure in regards to SQL Server 2008? I have had a look through google but I've noticed some of the blog posts are missing things which I have found through my own testing:

For example, quite a lot is summarised in this blog entry http://www.keepitsimpleandfast.com/2009/12/main-differences-between-sql-azure-and.html

• Common Language Runtime (CLR)
• Database file placement
• Database mirroring
• Distributed queries
• Distributed transactions
• Filegroup management
• Global temporary tables
• Spatial data and indexes
• SQL Server configuration options
• SQL Server Service Broker
• System tables
• Trace Flags

which is a repeat of the MSDN page http://msdn.microsoft.com/en-us/library/ff394115.aspx

I've noticed from my own testing that the following seem to have issues when migrating from SQL Server 2008 to the Azure:

• XML Types (the msdn does mention large custom types - I guess it may include this?? even if the data schema is really small?)
• Multi-part views

I've been using SQL Azure Migration Wizard v3.1.8 to migrate local databases into the cloud.

I was wondering if anyone could point to a list or give me any information till when these features are likely to be included in SQL Azure.