WSS 3.0 & Sharepoint 2007 Database Migration Strategy Steps For Migrating A Sharepoint 2003 Site
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
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.Click \"Enter\" and the content database will be added to the site.
Return to the Sharepoint 3.0 Central Administration application and click on the \"Application Management\" tab.
Click on the \"Content databases\" link under the \"Sharepoint Web Application Management\"
You will be redirected back to the \"Content databases\" screen
Make sure that the Web Application you just created is selected in the drop-down list of Web Applications.
Click on the content database that was initially created when you created the web application.
On the screen that appears click the check box next to \"Remove content database\".
Click \"OK\". This will remove the initial database from the SQL Server.
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.
Go to the \"Application Management\" tab in the Sharepoint 3.0 Central Administration application.
Click on \"Site Collection Owners\" located under \"Sharepoint Site Management\"
Make sure the correct Web Application is selected in the drop-down
Set the Primary and Secondary site collection owners to the correct user accounts and click \"OK\"
Your site will now be ready to access with primary or secondary site collection owner account.
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
http://www.totalproductivitysolutions.com
Do You Need a Web Database?
Does My Web Site Require A Web Database?If your web site require constant updates and feeding of information, a web database ...
Will the Cost of Arthritis Care Bankrupt the US Economy?
Arthritis medical costs in the U.S. topped $80 billion in 2003, up from nearly $65 billion in 1997.Researchers from the Unive...
The 2 Most Common Web Site Mistakes
When we review the sites of potential clients, there are 2 mistakes we see over and over. If you are having problems with you...
International Domain Registration
Domain is the name of the website, as in www.websitename.com. Domain registration is the process by which the regulatory body...
Microsoft CRM Migration Moving From One Domain To Another
Microsoft Dynamics CRM is becoming the tool of choice for small, medium and even large businesses across USA and even worldwi...
Brand Strategy - Brand Value - Brand Identity Guru
Developing brand strategy is extremely critical. The most important asset your company has is its brand. Quite simply, for be...
Internet Domain Registration FAQs
Website addresses have two parts, the domain name and the top domain. The domain name refers to the main part, for example, y...
MySQL Database Handling in PHP
Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. F...
Increase Scalability, Performance And Reliability Through Application Development Software Systems
Do you want to launch your own web site or e business portals? Many of the software development company offers web applicatio...
What is Mesothelioma?
Mesothelioma is a type of cancer which is almost always caused by exposure to asbestos. In mesothelioma , malignant type cell...
Targeted Web Site Creation: Things to Consider on Web Site Creation
There are a lot of ways to earn money nowadays, depending on the interest and the needs of the business world. Some find it e...
Day Trading Futures Contracts - How To Win
The successful futures day trader knows that trading is a form of betting. It is a numbers game based on probabilities. The t...
Beginner’s Internet Marketing - Three Steps to Take Before You Design Your First Website
Your first website can be very over whelming but do not despair follow these three easy steps and you will be half way there....
Anonymous Domain Registration
Domain registration is required to maintain a database of website names and their corresponding IP addresses, including the i...
Internet Marketing Web Site-Five Steps to Creating Your Own Web Site
According to Internetworldstats.com, a compiler of market research data, as of January, 2007, there were more than 1 trillion...
Is Day Trading Stock Options A Bad Strategy
Most people will tell you that day trading stock options is extremely risky and shouldnt be attempted by new traders. And th...
4 Steps to Make More Money With Domain Names
You can make more money with domain names. Lucrative domain names can bring you more and more profit. To make more money you...
5 Steps for Excel at Web Site Creation
Targeted webs sire creation is one of the best ways to get directly to your customers. If you write your content with good cl...
Easy Guides to Creating Your Site
Creating a website entails a tremendous amount of a persons creativity and imagination apart from the high requirement in tec...
Best Web Site Creation - Steps to Kick Off Web Site Creation
Creating a web site is really crucial in a business. This web site is the point for all transaction in your business. So as m...