Hi,Has anyone migrated their ASP.NET app that uses Membership to the cloud? If so, did you have any issues with generating scripts for SQL Azure?Here's a detailed explanation of the issues I've had:The first issue was this: In my database, in one of the tables, I use the new -- actually not so new anymore -- HierarchyID datatype. When I tried to generate scripts for my database objects, SSMS gave me an error telling me that SQL Azure did not support HierarchyIDs. I then opened up a ticket w/ MS Online Support Team. They told me that SQL Azure now supports HierarchyID but the SSMS was released before the SQL Azure update which seems to be pretty recent. Therefore, SSMS is not aware of SQL Azure support for HierarchyID.Then we decided to use the "SQL Azure Migration Wizard v3.3.6" which is an open source app. Then we ran into the second issue: The wizard was skipping some of the stored procedures used by Membership because SQL Azure did not support some of the underlying objects. Here's one of the errors I got from the wizard:StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers] -- sp_droprole is not supported in current version of SQL AzureI'm sure I'm not the first person who's migrating his ASP.NET app that relies on Membership to the cloud. I wanted to see how others handled these issues -- or even had these issues in the first place.
View Complete Post