Article ID: 115715, created on Mar 13, 2013, last review on May 11, 2014

  • Applies to:
  • Operations Automation

Additional Information

Since POA 5.5, WSS 2.0 is no longer supported. Before upgrading to POA 5.5, all WSS 2.0 sites must be migrated to SharePoint Foundation 2010. This article describes how to migrate sites from WSS 2.0 to SharePoint Foundation 2010.

Note: The detailed description of the migration from WSS 2.0 to SharePoint Foundation 2010 is provided in the http://technet.microsoft.com/en-au/library/ee947140.aspx article.

Before Migration

[1] Deploy a temporary WSS 3.0 farm using the instructions provided in the http://technet.microsoft.com/en-us/library/cc287737%28v=office.12%29.aspx article. There are the following deployment requirements:
- The temporary WSS 3.0 farm must be deployed in the AD domain with installed WSS 2.0.
- The temporary WSS 3.0 farm must not be registered in POA.
- The temporary WSS 3.0 farm must contain the same Language Packs and Site Templates as the WSS 2.0 farm contains.

[2] Deploy a new SharePoint Foundation 2010 farm using the instructions provided in the POA Windows Shared Hosting Deployment Guide >> Deploying Windows SharePoint Hosting > Installing Microsoft SharePoint Foundation 2010. There are the following deployment requirements:
- The SharePoint Foundation 2010 farm must be deployed in the AD domain with installed WSS 2.0.
- The SharePoint Foundation 2010 farm must contain the same Language Packs and Site Templates as the WSS 2.0 farm contains.

[3] In PCP, reconfigure WSS 2.0 Resource Types, Service Templates, and Service Plans to switch provisioning from WSS 2.0 to SharePoint Foundation 2010. It will affect all existing WSS 2.0 subscriptions: existing WSS 2.0 sites will continue working; new sites will be provisioned in the SharePoint Foundation 2010 farm.

Migration

Perform the following actions for each WSS 2.0 site:

[1] Obtain and write down the properties of the WSS 2.0 site, which is being migrated. The following properties must be prepared:
- Name of the site administrator
- Storage quota limit and warning limit
- Site language
These properties can be obtained from the POA system database:
select d.domain_id, d.name as domain_name, su.hsu_id as admin_user_id, ss.notify_limit as warn_limit, ss.hard_limit as quota_limit, ss.root_site_lang as lang_id from domains d join subdomain_services sd on sd.zone_id=d.domain_id join iis_addons a on a.addon_id=sd.subds_id join iis_sps_sites ss on ss.sps_site_id=a.sps_site_id join iis_sps_users su on su.sps_site_id=ss.sps_site_id join hs_user_bindings hsu on hsu.user_id=su.hsu_id and su.type=4 where d.domain_id=<DOMAIN_ID>;
Also, these properties can be obtained from CCP.

[2] If the WSS 2.0 site has an exclusive IP address assigned, log in to CCP and switch the WSS 2.0 site to a shared IP address. If it is required, keep the corresponding SSL certificate and private key.

[3] In CCP, create a temporary SharePoint Foundation 2010 site. This site will be used to keep Service Users during the migration. There are the following recommendations and requirements:
- Create this site on a subdomain. The DNS registration of the subdomain is not required.
- This site must be created in an exclusive web application.
- The Service User prepared at the step 1 must be specified as the site administrator.
- If it is required, increase resource limits of the subscription in PCP.
- Make sure all SharePoint Foundation 2010 provisioning tasks are executed.

[4] On the front-end server of the WSS 2.0 farm, switch the WSS 2.0 site to the read-only mode:
- Open the WSS 2.0 SharePoint Central Administration web site.
- Go to Component Configuration > Manage quotas and locks > Manage site collection quotas and locks.
- Specify the URL of the WSS 2.0 site and click View Data.
- In the Site Lock Information area, select Adding content prevented and then press OK.

[5] On the front-end server of the WSS 2.0 farm, create a backup of the content of the WSS 2.0 site (as a precaution). See the http://technet.microsoft.com/en-us/library/cc262811(v=office.12).aspx article for details.
For example, this can be done in the following way:
stsadm -o backup -url <SITE_URL> -filename <FILE_NAME>

[6] On the front-end server of the WSS 2.0 farm, run the pre-upgrade scan tool for the WSS 2.0 site. See the http://technet.microsoft.com/en-us/library/cc287628%28Office.12%29.aspx page for details.

