Mono Support How to migrate existing users to Mono? 

Viewed 9091 time(s), 3 post(s), 2/23/2012 6:17:39 PM - by sam0864
2/23/2012 6:17:39 PM
656 Reputation 79 Total posts

We have a list of existing users (username, password, email). I would like to move those users to Mono. Do you have a script I can re-use or utilize? Any advice in writing the sql script?

Thanks

1
2/24/2012 8:24:42 AM
15993 Reputation 2214 Total posts

Hi,

basically we can't have a script that can be used in all the scenarios that our customers have, but we can guide you through the process. First thing that you need to do is let us know how your user related data model looks like. After that we can guide you through the process. 

Basically you need to import your user data into three database tables, first you need to insert data to a Aspnet_Users table, then Aspnet_Membership table (take a look at the ASP.NET Membership model and providers on the MSDN) then you need to import roles in the Aspnet_Roles table and connect the roles to users in the Aspnet_UserInRoles table. Then you can copy other user data to UserProfile table.

Let us know if you need anything else.

Regards

2
2/27/2012 5:11:26 PM
656 Reputation 79 Total posts

Thank you for the quick response. I will try to import a sample list and let you know

3
This is a demo site for MonoX. Please visit Mono Software for more info.