Author: MitchDW | Posted on: 9/21/2010 11:10:41 AM | Views : 542

Hello,
I have an existing ASPNET role/membership database created on SQLExpress 2005 (WIndows 2003 Server). I created it under the .NET 3 framework many years ago using the aspnet_regsql.exe application in full GUI mode. 
I am setting up a new Windows 2008R2 server with .Net Framework 4 and SQL Server 2008R2. I don't want users to have to recreate accounts or create roles, etc.
So...
1. Should I backup the current database and import it into the new system, and if so do I even need to use the aspnet_regsql.exe application. (If so which version do I use, different aspnet_regsql.exe files exist in different directories (i.e., FrameWork, FrameWork64)


2. Should I just run aspnet_regsql.exe on its own and then somehow try to import the current data into those tables.


I am concerned that if I just import somehow the roles within SQL server will not be created properly. 
thanks in advance,
mitch
...

Go to the complete details ...