Can Office Project 2003 Server be migrated from SQL 2000 to SQL 20

[Michael]

I am looking to move from SQL 2000 to 2005 and can't find a lot of info on
forums if this is possible. Can someone direct me to some docs on how to
migrate (if at it is possible). Thanks.

 

[Andre Venter]

Michael,

Hi there, this is possible. Your SQL 2000 istallation must be on the latest
Service Pack, or at least SP3 before migrating.

Not sure if an "In Place" install is possible. But install SQL 2005 on the
new Server restore the Db's on the Said server and re-create the PWA Site.

Please bear in mind that this should first be done on a "test" environment
before attempting to do it live.

--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member

 

[Gerard Wojcik]

Michael - The following MSFT KB articles may be helpful -

Moving Windows SharePoint Services Databases
http://technet.microsoft.com/en-us/library/cc723225.aspx

How to move the databases that are used by Windows SharePoint Services and
by Project Server 2003 to a computer that is running SQL Server
http://support.microsoft.com/kb/905386

 

[Michael]

Thank you for your help, I will give it a go.

Michael,

Hi there, this is possible. Your SQL 2000 istallation must be on the latest
Service Pack, or at least SP3 before migrating.

Not sure if an "In Place" install is possible. But install SQL 2005 on the
new Server restore the Db's on the Said server and re-create the PWA Site.

Please bear in mind that this should first be done on a "test" environment
before attempting to do it live.

--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member

 

[Michael]

Thank you for your help.

Michael - The following MSFT KB articles may be helpful -

Moving Windows SharePoint Services Databases
http://technet.microsoft.com/en-us/library/cc723225.aspx

How to move the databases that are used by Windows SharePoint Services and
by Project Server 2003 to a computer that is running SQL Server
http://support.microsoft.com/kb/905386