SQL Azure Compatibility

I believe you can add a new key to this table manually and make it primary key. Even if this key column won't be in use it will make this table SQL Azure compatible.
Could you also share details on how you make your app working on Azure platform? In my understanding it were primarily designed for .NET languages.

Azure seems to be PHP friendly and Micro$oft seem to encourage - http://msdn.microsoft.com/en-us/library/windowsazure/ff394110.aspx
To get PHPR running with Azure, I simply created a PHPR project, selected SQL Server and pointed it to the Azure database (servername.database.windows.net). Seems to work ok, other than the problem I mentioned.
Because it can't create the _ugmembers table, I can't add the key manually. If I create the dynamic permission tables manually with primary keys, I presume once I select dynamic permissions in PHPR it will utilise these tables and not try and create. Is that correct?

I see what you saying. You have two options here.

1. Create tables manually and point PHPRunner to them.
   
   or
   
2. Modify SQL script in C:\Program Files\PHPRunner6.0\SQL\mssql\permissions.sql file adding a primary key.