PSMigrat.exe

S

SleepySam

Hi All

I'm trying to upgrade the STS to WSS. I'm follwoing the Installation 2003 guide and I reached to the migration point. I try to use the PSmigrat tool but everytime it gives me different error message. here is what I do
PSMigrat.exe -w http://proj2003/projectserver -f c:\backup -dbserver proj2003 -dblogin sa -dbpassword passwor
where http://proj2003/projectserver is the project 2003 server.
c:\backup is where the STS & projectserver databases are (got them from the project 2002 server
dbserver is the proj2003 serve
My 2002 installation was on single server as well as project 2003

Any ideas?!

Than
 
G

Gary L. Chefetz [MVP]

Sleepy:

It's difficult to tell what's going on without the error message. The most
common mistake people make is trying to run this on the new server, rather
than the old server. Is that the case for you?




SleepySam said:
Hi All,

I'm trying to upgrade the STS to WSS. I'm follwoing the Installation 2003
guide and I reached to the migration point. I try to use the PSmigrat tool
but everytime it gives me different error message. here is what I do:
PSMigrat.exe -w http://proj2003/projectserver -f c:\backup -dbserver
proj2003 -dblogin sa -dbpassword password
 
S

SleepySam

Gary

Thanks for your reply. I'm quoting here a note from Project Server 2003 Installatioon guide that says: "You must run PSMigrat.exe from the computer running Windows SharePoint Services" (Page 46 on the PDF document). The new server (that has project 2003 server installed) has Windows SharePoint Services while the old one (that has project 2002 server installed) has the SharePoint Team Services. This statement means that I have to run PSMigat.exe on the new server!!!!

I have asked previously for document or URL other than the installation guide but no one has answered back. I feel that the installation guide doesn't elaborate much on the migration

Thank you
 
S

Skoegahom

Gary,

I am stuck at the same place and would very much like to
know if you run the migration from the WSS box or the STS
box. As SleepySam points out the Microsoft doc tells us
to run it from the WSS box.

I have opened a incident with Premier support, however,
I'm having a tab bit more difficulty in that I cannot get
OWS1002.exe to install on the STS box. At least the
error message I get when I run PSMigrat.exe is the exact
error you get when OWS1002.exe is not installed. I did
not try to run PSMigrat.exe from the STS box.

Skoe...


-----Original Message-----
Gary,

Thanks for your reply. I'm quoting here a note from
Project Server 2003 Installatioon guide that says: "You
must run PSMigrat.exe from the computer running Windows
SharePoint Services" (Page 46 on the PDF document). The
new server (that has project 2003 server installed) has
Windows SharePoint Services while the old one (that has
project 2002 server installed) has the SharePoint Team
Services. This statement means that I have to run
PSMigat.exe on the new server!!!!
I have asked previously for document or URL other than
the installation guide but no one has answered back. I
feel that the installation guide doesn't elaborate much
on the migration.
 
S

SleepySam

Skoegaho

For the OWS1002 to be installed, you have to install Office XP Service pack 1 & 2 first.
Another thing that bothers me is that the Microsoft document says to run stswiz.exe after installing the update, but hwne I run the stswiz.exe, I get 2 options: Provision additional SharePoint Web sites for Project Server OR Restore SharePoint Team Services original template files. SoI go with the first one and I get a message box saying: Failed to copy the modified search.htx to ther web site you ...

I must say that I'm really dissapointed from Microsoft regarding migration.
 
G

Gary L. Chefetz [MVP]

Sleepy:

I misread your post the first time around, let's try again.

Before you run psmigrat:

On the STS server, install the STS SPs and the OWS1002.exe patch, then run
stswiz
On the Project server, run the 2003 upgrade scripts

Now you're ready to run psmigrat on the WSS box like this according to your
previous post:

Psmigrat -w http://proj2003/sites
-f \\proj2003\backup
-ownerlogin countingsheep\sleepysam
-owneremail (e-mail address removed)
-psintraneturl http://proj2003/projectserver
-dbserver <name of old db server here no brackets>
-dbname projectserver
-dblogin sa
-dbpassword password





SleepySam said:
Hi All,

I'm trying to upgrade the STS to WSS. I'm follwoing the Installation 2003
guide and I reached to the migration point. I try to use the PSmigrat tool
but everytime it gives me different error message. here is what I do:
PSMigrat.exe -w http://proj2003/projectserver -f c:\backup -dbserver
proj2003 -dblogin sa -dbpassword password
 
S

Skoegahom

Sleepy...

I finally got my migration to work.

You run PSMigrat.exe from the WSS box. The problem that
I was having is that I installed Office XP SP2 Pro, which
evidently does not have all the updates from SP1 & SP2
separately. This was a mystery to Microsoft support...
So anyway, we uninstalled Office XP SP2 and then
reapplied SP1 & SP2 without installing Office XP SP2 Pro.
It worked and I successfully migrated around 250 websites
Friday. Here's an example of the psmigrat command that I
used:

C:\Programs\msproject11\SUPPORT\PSMIGRAT\psmigrat.exe
-w http://sprg-testproj/sites
-f c:\psmigrat\backup
-ownerlogin DOMAIN\userid
-owneremail (e-mail address removed)
-i 529 (this is a list of websites, in this example I
simply choose 1 of them)
-dbserver sprg-sql-2
-dbname ProjectServerTest
-dblogin (SQL login with SA privs)
-dbpassword password
-l c:\psmigrat\log\

You must run the command from the folder listed in the
path above or copy all four of the files to the directory
where you want to run the command. I placed the above
command in C:\pmisgrat\psmigrat.bat along with the
executables.

I have not completed my testing yet, but it certainly
brought over my documents and created my Project
websites. However, it may not have brought over my
issues...

Skoe...

-----Original Message-----
Skoegahom

For the OWS1002 to be installed, you have to install
Office XP Service pack 1 & 2 first.
Another thing that bothers me is that the Microsoft
document says to run stswiz.exe after installing the
update, but hwne I run the stswiz.exe, I get 2 options:
Provision additional SharePoint Web sites for Project
Server OR Restore SharePoint Team Services original
template files. SoI go with the first one and I get a
message box saying: Failed to copy the modified
search.htx to ther web site you ....
 
S

SleepySam

Lucky u Skoegaho

My problem is that I have project server 2002 installation on one server (This server has SQL, STS & ProjectServer 2002). I have to migrate it into 2 other servers. in my test I'm using one server for EPM 2002 named PROJ2002 and one server EPM2003 named PROJ2003
I'm going to write down the steps that I have followed maybe someone can pinpoint my mistake: (My Reference is 2003 Installation GUIDE
Note: EPM 2002 is intalled on ONE server named PROJ2002 - which means that this server has EPM 2002, SQL & STS installed on it. EPM 2003 is installed on ONE Server named PROJ2003 - which means that this server has EPM 2003, SQL & WSS). And since I'm doing a lab test both server are NOT part of a domain, they are part of WORKGROUP
1. I did a full backup of Project server 2002 database
2. I installed WSS (STSV2.exe) on PROJ2003 with the -f switc
3. I run the command UPG10DB.cmd Proj2002 ProjectServer sa password. I then Installed ProjectServer 2003 on PROJ2003. But since I'm testing on one Server and I don't want to use PROJ2002 Server rather than connecting to an existing database (on PROJ2002), I created a new database (ProjectServer) and when I finished I restored the upgraded database
4. On PROJ2002, I have installed Office XP SP1, SP2 & SP
5. I have Apllied OWS1002.exeon PROJ200
6. I then run STSwiz.exe and chosed Provision additional SharePoint Web sites for Project Server.
7. I Then run the command PSmigrat -w http://PROJ2003/sites -f c:\backup -ownerlogin PROJ2002\Administrator -owneremail (e-mail address removed) -dbserver PROJ2003 -dbname ProjectServer -dblogin sa -dbpassword passwor
 
