Tables without a clustered index are not supported in this version of SQL Server
You need to create a clustered index on all tables in SQL Azure that you wish to add rows to; otherwise the insert statement always fails.
CREATE UNIQUE CLUSTERED INDEX Idx_TableName ON TableName(yourGUIDColumn);
Here is a reference to the general guidelines and limitations specifically regarding these indexes: MSDN Link
Here is another article which explains the reasoning behind this: link
I found it easier to upgrade to v12.
I had to BACKUP (coz I'm smart like that!), then upgrade all my DB's (using the old console manage.windowszaure.com) from Web to Basic tier. Then follow instructions here to upgrade (https://azure.microsoft.com/en-us/documentation/articles/sql-database-v12-upgrade/)
Simply put:
- Open portal.azure.com
- Select Sqlserver
- Operations
- Latest SQL Database update
To monitor progress using azure powershell:
Add-AzureAccountSwitch-AzureMode -Name AzureResourceManagerGet-AzureSqlServer -ServerName '<<yoursqlservername>>' -ResourceGroupName '<<sqlserverresourcegroupname>>'