Monday, November 8, 2010

Migration by the numbers – Step 9

Step 9 in a series of posts documenting the Microsoft SharePoint Foundation 2010 upgrade process on SBS 2008. This is based on the document:

 

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2dc66a0f-f840-4b29-93d3-13db70c85cba&;;displayLang=en

 

Previous steps:

 

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

 

Step 9 - Detach the Windows SharePoint Services 3.0 database from Windows Internal Database

You will need to have the SQLCMD utility installed on your server before you can complete these steps. This can be downloaded directly for SBS 2008 (x64) via:

 

http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/SQLServer2005_SQLCMD_x64.msi

(*Authors note. I think it would be better to install the SQL Management Studio Express to complete this step as you need it for the next step anyway and other maintenance in general. Although the SQLCMD utility is handy to have I don’t see it being necessary).

image_2_788D9761

 

Click Start in the Search box type CMD.

 

Under Programs right mouse click on CMD and select the option Run as administrator from the menu that appears.

 

image_4_788D9761

 

At the command prompt type the following commands all followed by the ENTER key:

 

sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
use master
alter database ShareWebDb set single_user with rollback immediate
go
sp_detach_db ‘ShareWebDb’
go

 

The WSS v3 content database is now removed from being connected to SQL Embedded Edition 2005. The next step will attach it to the SQL Server 2008 Express.