MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

How to migrate existing users to Mono?  (Mono Support )

Viewed 5823 time(s), 3 post(s) 2/23/2012 6:17:39 PMby sam0864
sam0864

sam0864

2/23/2012 6:17:39 PM
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
This content has not been rated yet. 
656 Reputation 79 Total posts
khorvat

khorvat

2/24/2012 8:24:42 AM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts
sam0864

sam0864

2/27/2012 5:11:26 PM
Thank you for the quick response. I will try to import a sample list and let you know
This content has not been rated yet. 
656 Reputation 79 Total posts