WSS 3.0 & Sharepoint 2007 Database Migration Strategy Steps For Migrating A Single Sharepoint 2003 Site

1. You will need to run the prescan.exe tool from Sharepoint 2007 on the Sharepoint 2003 database first. Since this will create errors on the 2003 site I would recommend making a backup of the site and restoring the backup of the site to run the prescan on. Use the stsadm tool in 2003 to make your backup and do the restore of the site.
2. When the site has been restored copy the Prescan tool from the sever running Sharepoint 2007 to the server running Sharepoint 2003. The Prescan tool is located in <system root>\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN.
3. On the server running Sharepoint 2003 open a command prompt and navigate to the directory that you copied the Prescan tool to.
4. On the command prompt run the Prescan tool with the following command: prescan /V <URL to virtual server you are upgrading>
   NOTE: if you use the /ALL option this will run the prescan on your entire farm.
5. Once the prescan has completed make a backup of the content database for the virtual server we just ran the prescan on.
6. Copy the database backup to the server running Sharepoint 2007
7. Restore the database backup onto the SQL server that Sharepoint 2007 is using.
8. Open the Sharepoint 3.0 Central Administration site. This can be located at Start->Administrative Tools->Sharepoint 3.0 Central Administration.
9. Click on the Application Management tab at the top of the screen
10. Go to "Create or extend Web Application" under the "Sharepoint Web Application Management" section.
11. Click on "Create a new Web application" to create the new Web Application where we are going to restore our Sharepoint 2003/WSS V2.0 site to.
12. Fill in the appropriate information to create a Sharepoint 2007/WSS V3.0 Web Application in your environment and click "OK"
13. Once the "Operation in Progress" screen has disappeared and the create operation is completed you will be taken to the "Application Created" screen. Do not go to "Create Site Collection".
14. Open a command prompt
15. Run the Sharepoint stsadm tool with the following command line: stsadm –o addcontentdb –url <url of the site you created> -databasename <name of the database you restored> -databaseserver <name of the database you are restoring to>
    NOTE: We need to use the stsadm command line tool to add the new content database because the web application may timeout if you use it to add the content database.
16. Click "Enter" and the content database will be added to the site.
17. Return to the Sharepoint 3.0 Central Administration application and click on the "Application Management" tab.
18. Click on the "Content databases" link under the "Sharepoint Web Application Management"
19. You will be redirected back to the "Content databases" screen
20. Make sure that the Web Application you just created is selected in the drop-down list of Web Applications.
21. Click on the content database that was initially created when you created the web application.
22. On the screen that appears click the check box next to "Remove content database".
23. Click "OK". This will remove the initial database from the SQL Server.
24. Your site is not ready to access. However if you are moving to a machine that has different user accounts you may have a problem logging into the new site. If you do follow the rest of the steps in the article.
25. Go to the "Application Management" tab in the Sharepoint 3.0 Central Administration application.
26. Click on "Site Collection Owners" located under "Sharepoint Site Management"
27. Make sure the correct Web Application is selected in the drop-down
28. Set the Primary and Secondary site collection owners to the correct user accounts and click "OK"
29. Your site will now be ready to access with primary or secondary site collection owner account.