共用方式為

  • 發行項

執行 Migration Script 5 來擷取移轉後的 Project Server 2007 資料快照

 

適用版本： Project Server 2010

上次修改主題的時間： 2013-12-18

執行 Migration Script 5 會為包含您要移轉之 Microsoft Office Project Server 2003 資料的 Microsoft Office Project Server 2007 資料庫建立資料快照。指令碼會建立「專案」和「任務」資料表的資料快照，然後將此資訊儲存在此指令碼動態建立的資料表中。這個指令碼所儲存的結果，可稍後和 Project Server 2003 資料所建立之移轉前快照的結果進行比較，以驗證所有的資料是否已成功移轉。

警告

此指令碼是 Project Server 虛擬移轉環境 (VME) 中所包含的多個移轉後指令碼其中之一。執行指令碼是選擇性的，但強烈建議使用它來協助偵測可能會導致資料無法成功移轉的問題。如需可用之移轉後指令碼的詳細資訊，請參閱＜Project Server VME：執行移轉後指令碼 (選擇性)＞。

執行 Script 5

  1. 在 VME 桌面上，按一下 [啟動移轉程序]。這會開啟顯示磁碟機 E 內容的 [Windows 檔案總管] 視窗。

  2. 在 [Windows 檔案總管] 中，按兩下下列資料夾：

    • 如果您具有一個 Project 2003 資料庫，請開啟 [Migrate_Proj_2003_Single_DB] 資料夾。

    • 如果您具有分割的 Project Server 2003 資料庫，請開啟 [Migrate_Proj_2003_Split_DB]。

  3. 開啟 [驗證指令碼] 資料夾，然後按一下 [VME Script 5.sql]。這將會開啟 SQL Server Management Studio 並顯示 Script 5。

  4. 按一下 [執行] 以執行指令碼。

  5. 指令碼所產生的結果會儲存至 ProjectServer_Migration_Data_Validation 資料庫的 dbo.Migration_PS2007_Data_Validation_Snapshot 資料表中。

Script 5

Script 5 包含下列程式碼：

/*---------------------------------------------------------------------------------------
-- Script A5: Capture Data Validation Snapshot for Project Server 2007 after migration---- Updated Jan 10,2010
-- This script:
-- 1. drops the PS2007 Validation Snapshot table if it exists from the Migration Validation 
      Database previously created
   2. Reads the Project Server 2007 SP2 Draft database to extract Projects and Tasks information
   3. Stores the output dataset into a new table created in the Migration Validation 
      Database
   This script requires to set the database names of the Migration Validation Database and the 
   Project Server 2007 database in the USE statements 
 ----------------------------------------------------------------------------------------------*/

USE ProjectServer_Migration_Data_Validation
IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'MIgration_PS2007_Data_Validation_Snapshot')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE dbo.MIgration_PS2007_Data_Validation_Snapshot
GO
USE [ProjectServer_Draft]
GO
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
SELECT p12p.proj_name as N'Project Name',
   p12p.proj_uid as 'Project UID',
   p12p.proj_info_start_date as N'Proj Start Date',
   p12p.proj_info_finish_date as N'Proj Finish Date',
   p12p.proj_info_status_date as N'Proj Status Date',
   p12p.CAL_UID as N'Proj Calendar UID',
   p12t.task_name as N'Task Name',
   p12t.TASK_ID AS N'Task ID',
       p12t.task_type as N'Task Type',
       p12t.task_start_date as N'Task Start Date',
       p12t.task_finish_date as N'Task Finish Date',
