Migrating DB from Project Central to Project Server 2003

[Rene Canlas]

Greetings!

Newbie to Project Server here. I've been asked to migrate a Project
Central
2000 setup to Project Server 2003. I understand that part of the task
is to
migrate the Project Central database and that I have to run two
scripts:
UPG09DB.CMD (this migrates the DB from 2000 to Project Server 2002
format)
and UPG10DB.CMD (This migrates the DB from 2002 to 2003 format). I
looked at
the UPG09DB.CMD and saw that it was deleting the contents of the
MSP_PROJECTS table, which I assume contains all the project related
information on the DB. Since the original DB has around 700+ projects
stored in it, it there any way to migrate those information to Project
Server 2003 automatically as well? If not, are there steps I can follow
to
do this? One Project Server 2002 migration article I came across
mentioned
that I would have to re-import the Project Plans into the migrated DB.
If I
need to do this, then how do I export all 700+ project plans from the
original database without doing a tedious 'Save-As' approach for each
one?

I really appreciate any help you can give me.

Thanks!

Rene

 

[Gary L. Chefetz [MVP]]

Rene:

The only automated migration path Microsoft offers is the one you've defined
in your post. Of course you can automate using code. I'd be very cautious
about any of this if I were in your position.