WSS 3.0 & Sharepoint 2007 Database Migration Strategy Steps For Migrating A Sharepoint 2003 Site
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 ArticlesRecent articles in this category:
- Take the Wheel - Drive Customers to your Website
So you own a small business and you have made the decision to build a simple website to gain interne - Hosting Geeklog Sites----Leading To a Booming Online Community
The weblogs are increasingly viewed as a cheaper alternative of expensive content management system. -
-
-
-
-
- Joomla Revolution! How This Free Software Is Changing The Web?
Joomla is changing the web, there is no one better sentence to describe what this young FREE SOFTWAR - Spicing Up Your Blog with 3D Animated YouTube Playlists
People have blogs for different purposes, some people maintain a blog purely for commercial reasons, - Free Image Hosting Service
Image hosting is a part of most web hosting services, providing hosting solutions for images instead
Most viewed articles in this category:
- Beyond the Brand
After completing a "Who, What, Where, Why and How" exercise, there are a few more steps to preparing - Build A Better Website
Building a website isn't usually rocket science, but you have to do your homework. Just like buying - SharePoint 2007 New Feature Overview
Sharepoint 2007 is in Beta 2 now and is projected to be released at the beginning of the year but n - How To Install SharePoint 2007 Beta 2
Following are the detailed instructions on how to install SharePoint 2007 Beta 2 on a clean version - How To Accomplish Your Goals With A Web Site
Choosing a small business idea to reach your goals is not easy. You'll need a strong spirit and dete - The Best Web Sites Aren't Free
The best web sites aren't free. While you may be tempted to buy an HTML book and try to put a few we - URL Forwarding and Redirection
Webmasters and common Internet users have a constant need for URL forwarding and redirection. The r - Web Site Development with Ruby on Rails and Other Programs
Web site development is a very big business these days. Almost every company in the world is trying - Self Assessment: How Effective is Your Web Site?
1. Fonts are an important attribute of a Web site. It is essential that fonts are large and c - For Automated Sites - PHP and MySQL are A Perfect Match
You’ve decided to automate your web site. Now what? Here are some ideas to help you choose how