S

Skoegahom

Sleepy,

assuming you have installed and configured everything
correctly, I'm going to first of all focus on the
psmigrat.exe command.

1. Are you running it using a local admin account?
2. Where are you running this command from? It should be
run from the CD in the \SUPPORT\PSMIGRAT\folder where
psmigrat.exe, smigrate.exe, etc are located or you can
copy all of those files to another location and run the
migration from that directory.
3. This may mean nothing, but there's an extra space
after the -f parameter in the example you provided
4. PROJ2002\Aministrator is the WSS Owner?
5. -dbname is the name of the new database?
6. I would create a folder something like c:\backup\logs
and then specify the -l parameter to give you a log of
the psmigrat.exe to make sure that is the only error you
are getting.
7. Finally, you might want to attempt migrating just one
website while you are testing using the -i parameter.
You can get a particular site's id in PSWA - Admin -
Manage SharePoint Team Services - Manage Subwebs and just
placing the Project ID after the -i for instance, -i 529.

http://PROJ2003/sites
-f c:\backup
-ownerlogin PROJ2002\Administrator
-owneremail (e-mail address removed)
-dbserver PROJ2003
-dbname ProjectServer
-dblogin sa
-dbpassword password

It's almost like you are either not generating the output
from smigrate or you don't have permission to generate
the output.

