Capture the Windows SharePoint Services 2.0 workspaces linked to projects

 

Applies to: Project Server 2010

Topic Last Modified: 2010-12-15

Important

This procedure is optional and only needs to be performed if you want to migrate your Windows SharePoint Services 2.0 project workspace sites and content.

Script A4 takes a data snapshot of the Microsoft Office Project Server 2003 database from the Projects table and then stores the data in a table created dynamically within the script. Script A4 lists all projects in the Project Server 2003 database that have an associated project workspace site.

Run Script A4 after updating the two USE statements to point to the validation database created above and the database name of the Microsoft Office Project Server 2003 database that you plan to migrate.

Script A4

/*------------------------------------------------------------
-- Script A4: Capture WSS2 Project Workspaces Data Snapshot
-- Project2003_Projects_With_WSS_Sites.sql
-- List all Projects with Associated WSS workspace sites
------------------------------------------------------------------*/
USE ProjectServer_Migration_Data_Validation
IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'Migration_PS2003_ProjectWorkspaces')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE dbo.Migration_PS2003_ProjectWorkspaces
GO
USE ProjectServer_2003

SELECT [PROJ_NAME]
,[WPROJ_ID]
      ,[WPROJ_STS_SUBWEB_NAME]
      ,[WPROJ_ISSUE_LIST_NAME]
      ,[WPROJ_RISK_LIST_NAME]
      INTO ProjectServer_Migration_Data_Validation.dbo.Migration_PS2003_ProjectWorkspaces
   FROM [MSP_WEB_PROJECTS] P, dbo.MSP_WEB_STS_SERVERS W
  where [WPROJ_STS_SUBWEB_NAME] IS NOT NULL
  and p.[WSTS_SERVER_ID] = w.[WSTS_SERVER_ID]