I have tried merging a local database using Red Gate SQL Compare 9 (you can of course also use the SQL Azure Migration Wizard), but that also gave me some errors regarding some elements in the resulting update statement that were not supported in SQL Azure.
I have looked into these errors and found that it was relatively easy to fix these. If you take a look at the Stored Procedure called
aspnet_Membership_GetNumberOfUsersOnlinein a "regular" SQL server, you'll see that it contains a couple of
(NOLOCK)statements in it's