One other thing to consider is that when I installed
Office XP on the STS server, I used the Office XP SP2
media. Microsoft Premier Support had me uninstall that
and only install SP1 & SP2 which I downloaded from
Microsoft. This was a surprise to me as I assumed that
you had to have Office XP installed to apply SP1 & SP2.
You do not and it wasn't until I removed it that I was
able to apply OWS1002.exe correctly.

Skoe...


-----Original Message-----
Lucky u Skoegahom

My problem is that I have project server 2002
installation on one server (This server has SQL, STS &
ProjectServer 2002). I have to migrate it into 2 other
servers. in my test I'm using one server for EPM 2002
named PROJ2002 and one server EPM2003 named PROJ2003.
I'm going to write down the steps that I have followed
maybe someone can pinpoint my mistake: (My Reference is
2003 Installation GUIDE)
Note: EPM 2002 is intalled on ONE server named PROJ2002 -
which means that this server has EPM 2002, SQL & STS
installed on it. EPM 2003 is installed on ONE Server
named PROJ2003 - which means that this server has EPM
2003, SQL & WSS). And since I'm doing a lab test both
server are NOT part of a domain, they are part of
WORKGROUP.
1. I did a full backup of Project server 2002 database.
2. I installed WSS (STSV2.exe) on PROJ2003 with the -f switch
3. I run the command UPG10DB.cmd Proj2002 ProjectServer
sa password. I then Installed ProjectServer 2003 on
PROJ2003. But since I'm testing on one Server and I don't
want to use PROJ2002 Server rather than connecting to an
existing database (on PROJ2002), I created a new database
(ProjectServer) and when I finished I restored the
upgraded database
4. On PROJ2002, I have installed Office XP SP1, SP2 & SP3
5. I have Apllied OWS1002.exeon PROJ2002
6. I then run STSwiz.exe and chosed Provision additional
SharePoint Web sites for Project Server.
7. I Then run the command PSmigrat -w
http://PROJ2003/sites -f c:\backup -ownerlogin PROJ2002
\Administrator -owneremail (e-mail address removed) -dbserver PROJ2003 -
dbname ProjectServer -dblogin sa -dbpassword password
 
S

SleepySam

it semi worked with me. all I did was that I joined them to the domain and used a domain user with admin prefileges on both servers
I will try next week on real database and see what happen

Thanks for you time & effort
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top