Migrating ASP.Net Membership Provider to Windows Azure

Many ASP.Net applications uses membership and role providers to manage identities, profiles, and permissions. Membership and role providers are based on a specific schema deployed to the local database instance.

The ASP team released a tool to create the required tables called regsql.exe. The tool will fail create the tables when using SQL Azure.

The solution is to download the scripts especially modified to run on SQL Azure and execute them manually.

A knowledgebase describing the process is found here.

Manu