[7] On the database server of the WSS 2.0 farm, create a backup of the Content Database of the WSS 2.0 site. See the http://technet.microsoft.com/en-us/library/cc287634%28Office.12%29.aspx article for details.
The name of the Content Database can be obtained from the POA system database:
select * from iis_sps_app_dbs where sps_app_id = (select sps_app_id from iis_sps_sites  where url = '<DOMAIN_NAME>');

[8] Perform the first upgrade of the Content Database:
- On the database server of the temporary WSS 3.0 farm, restore the Content Database from the backup created at the step 7.
- Add the restored Content Database to a web application of the temporary WSS 3.0 farm.
- Review the upgrade logs.
See the http://technet.microsoft.com/en-au/library/ee947140.aspx article for details.

[9] On the front-end server of the temporary WSS 3.0 farm, run the pre-upgrade checker to validate the upgraded Content Database. See the http://technet.microsoft.com/en-au/library/cc287628.aspx article for detail.

[10] On the database server of the temporary WSS 3.0 farm, create a backup of the upgraded Content Database. See the http://technet.microsoft.com/en-au/library/cc287634.aspx article for details.

[11] In CCP, remove the WSS 2.0 hosting service from the corresponding domain. There are the following requirements and recommendations:
- Do not remove the domain.
- Make sure the Content Database of the WSS 2.0 site is in the read-write mode.
- Make sure all WSS 2.0 tasks are processed.

[12] In CCP, add the SharePoint Foundation 2010 hosting service to the corresponding domain. There are the following requirements and recommendations:
- Use the values prepared at the step 1.
- This SharePoint Foundation 2010 site must be created in an exclusive web application.
- Make sure all SharePoint Foundation 2010 tasks are processed.

[13] On the front-end server of the SharePoint Foundation 2010 farm, switch the just created SharePoint Foundation 2010 site to the read-only mode. For example, this can be done in the following way:
stsadm -o setsitelock -url <SITE_URL> -lock readonly

[14] On the database server of the SharePoint Foundation 2010 farm, create a backup of the Content Database of the SharePoint Foundation 2010 site created at the step 12 (as a precaution).

[15] On the front-end server of the SharePoint Foundation 2010 farm, remove the Content Database from the SharePoint Foundation 2010 site. For example, this can be done in the following way:
stsadm.exe -o deletecontentdb -url <SITE_URL> -databasename <CONTENT_DATABASE_NAME>
The name of the Content Database can be obtained from the POA system database:
select * from iis_sps_app_dbs where sps_app_id = (select sps_app_id from iis_sps_sites  where url = '<DOMAIN_NAME>');

[16] Perform the second upgrade of the Content Database:
- On the database server of the SharePoint Foundation 2010 farm, restore the Content Database from the backup created at the step 10 into the Content Database removed at the step 15. During restoring, the first Content Database must overwrite the second Content Database.
- On the front-end server of the SharePoint Foundation 2010 farm, add the just restored Content Database to the SharePoint Foundation 2010 site. For example, this can be done in the following way:
stsadm.exe -o addcontentdb -url <SITE_URL> -databasename <CONTENT_DATABASE_NAME>
- Review the upgrade logs.
See the http://technet.microsoft.com/en-au/library/cc287634.aspx article for details.

[17] If the removed WSS 2.0 site had an exclusive IP address assigned, log in to CCP and switch the SharePoint Foundation 2010 site to an exclusive IP address. See the step 2 for details. Note, it is not guaranted that the same exclusive IP address will be assigned to the site. If it is required, add the corresponding SSL certificate and private key to the SharePoint Foundation 2010 site.

[18] Make sure the SharePoint Foundation 2010 site works.

[19] On the front-end server of the SharePoint Foundation 2010 farm, switch the SharePoint Foundation 2010 site to the read-write mode.  For example, this can be done in the following way:
stsadm -o setsitelock -url <SITE_URL> -lock none

[20] In CCP, remove the temporary SharePoint Foundation 2010 site created at step 3.

[21] In PCP, adjust resource limits of the subscription. See the step 3 for details.

After Migration

[1] Start crawling and indexing to update the SharePoint Foundation 2010 search database for the migrated sites.  This can be done in the following way:
- Open the SharePoint Foundation 2010 Central Administration web site.
- Go to Central Administration > Monitoring > Timer Jobs > Review Job Definitions.
- Start the SharePoint Foundation Search Refresh job.

[2] Uninstall the SharePointServicesSupport (type: other) package from the WSS 2.0 host.

[3] Remove the WSS 2.0 front-end and database hosts from POA, if it is applicable.

[4] Remove the temporary WSS 3.0 farm.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF