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
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.