p12t.task_act_start as N'Task Act Start',
p12t.task_act_finish as N'Task Act Finish',
p12t.task_constraint_date as N'Task Constraint Date',
p12t.task_deadline as N'Task Deadline',
p12t.task_work as N'Task Work',
p12t.task_act_work as N'Task Actual Work',
p12t.task_rem_work as N'Task Rem Work',
p12t.task_ovt_work as N'Task Ovt Work',
p12t.task_act_ovt_work as N'Task Actual Ovt Work',
p12t.task_rem_ovt_work as N'Task Rem Ovt Work',
p12t.task_pct_comp as N'Task %Complete',
p12t.task_pct_work_comp as N'Task % Work Complete',
p12t.task_phy_pct_comp as N'Task % Phys Work Complete',
p12t.task_dur as N'Task Duration',
p12t.task_rem_dur as N'Task Rem Duration',
p12t.task_act_dur as N'Task Actual Duration',
p12t.task_is_milestone as N'Task Milestone',
p12t.task_cost as N'Task Cost',
p12t.task_fixed_cost as N'Task Fixed Cost',
p12t.task_act_cost as N'Task Actual Cost',
p12t.task_rem_cost as N'Task Rem Cost',
p12t.task_ovt_cost as N'Task Ovt Cost',
p12t.task_act_ovt_cost as N'Task Actual Ovt Cost',
p12t.task_rem_ovt_cost as N'Task Rem Ovt Cost'
INTO ProjectServer_Migration_Data_Validation.dbo.MIgration_PS2007_Data_Validation_Snapshot
FROM dbo.msp_projects AS p12p,
dbo.msp_tasks AS p12t
WHERE (p12p.proj_uid = p12t.proj_uid)
  
ORDER BY 1,4 
/*---------------------------------------------------------------------------------------
-- Script A5: Capture Data Validation Snapshot for Project Server 2007 after migration---- Updated Jan 10,2010
-- This script:
-- 1. drops the PS2007 Validation Snapshot table if it exists from the Migration Validation 
      Database previously created
   2. Reads the Project Server 2007 SP2 Draft database to extract Projects and Tasks information
   3. Stores the output dataset into a new table created in the Migration Validation 
      Database
   This script requires to set the database names of the Migration Validation Database and the 
   Project Server 2007 database in the USE statements 
 ----------------------------------------------------------------------------------------------*/

USE ProjectServer_Migration_Data_Validation
IF EXISTS (SELECT id FROM dbo.sysobjects WHERE id = OBJECT_ID(N'MIgration_PS2007_Data_Validation_Snapshot')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE dbo.MIgration_PS2007_Data_Validation_Snapshot
GO
USE [ProjectServer_Draft_Migrated]
GO
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
SELECT p12p.proj_name as N'Project Name',
   p12p.proj_uid as 'Project UID',
   p12p.proj_info_start_date as N'Proj Start Date',
   p12p.proj_info_finish_date as N'Proj Finish Date',
   p12p.proj_info_status_date as N'Proj Status Date',
   p12p.CAL_UID as N'Proj Calendar UID',
   p12t.task_name as N'Task Name',
   p12t.TASK_ID AS N'Task ID',
       p12t.task_type as N'Task Type',
       p12t.task_start_date as N'Task Start Date',
       p12t.task_finish_date as N'Task Finish Date',
p12t.task_act_start as N'Task Act Start',
p12t.task_act_finish as N'Task Act Finish',
p12t.task_constraint_date as N'Task Constraint Date',
p12t.task_deadline as N'Task Deadline',
p12t.task_work as N'Task Work',
p12t.task_act_work as N'Task Actual Work',
p12t.task_rem_work as N'Task Rem Work',
p12t.task_ovt_work as N'Task Ovt Work',
p12t.task_act_ovt_work as N'Task Actual Ovt Work',
p12t.task_rem_ovt_work as N'Task Rem Ovt Work',
p12t.task_pct_comp as N'Task %Complete',
p12t.task_pct_work_comp as N'Task % Work Complete',
p12t.task_phy_pct_comp as N'Task % Phys Work Complete',
p12t.task_dur as N'Task Duration',
p12t.task_rem_dur as N'Task Rem Duration',
p12t.task_act_dur as N'Task Actual Duration',
p12t.task_is_milestone as N'Task Milestone',
p12t.task_cost as N'Task Cost',
p12t.task_fixed_cost as N'Task Fixed Cost',
p12t.task_act_cost as N'Task Actual Cost',
p12t.task_rem_cost as N'Task Rem Cost',
p12t.task_ovt_cost as N'Task Ovt Cost',
p12t.task_act_ovt_cost as N'Task Actual Ovt Cost',
p12t.task_rem_ovt_cost as N'Task Rem Ovt Cost'
INTO ProjectServer_Migration_Data_Validation.dbo.MIgration_PS2007_Data_Validation_Snapshot
FROM dbo.msp_projects AS p12p,
dbo.msp_tasks AS p12t
WHERE (p12p.proj_uid = p12t.proj_uid)
  
ORDER BY 1,4