Friday, August 17, 2007

Content Database Migration from SharePoint 2003 to 2007

This guide is aimed for a migrating a server farm with little customization.
I wrote it about two month ago as I was performing my migration. Enjoy...
1-Run Pre upgrade scan tool on WSS v2.0 or SPS 2003 farm
At the command prompt, perform one of the following actions, as appropriate for your situation:
If you are upgrading from SharePoint Portal Server 2003 to SharePoint Server 2007, type the following command at the command prompt
prescan.exe /c preupgradescanconfig.xml /all

If you are upgrading from Windows SharePoint Services 2.0 to Windows SharePoint Services 3.0, type the following command at the command prompt:
prescan.exe /all
Get any errors fixed in this stage before you move on.
You can check http://www.mycodekb.com/ for some of the errors I ran into and corrected.
Other useful slinks to troubleshoot your errors:
http://support.microsoft.com/kb/937291
Make sure you run this right before you perform the next steps.

2- Stand up and configure your new v 3.0 farm, Make sure all necessary services are started.

3-Create an IIS Website for each Web site in your in your v2 environment.
Increase ASP Script Timeout to 6000.modify the web.cofig file in the web application
Increase ASP।net execution Timeout
4- Copy all customization such as custom web parts and site definitions from your old farm to your all the WFE s on your new farm.

5- Set you WSS v 2 databses to Read Only.
Back up and restore, attach or copy the your content datasbes to the new server farm SQL Sever.
Before attaching datasbase in next step go and delete any triggers you may have created on the database, in my case I had created a trigger to limit versions on SPS 2003,, I really recommend cleaning here.
6-Attach the WSS v2 content database to your new Website using either SharePoint 3.0 Central Administration or
Stsadm tool see example below
stsadm -o deletecontentdb -url http://websitev3 -databaseserver DBSERVER-databasename WSS_Contentv3
stsadm -o addcontentdb -url http:// websitev3 -databaseserver DBSERVER -databasename CONTENTDBv2
This is going to take a while, go take a long break and hope for the best

0 comments: