執行 Migration Script 9 來測試 Project Server 2007 資料是否有已知的移轉問題
適用版本： Project Server 2010
上次修改主題的時間： 2013-12-18
執行 Script 9 會針對 Microsoft Office Project Server 2007 資料庫執行資料驗證檢查，以尋找是否會造成升級 Microsoft Project Server 2010 失敗的已知條件。Script 9 會檢查下列條件：
Office Project Server 2007 已升級至 Service Pack 2 與 October 2009 累計更新
自從安裝 Office Project Server 2007 Service Pack 2 與 2009 年 10 月份累計更新後，便未儲存和發佈專案。
使用 Project Server 2010 所保留之名稱的查閱資料表
Project Server 2010 所保留的自訂欄位名稱
在 Office Project Server 2007 中的 Office Web 元件 (OWC) 檢視，需要移轉至 Excel Services，以便在 Project Server 2010 中使用。
具有使用表單驗證登入名稱的使用者帳戶
沒有關聯查閱表格或值的團隊名稱
可能需要移轉至 Office Project Server 2007 的 Project Server 2003 中之 Office Project Web Access 公事包分析器 OWC 檢視
注意
此指令碼是 Project Server 虛擬移轉環境 (VME) 中所包含的多個移轉後指令碼其中之一。執行指令碼是選擇性的，但強烈建議使用它來協助偵測可能會導致資料無法成功移轉的問題。如需可用之移轉後指令碼的詳細資訊，請參閱＜Project Server VME：執行移轉後指令碼 (選擇性)＞。
執行 Script 9
在 VME 桌面上，按一下 [啟動移轉程序]。這會開啟顯示磁碟機 E 內容的 [Windows 檔案總管] 視窗。
在 [Windows 檔案總管] 中，按兩下下列資料夾：
如果您具有一個 Project 2003 資料庫，請開啟 [Migrate_Proj_2003_Single_DB] 資料夾。
如果您具有分割的 Project Server 2003 資料庫，請開啟 [Migrate_Proj_2003_Split_DB]。
開啟 [驗證指令碼] 資料夾，然後按一下 [VME Script 9.sql]。這將會開啟 SQL Server Management Studio 並顯示 Script 9。
按一下 [執行] 以執行指令碼。
將會顯示結果。請嘗試解決任何找到的問題，再將資料移轉至 Project Server 2010。
您可以使用 Microsoft Office Project Professional 2007 (包含在 VME 中) 以嘗試解決在此指令碼中偵測到的一些資料問題。
Script 9
Script 9 包括下列程式碼：
------------------------------------------------------------------------------
/* Pre-Migration Steps from Project 2007 SP2 to Project 2010
VME Script 12
-----------------------------------------------------------------------------*/
------------------------------------------------------------------------------
/* Check Project 2007 Version: Must be SP2 + October CU = ??
-----------------------------------------------------------------------------*/
USE ProjectServer_Draft
select Version
as 'Project Server 2007 SP2 + Oct09CU Version Must Be 12.0.6520.5000 or Higher. If not, upgrade to SP2 + Oct2009 CU'
, timestamp
from dbo.Versions
go
----------------------------------------------------------------------------------------------
/* Display the projects not saved or published since the installation of SP2 + December 09 CU?
----------------------------------------------------------------------------------------------*/
select Distinct PROJ_NAME AS 'List of Projects Not Saved and Published Since the Installation of Service Pack2'
,PROJ_PROP_AUTHOR, PROJ_LAST_SAVED, WPROJ_LAST_PUB
from dbo.MSP_PROJECTS
where PROJ_TYPE = 0
and ((dbo.MSP_PROJECTS.PROJ_LAST_SAVED < (SELECT MAX(TimeStamp) FROM dbo.Versions))
OR (dbo.MSP_PROJECTS.WPROJ_LAST_PUB < (SELECT MAX(TimeStamp) FROM dbo.Versions)))
GROUP BY PROJ_NAME,PROJ_PROP_AUTHOR, PROJ_LAST_SAVED, WPROJ_LAST_PUB
Order by PROJ_NAME
go
------------------------------------------------------------------------------
/* Display the Lookup tables using reserved names in 2010
This query is to be run against the Published database of Project Server 2007
-----------------------------------------------------------------------------*/
USE ProjectServer_Published
select LT_NAME
AS 'List of Lookup Table names with Reserved Names. These names must be changed before proceeding with the Upgrade'
from dbo.MSP_LOOKUP_TABLES
WHERE LT_NAME IN
('Department',
'Project Impact',
'Relative Importance',
'Sample Areas Impacted',
'Sample Primary Objective')
-- Cost Type, Health, RBS and State are standard in 2007
go
------------------------------------------------------------------------------
/* Display the Custom Fields using reserved names in 2010
This query is to be run against the Published database of Project Server 2007
-----------------------------------------------------------------------------*/
USE ProjectServer_Published
select MD_PROP_NAME
AS 'List of Custom Fields names with Reserved Names. These names must be changed before proceeding with the Upgrade'
from dbo.MSP_CUSTOM_FIELDS
WHERE MD_PROP_NAME IN
('Flag Status',
'Project Departments',
'Project Impact',
'Relative Importance',
'Resource Departments',
'Sample Approved Finish Date',
'Sample Approved Start Date',
'Sample Areas Impacted',
'Sample Assumptions',
'Sample Business Need',
'Sample Compliance Proposal',
'Sample Goals',
'Sample Post Implementation Review Date',
'Sample Post Implementation Review Notes',
'Sample Primary Objectives',
'Sample Proposal Cost',
'Sample Proposed Finish Date',
'Sample Proposed Start Date')
go
---------------------------------------------------------------------------------------------------------
/* Displays Existing OWC Views in 2007 that need to be migrated to Excel Services in Project Server 2010
--------------------------------------------------------------------------------------------------------*/
select WVIEW_NAME AS 'List of PWA Data Analysis OWC Views to Migrate to Excel Services in Project Server 2010'
FROM dbo.MSP_WEB_VIEW_REPORTS
WHERE WVIEW_OWC_PIVOT_XML is not null
OR WVIEW_OWC_CHART_XML is not null
------------------------------------------------------------------------------
/* Displays User Accounts with Forms Auth Login Names > 249 Ch. -- on 2007
-----------------------------------------------------------------------------*/
select RES_NAME AS 'List of FBA accounts with Names > 249 Ch. Shorten the Resource Names below'
FROM dbo.MSP_RESOURCES
WHERE RES_IS_WINDOWS_USER = 0
AND (Select LEN(RES_NAME)) > 249
go
------------------------------------------------------------------------------
/* Display Team Names with no Lookup Tables and a Value -- on 2007
-----------------------------------------------------------------------------*/
select TEXT_VALUE AS 'List of Team Names with values and NO Lookup Tables. Create a LT for these Teams'
FROM dbo.MSP_RES_CUSTOM_FIELD_VALUES, dbo.MSP_CUSTOM_FIELDS, dbo.MSP_LOOKUP_TABLES
WHERE dbo.MSP_RES_CUSTOM_FIELD_VALUES.CUSTOM_FIELD_UID = dbo.MSP_CUSTOM_FIELDS.MD_PROP_UID
AND MD_PROP_NAME = 'Team Name'
AND dbo.MSP_CUSTOM_FIELDS. MD_LOOKUP_TABLE_UID IS NULL
go
------------------------------------------------------------------------------------------------------------------
/* Displays Existing PWA Portfolio Analyzer OWC Views in 2003 that may need to be migrated to Project Server 2007
-----------------------------------------------------------------------------------------------------------------*/
USE Project2003SourceDB
select WVIEW_NAME AS 'List of PWA Portfolio Analyzer OWC Views to Migrate to Project Server 2007'
FROM dbo.MSP_WEB_VIEW_REPORTS
WHERE WVIEW_OWC_PIVOT_XML is not null
OR WVIEW_OWC_CHART_XML is not null