PSMIGRAT query

[Ivan K]

Hi,

I have an existing installation of Sharepoint Team Services 1.0 and Project
Server 2002 on one server. On another server I have performed a clean
installation of Sharepoint Services 2003 and Project Server 2003. I am able
to get Sharepoint Services 2003 and Project Server 2003 to integrate with
each other successfully.

My intention is to migrate projects from the old installation to the new
one. To try this out, I ran the following command on the server hosting SP
and PS 2003:
--
C:\Program Files\Microsoft Office Project Server 2003 Resource
Kit\Toolbox\PSMigrat Utility>psmigrat -bo -f c:\temp\psmigrate -ownerlogin
admin\mylogin -owneremail mylogin@mydomain -i 110 -dbserver
mydbserver -dbname ProjectServerXXXX -dblogin mylogin -dbpassword
mypassword -l c:\temp\migration.log
--

Which resulted in the following error message:
--
The database specified in the connection string:
provider=sqloledb.1;uid=mylogin;pwd=mypassword;Data
Source=mydbserver;Initial Catalog=ProjectServerXXXX
does not appear to be a valid p11 migrated database. The connection string
must point to a p10 database that has been migrated using the p11 database
upgradescripts.
--
(ProjectServerXXXX is the name of the Project Server 2003 database, names
have been changed to protect the innocent.)

The documentation on PSMIGRAT is very scant but I am beginning to think that
it is only useful if one has upgraded their PS 2002 installation to PS 2003,
rather than performed a clean installation, leaving 2002 alone. Could
someone please confirm whether or not this is correct?

If this is the case, is there any way to migrate individual projects from an
instance of PS 2002 to an instance of PS 2003, migrating the corresponding
Sharepoint data along with it?

Thanks,

Ivan

 

[Charlie]

Hi Ivan,

When you say you have a clean install of WSS 2003 and
Project Server 2003 does this mean that you have not
upgraded the old Project Server database using the 2003
upgrade utility and pointed to this Db during the install
of Project Server 2003? If not then this could well be
your problem as you need to follow a set upgrade route if
you want to upgrade your projects.

you should be able to create a copy of your 2002 set-up
using site edit and then use that Db to upgrade so that
you still have the existing 2002 system intact if you
really want to.

Another thing to watchout for is that you actually run
the PSMigrate on the WSS server not the old STS box,
which is not at all clear from the documentation knocking
around.

Charlie