All of the sudden, you need to deploy your application and you need a different database to store your information.
You’ll probably find this resource for deploying on a different version of Sql Server
Ok. You run the aspnet_regsql.exe utility, and you have the correct database, but it is empty.
What do you do now?
I’ve created this helper script to enable you to move all your applications/users/roles to a new database.
This script doesn’t actually INSERT the new data, but creates the TSQL code that you can run on the new database.
I’ve posted the code here (as a text file).
Hopefully, it will make your life a little easier when you need to copy to a new database all the Membership information.