Upgrade of Issues Data from 2002 to 2003

S

Savoy55

We have recently upgraded from Project Server 2002 to Project Server 2003. We
are using Sharepoint and have been since our 2002 install. We have been
tracking issues, using Sharepoint. When we upgraded to 2003, none of our
details from the issues are displayed. We are wondering how to get all of our
exisitng data to show up in 2003.
 
I

IISJUNKIE

When you did the upgrade you most likely did the following:
1) Made a copy of the existing 2k MSPSdatabase
2) Ran the SQL Upgrade DB Command on that database.
3) installed MSPS Server and connected to the upgraded database,
4) Ran the MSPS SP1 Upgrade DB Utility - NOT the same as the initial one.
5) Installed the Sharepoint part of the application which created it's 2
databases
6) Opened up PWA and everything looked right except the sharepoint stuff.

Am I close? If so then the good news is that your data is still availible
but inorder to complete the transition you'll have to do the following:
a) turn off automatic site creation for Sharepoint admin site and PWA site
under "manage sharepoint sites" then
on the old server where the sharepoint stuff used to be - hopefully it's
still up and running then just use the STSADM.EXE command line utility to 1)
enumerate all sites - this will give you a list of sites 2) STSADM.EXE to
create a site backup 3) copy physical files over to new environment 4) run
the same utility to restore sites to the new environement.
Or - if there is a decent amount of project plans but not like hundreds then
you could use the project migration utility which has the same effect but
with a GUI interface.

Either way DO NOT modify or change the current configurations for sharepoint
since you already have a good install minus the sites & stuff.

Good Luck
 
Top