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

I was searching for some information on the strategyrestore our Sharepoint 2003/WSS V2.0 site to.
on how to move just an individual site from Sharepoint12. Fill in the appropriate information to create a
2003/WSS V2.0 to Sharepoint 2007/WSS V3.0. ISharepoint 2007/WSS V3.0 Web Application in your
found a lot of information on how to do an In-Placeenvironment and click "OK"
and Gradual upgrade but nothing on how to just move13. Once the "Operation in Progress" screen has
a single site. This article is written based on moving adisappeared and the create operation is completed
single site from a single server instance of Sharepointyou will be taken to the "Application Created" screen.
2003/WSS V2.0 to a single server installation ofDo not go to "Create Site Collection".
Sharepoint 2007/WSS V3.0. If your environment is14. Open a command prompt.
different some of the steps below will need to be15. Run the Sharepoint stsadm tool with the following
modified for your purposes. Below are the steps oncommand line: stsadm -o addcontentdb -url
how tomove just a single Sharepoint 2003/WSS V2.0-databasename
site to Sharepoint 2007/WSS V3.0:NOTE: We need to use the stsadm command line tool
to add the new content database because the web
1. You will need to run the prescan.exe tool fromapplication may timeout if you use it to add the content
Sharepoint 2007 on the Sharepoint 2003 databasedatabase.
first. Since this will create errors on the 2003 site I16. Click "Enter" and the content database will be
would recommend making a backup of the site andadded to the site.
restoring the backup of the site to run the prescan on.17. Return to the Sharepoint 3.0 Central Administration
Use the stsadm tool in 2003 to make your backup andapplication and click on the "Application Management"
do the restore of the site.tab.
2. When the site has been restored copy the Prescan18. Click on the "Content databases" link under the
tool from the sever running Sharepoint 2007 to the"Sharepoint Web Application Management"
server running Sharepoint 2003. The Prescan tool is19. You will be redirected back to the "Content
located in Program FilesCommon FilesMicrosoftdatabases" screen
Sharedweb server extensions12BIN.20. Make sure that the Web Application you just
3. On the server running Sharepoint 2003 open acreated is selected in the drop-down list of Web
command prompt and navigate to the directory thatApplications.
you copied the Prescan tool to.21. Click on the content database that was initially
4. On the command prompt run the Prescan tool withcreated when you created the web application.
the following command: prescan /V22. On the screen that appears click the check box
NOTE: if you use the /ALL option this will run thenext to "Remove content database".
prescan on your entire farm.23. Click "OK". This will remove the initial database
5. Once the prescan has completed make a backupfrom the SQL Server.
of the content database for the virtual server we just24. Your site is not ready to access. However if you
ran the prescan on.are moving to a machine that has different user
6. Copy the database backup to the server runningaccounts you may have a problem logging into the
Sharepoint 2007new site. If you do follow the rest of the steps in the
7. Restore the database backup onto the SQL serverarticle.
that Sharepoint 2007 is using.25. Go to the "Application Management" tab in the
8. Open the Sharepoint 3.0 Central Administration site.Sharepoint 3.0 Central Administration application.
This can be located at Start->Administrative26. Click on "Site Collection Owners" located under
Tools->Sharepoint 3.0 Central Administration."Sharepoint Site Management"
9. Click on the Application Management tab at the top27. Make sure the correct Web Application is selected
of the screenin the drop-down
10. Go to "Create or extend Web Application" under28. Set the Primary and Secondary site collection
the "Sharepoint Web Application Management" section.owners to the correct user accounts and click "OK"
11. Click on "Create a new Web application" to create29. Your site will now be ready to access with primary
the new Web Application where we are going toor secondary site collection owner account.