This is Part 4 in a series of migrating SharePoint from SBS 2003 to SBS 2011. Series posts are:
Introduction – Overview
Part 1 – Caveats and Considerations
Part 2 – Preparation steps on v2
Part 3 – Upgrading v2 database to WSS v3
Part 4 – Attaching upgraded database to WSS v3
Part 5 – Check WSSv3 for migration to Foundation 2010
Part 6 – Move database to SBS 2011
Part 7 – Post migration steps and considerations
In this part we are going to attach the migrated databases we attached to SQL to our staging Windows SharePoint Services v3 (WSS v3).
Adding database to WSS v3
Once the old SharePoint v2 databases have been attached to SQL Server the next step is to connect these databases to WSS v3.
Open a DOS prompt on the WSS v3 server via Start | Run | Cmd. Change directory to c:\program files\common files\Microsoft shared\web server extensions\12\bin and execute the following command to remove the existing WSS v3 database.
stsadm –o deletecontentdb –url http://<new WSS v3 site> -databaseserver <SQL_SERVER_NAME> -databasename <OLD WSS v3 DATABASE>
stsadm –o deletecontentdb –url http://sharepoint3 -databaseserver VMSBS2003P -databasename WSS_CONTENT
Note, that if you are using the SQL Server 2005 Embedded Edition (SSEE##) that installs with the default standalone installation of WSS v3 you do not need to specify the database server. That is, you should leave out the option –databaseserver <SQL_SERVER_NAME>
Where http://sharepoint3 is the new WSS v3 created during installation of WSS v3, VMSBS2003P is the name of the WSS v3 Windows Server and WSS_CONTENT is the default name of the WSS v3 content database created during installation of WSS v3. If you have made changes from the default during the installation some of these vales will be different for you.
It is important to remember that this process will remove all the existing content from the WSS v3 site.
You now need to add the migrated SharePoint v2 databases that you have previously attached to SQL Server to the new WSS v3 site. The addcontentdb process will allow you to do this and automatically upgrade your SharePoint v2 data into WSS v3. Execute the following command to add the existing old SharePoint database to the new WSS v3 site.
stsadm –o addcontentdb –url http://<new WSS v3 site> -databaseserver <SQL_SERVER_NAME> -databasename <Old Sharepoint v2 database>
stsadm –o addcontentdb –url http://sharepoint3 -databaseserver VMSBS2003P -databasename STS_VMSBS2003p_1
Note, that if you are using the Microsoft SQL Server 2005 Embedded Edition (SSEE##) that installs with the default standalone installation of WSS v3 you do not need to specify the database server. That is you should leave out the option –databaseserver <SQL_SERVER_NAME>
The upgrade process will vary on the size of the content databases and speed of your hardware. Eventually, you should receive a message telling you that the process completed successfully.
Once the process is complete, open the default WSS v3 site (typically just the http://server_name) on the WSS v3 staging server and confirm that the data is present and correct. You should see data from from your SBS 2003 Companyweb but now in a WSS v3 format.
In the next part we’ll commence the process to migrate to SharePoint Foundation 2010.