SharePoint 2003 to MOSS 2007 Migration

Senario: You have two servers. One has SharePoint 2003 and other have MOSS 2007 installed. You want to migrate a website collection from SharePoint 2003 to MOSS2007.

Scan the SharePoint 2003 Website
1. PreScan Toolprescan.exe /c preupgradescanconfig.xml /v http://intranet
2. Check the Orphan Recordsstsadm -o databaserepair -url http://intranet -databasename MyIntranet_Site3. Delete the Orphan Recordsstsadm -o databaserepair -url http://intranet -databasename MyIntranet_Site -deletecorruption4. Check the Orphan Recordsstsadm -o databaserepair -url http://intranet -databasename MyIntranet_Site
5. PreScan Toolprescan.exe /c preupgradescanconfig.xml /v http://intranet

Content Database Migration
1. Goto SQL Server and create the website’s content database backup.
2. Copy the database to New Server.
3. Create a new Database on New Server and Restore the database (overwrite).

Create the MOSS 2007 Website
1. Create the WebApplication in MOSS 2007. Don’t create any site collection.
2. Remove the content application databasestsadm.exe -o deletecontentdb -databasename WSS_Content_Intranet_80 -url http://newintranetsite/
3. Attach the new databasestsadm.exe -o addcontentdb -url http://newintranetsitet/ –databasename Portal_Site_Restore

Ref 1: http://farhanfaiz.wordpress.com/2008/05/23/sharepoint-upgrade-database-migration
Ref 2: http://sharemypoint.blogspot.com/2007/04/prescanexe-finished-with-failure.html