Migrate membership, roles and profiles

Question

Migrate membership, roles and profiles

robert.szymanski

SSC-Addicted

Points: 484
More actions
August 31, 2009 at 7:01 am

#213884

Greetings all,
I have a requirement to migrate user information from a csv file into an ASP.NET membership and roles schema. The data includes some custom fields which I'm thinking can reside in an aspnet_Profile schema.
I'm considering using SSIS to meet this requirement. My question revolves aroung the question if there is a means to easily leverage and existing SSIS destination task to load membership, roles and profiles. Does anyone know if this exists anywhere?
Assuming a destinatin task of this flavor doesn't exist, would I need to leverage a custom script task an leveage the membership, roles and profiles API to perform the loading?
I'm open to alternatives, if anyone has 'em.
Thanks in advance.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

There are two ways to do this one you create a database do your SSIS and then run aspnet_regsql utility on the database. If that is not right then your other option is to create the AspnetDB and create your SSIS package to load all members into that database. I think you need to write code for Roles and the profile you could use the default which is a serialized file or check the Asp.net web site to use the Table profile provider. This will get you started.

Kind regards,
Gift Peddie

robert.szymanski SSC-Addicted Points: 484 More actions · Answer 2

I was able to get the Table Profile stuff working no problem. I'm currently trying to figure out how to call the System.Web.Security.Membership API from w/in a custom script component. It is in here where I was hoping to programatically CreateUsers, add to existing roles etc.

Can anyone help me out?

Thanks.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

I am not sure you can do that but here is how you can use the profile with a new database with your users.

http://forums.asp.net/p/1059007/1515369.aspx#1515369

Kind regards,
Gift Peddie

robert.szymanski SSC-Addicted Points: 484 More actions · Answer 4

Thanks for your help. After discussions with some of my microsoft guru contacts, they suggested I simply create a console or winforms app to leverage the membership, roles and profiles api there. They had informed me that using the these apis w/in SSIS had not been tested and basically they had not done this in the past. I believe I will head in this directin b/c as interesting as it sounds from a academic standpoint, my PM won't appreaciate it very much if I venture into R&D for Microsoft.

Thanks,

Bob

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

The guru must be talking about client services that uses configuration file to do it for you check the links below for the docs and existing sample implmentation.

http://msdn.microsoft.com/en-us/library/bb546195(VS.100).aspx

http://aspalliance.com/1597_Client_Application_Services__Part_3.all

Kind regards,
Gift Peddie