Sharepoint 2003 Migration to MOSS 2007 using Database upgrade method

Sharepoint 2003 Migration to MOSS 2007 using Database upgrade method

1.    Make sure your existing SharePoint Portal Server 2003 is running Service Pack 3

o    http://www.microsoft.com/downloads/details.aspx?familyid=2bbfc89b-eb59-49ff-b58f-684693cb25a7&displaylang=en&tm

2.    Download PreScan.exe on your existing SharePoint Portal Server 2003 installation.

o    http://www.microsoft.com/downloads/details.aspx?familyid=B922B28D-806A-427B-A4C5-AB0F1AA0F7F9&displaylang=en

o    Download both prescan.exe and PREUPGRADESCANCONFIG.xml

3.    Run PreScan.exe on your existing SharePoint Portal Server 2003 installation.

o    prescan.exe /c preupgradescanconfig.xml /all

4.    Review the prescan log on your existing SharePoint Portal Server 2003 installation.

o    C:Documents and Settings<user account>Local SettingsTemp1

5.    Open SQL Manager and change the content database to read only.

6.    Take a back up of the content database

7.    Restore back up to the SQL Server used by your new MOSS 2007 Installation.

8.    Create web application with no site collection in your MOSS 2007 Installation.

o    When creating the web application you will need to create a dummy database which you will remove later

9.    Remove content database of the newly created web application in SQL Server

10. Attach restore database with the newly created web application in MOSS 2007.

o    C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions12BIN>

o    stsadm.exe -o addcontentdb -url http://xx.xx -databasename Sharepoint_xx_DB

Now test to see what doesn’t work 🙂