• Article

Run Migration Script 6 to capture all Project Server 2007 projects with associated project workspaces

 

Applies to: Project Server 2010

Topic Last Modified: 2010-05-17

Run Script 6 to list all projects in the Microsoft Office Project Server 2007 Published database that have an associated project workspace site. This data is saved to a table in the ProjectServer_Migration_Data_Validation database. The data can be compared to pre-migration results from Script 4 to check whether all Microsoft Office Project Server 2003 projects with associated workspaces have been migrated and relinked.

Note

This script is one of several post-migration scripts included in the Project Server virtual migration environment (VME). Running the scripts is optional, but highly recommended for helping to detect issues that may prevent a successful migration of your data. For more information about the post-migration scripts that are available, see Project Server VME: Run post-migration scripts (optional).

To run Script 6

  1. On the VME desktop, click Start Migration Process. This opens a Windows Explorer window that displays the contents of drive E.

  2. In Windows Explorer, double-click the following folder:

    • If you have one Project 2003 database, open the Migrate_Proj_2003_Single_DB folder.

    • If you have split Project Server 2003 databases, open Migrate_Proj_2003_Split_DB.

  3. Open the Verification Scripts folder, and then click VME Script 6.sql. This opens SQL Server Management Studio and displays Script 6.

  4. Click Execute to run the script.

  5. The results from the script are saved to the ProjectServer_Migration_Data_Validation database in the table named dbo.Migration_PS2007_ProjectWorkspaces.

Script 6

/*------------------------------------------------------------
-- Script A6
-- Project2007_Projects_With_WSS_Sites.sql
-- List all Projects with Associated WSS workspace sites
Run this query against the Project Server 2007 Published database
--------------------------------------------------------------*/
USE ProjectServer_Migration_Data_Validation
IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'Migration_PS2007_ProjectWorkspaces')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE dbo.Migration_PS2007_ProjectWorkspaces
go
USE ProjectServer_Published
SELECT [PROJ_NAME]
,[PROJ_UID]
      ,[WPROJ_STS_SUBWEB_NAME]
      ,[WPROJ_ISSUE_LIST_NAME]
      ,[WPROJ_RISK_LIST_NAME]
      INTO ProjectServer_Migration_Data_Validation.dbo.Migration_PS2007_ProjectWorkspaces
       FROM [MSP_PROJECTS] P
where [WPROJ_STS_SUBWEB_NAME] IS NOT NULL
order by proj_name