In the Chapter 24 of the Microsoft Office Sharepoint Server 2007 Administrator's Companion, I detailed how to use the STSADM command to upgrade a number of site collections using the Gradual upgrade approach. This was based on knowledge that was available during the beta. With RTM code, the process is as follows:
Note: Ensure that the root site collection is upgraded before any other site collection in the Web Application. If multiple site collections are upgraded at one time, the root site collection must be included in the first set of site collections selected to be upgraded.
- Open a command prompt and navigate to the 12 hive (C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN)
- Type the following command:
Stsadm –o enumsites –url http://portal –redirectedsites > c:\sites.xml
where http://portal is the name of you web site.
Note: Only site collections from one content database can be upgraded at one time, therefore the sites.xml file will need to be modified. In the example below, we need to either remove the two site collections in the protal1_Site_pair content database or the site collection http://portal/sites/obe, which resides in the OBE_DB_Pair content database, so that site collections in one content database remain.
- Open sites.xml in notepad. It should contain text similar to the following:
Note: The “Count” and as all site collections should be in the same content database the “TargetDatabase” attributes are not necessary for upgrading the content databases, but can remain in the xml file, because they will be ignored by the upgrade process.
- Amend the xml file so that only those site collections you wish to upgrade are present and then save and close sites.xml.
- In the command prompt type:
stsadm –o upgrade -sidebyside -sitelistpath c:\sites.xml
The SharePoint Setup dialog box is displayed, and may remain displayed for some time.
