Few days back I was looking for ways to upgrade Project Server 2003 to PS 2007 but there is no step by step guide on how to do that. During the holidays I got a chance to do a test migration and create a step by step guide. I hope this guide will help people do Project Server migration hands on
- Login with domain or local Administrator
- Install Windows Server 2003 Service pack 1 or two
- Click Next
- Click I Agree and click Next
The complete document can be found
Upgrading Project Server 2003 to Project Server 2007
In Case any one has questions please feel free to ask.
Jerry
Jerry Yasir's Blog 
I was really having some problems installing project server 2007 on my machine , when I came across Jerry\’s blog while searching and I must say it was the best every guide I found to installing project server 2007 everything was covered in great detail !! all in al great quality work ! Thanx for the help mate.
Dear Usman,
You are welcome. Hopefully i will add more content that will be useful for guys like you. Have good time.
Jerry
Nice tutorial Jerry. I was looking for such tutorial since Microsoft Launched Microsoft Project Server 2007 as I was having a few issues.
Its really helpfull.
Dear Jerry,
Nice tutorial, but I had small problems at migration Microsof Project Server 2007.
My log file contains the following:
**********Phase:Resource global migration start**********02/04/2008 15:25:54.977 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ? 02/04/2008 15:25:54.977 preparing Query select PROJ_CHECKEDOUT from dbo.MSP_PROJECTS where PROJ_ID = ? 02/04/2008 15:25:54.977 Resource global is not migrated. Starting migration of Resource global02/04/2008 15:25:54.977 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 02/04/2008 15:25:54.977 Executing Query insert into dbo.MSP_P12UPGRADE_PROJECT_UPGRADES (UPG_RUN_UID, UPG_PROJ_P11_ID, UPG_PROJ_UID, UPG_PROJ_P11_NAME, UPG_PROJ_STATUS, UPG_PROJ_TYPE, UPG_PROJ_START_DATE) values (?, 1, ?, ?, 3, ?, GETDATE())02/04/2008 15:25:54.977 preparing Query insert into dbo.MSP_P12UPGRADE_PROJECT_UPGRADES (UPG_RUN_UID, UPG_PROJ_P11_ID, UPG_PROJ_UID, UPG_PROJ_P11_NAME, UPG_PROJ_STATUS, UPG_PROJ_TYPE, UPG_PROJ_START_DATE) values (?, 1, ?, ?, 3, ?, GETDATE()) 02/04/2008 15:25:54.977 Adding existing Project Server 2007 resources to entity map02/04/2008 15:25:54.977 preparing Query exec dbo.MSP_P12UPG_ADD_EXISTING_P12_RESOURCES_TO_ENTITY_MAP 02/04/2008 15:25:54.977 Executing Query exec dbo.MSP_P12UPG_ADD_EXISTING_P12_RESOURCES_TO_ENTITY_MAP02/04/2008 15:25:54.993 Loading Project resglobal02/04/2008 15:25:55.133 02/04/2008 15:25:56.568 Found calendar in both global and local named Стандартный02/04/2008 15:25:56.568 Found calendar in both global and local named Standard02/04/2008 15:25:56.568 Time to execute P12UpgradeDoc::FixupCalendars(): 0 ms02/04/2008 15:25:56.584 02/04/2008 15:25:56.584 Time to execute P12UpgradeDoc::Load(): 1593 ms02/04/2008 15:25:56.584 Loading resource global failed with error 8000400502/04/2008 15:25:56.584 Executing Query update dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 2, UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 102/04/2008 15:25:56.584 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 02/04/2008 15:25:56.584 Resource global migration failed with error 80004005**********Phase:Resource global migration end**********
02/04/2008 15:25:56.584 Time to execute CUpgrader::CheckAndUpgradeResGlobal(): 1609 ms02/04/2008 15:25:56.584 Updating run table02/04/2008 15:25:56.584 preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ? 02/04/2008 15:25:56.584 Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?02/04/2008 15:25:56.584 Migration finished with return code 8000400502/04/2008 15:25:56.584 Project migration failed.
Can help me with this problem?
can anyone send me jerry’s article “Upgrading Project Server 2003 to Project Server 2007”. there is problem in downloading it.