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


by Jason Fortner - Date: 2006-12-04 - Word Count: 432 Share This!

I was searching for some information on the strategy on how to move just an individual site from Sharepoint 2003/WSS V2.0 to Sharepoint 2007/WSS V3.0. I found a lot of information on how to do an In-Place and Gradual upgrade but nothing on how to just move a single site. This article is written based on moving a single site from a single server instance of Sharepoint 2003/WSS V2.0 to a single server installation of Sharepoint 2007/WSS V3.0. If your environment is different some of the steps below will need to be modified for your purposes. Below are the steps on how to move just a single Sharepoint 2003/WSS V2.0 site to Sharepoint 2007/WSS V3.0:

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.

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 Program FilesCommon FilesMicrosoft Sharedweb server extensions12BIN.

On the server running Sharepoint 2003 open a command prompt and navigate to the directory that you copied the Prescan tool to.

On the command prompt run the Prescan tool with the following command: prescan /V
NOTE: if you use the /ALL option this will run the prescan on your entire farm.

Once the prescan has completed make a backup of the content database for the virtual server we just ran the prescan on.

Copy the database backup to the server running Sharepoint 2007

Restore the database backup onto the SQL server that Sharepoint 2007 is using.

Open the Sharepoint 3.0 Central Administration site. This can be located at

Start->Administrative Tools->Sharepoint 3.0 Central Administration.

Click on the Application Management tab at the top of the screen

Go to "Create or extend Web Application" under the "Sharepoint Web Application Management" section.

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.

Fill in the appropriate information to create a Sharepoint 2007/WSS V3.0 Web Application in your environment and click "OK"

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".

Open a command prompt.

Run the Sharepoint stsadm tool with the following command line:

stsadm -o addcontentdb -url -databasename


Related Tags: sharepoint 2007, windows sharepoint services v3.0, wss, sharepoint, migration

Jason Fortner is co-founder of Total Productivity Solutions. Total Productivity Solutions is an Atlanta based company that provides custom SharePoint, webpart and .NET development; and solutions to common software development issues are also provided on the site.

Sharepoint sites, Sharepoint webparts and .NET Development

www.totalproductivitysolutions.com

www.totalproductivitysolutions.com/ProgrammingTips/Sharepoint2007_Database_Migrate_Single_Site.aspx

Your Article Search Directory : Find in Articles

© The article above is copyrighted by it's author. You're allowed to distribute this work according to the Creative Commons Attribution-NoDerivs license.
 

Recent articles in this category:



Most viewed articles in this category: