Migrating Forms Based Authentication Sites from SharePoint 2007 to SharePoint 2010

Migrating Forms Based authentication sites from SharePoint 2007 to SharePoint 2010 using database attach method applies the general principles of database attach upgrade method; however, it includes some additional steps to cater for membership & roles providers.

The steps for this migration are as follows:

  1. Move the SharePoint 2007 membership provider database to the new database server using database ackup/restore. (Note to give the users of the application pool accounts access to the databases if you are using Windows Integrated Authentication to connect to SQL)
  2. Build new SharePoint web application with Claims Based Authentication   
    1. Setup the membership & role providers in the config file as per the membership provider database restored in step 1.
  3. Setup the membership & role providers’ in the central Administration and STS configuration files to point to the database restored in step 1. 
  4. Run Test-SPContentDatabase -Name <DatabaseName> -WebApplication <URL> to verify any additional needed solutions
  5. Check solutions and deploy Needed Solutions 
  6. Attach the content database of the FBA site
  7. Check if the FBA site is working fine and as expected

Comments (2)

  1. Umar says:

    Nice article. Thanks for posting exactly what I was looking for. Just want to ask you that you are creating a new web app in step 2. After that which data base you are attaching to FBA site in step 6. When and where will you tell new web app in 2010 to use aspnetdata base that contains all the users’ lists.


  2. Mohamed El Ashmawi says:

    I am telling the web applicaiton of the membership database (aspnet database) in steps 2 and 3 above. i.e. I am configuring the web application, central administration and STS to retrieve users from the membership database.

    As for the database in steps 4 & 6, this is a the actual content database with all the FBA site content. It should be taken as the SharePoint 2007 content database.

    I hope this helps you. Please send me back for any additonal clarifications

Skip to main content