{"id":2374,"date":"2012-08-16T10:40:00","date_gmt":"2012-08-16T10:40:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/webdev\/2012\/08\/16\/migration-for-user-accounts-from-the-sqlmembershipprovider-to-the-universal-providers\/"},"modified":"2012-08-16T10:40:00","modified_gmt":"2012-08-16T10:40:00","slug":"migration-for-user-accounts-from-the-sqlmembershipprovider-to-the-universal-providers","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/dotnet\/migration-for-user-accounts-from-the-sqlmembershipprovider-to-the-universal-providers\/","title":{"rendered":"Migration for user accounts from the SqlMembershipProvider to the Universal Providers"},"content":{"rendered":"

As you know ASP.Net SqlMembershipProvider \/ SqlRoleProvider only support Microsoft SQL Server and Microsoft SQL Server<\/font> Express. There is no support for <\/font>Microsoft SQL Azure<\/font><\/a> and Microsoft SQL Server Compact<\/font><\/a>. The ASP.NET Universal Providers have been created in order to add support for SQL Azure to be ready for cloud environments like Azure. <\/font><\/p>\n

<\/font> <\/p>\n

Here we will talk about how to migrate your existing<\/em> project with the SqlMembershipProvider for your <\/em>user accounts and passwords to the Universal Providers.<\/font><\/p>\n

<\/font> <\/p>\n

First, install the Universal Providers Nuget package. This will update the existing<\/em> project to use Universal Providers. You can also migrate the existing <\/em>user accounts and passwords from the SqlMembershipProvider to the Universal Providers using the instructions below.<\/font><\/p>\n

<\/font> <\/p>\n

Migrate all the accounts from the old tables to the new tables:<\/font><\/p>\n

<\/font> <\/p>\n