How to migrate user data from an existing user table to the new aspnet_Membership and aspnet_Users tables in SQL 2000?

Hi there,

I guess it all depends on your current database scheme... I think you have at least 3 options:

1. Move over the data manually by copying it from the old website to the new one. May not be an option, especially if you have a lot of data or you have secured passwords.

2. Use something like SQL Server DTS or SSIS to copy the data from the old schema to the ASPNET tables. This will only work if your schema closely matches that of the ASPNET implementation.

3. Write your own providers that target the old database and schema. Take a look here as a starting point with links to other interesting articles: http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=380

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Thank you for the post. In my searches since found the following article from Microsoft to be very helpful.

http://support.microsoft.com/?id=910440