Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 12th, 2006, 11:07 AM
Registered User
Join Date: Apr 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Migrate user data to new membership model

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

Old May 13th, 2006, 05:48 AM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

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 Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Old May 24th, 2006, 09:44 AM
Registered User
Join Date: Apr 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Membership / User question rsearing ASP.NET 3.5 Professionals 29 February 21st, 2009 12:45 PM
confusing in ADO.NET Entity Data Model,Linq to sql angelboy ADO.NET 5 November 21st, 2008 05:01 PM
Dim user As MembershipUser = Membership.GetUser(us sstuber BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 May 8th, 2008 03:42 PM
Membership User kulkarnimonica ASP.NET 2.0 Professional 2 July 12th, 2007 04:55 PM
problem with creating membership user hertendreef ASP.NET 2.0 Basics 1 April 9th, 2007 02:37 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.