migrate 2003 to 2007

[Ponch]

Hello,

I want to migrate my project 2003 projects to 2007
In the microsoft information, i see that i have to use the migration tool,
but first i need to make the ProjectServer2007Migrate.ini

In this file, i need to configure this information :
questions between brackets ( )

Project2007PWAServer=http://Project2007pwaserver/pwa (servername/pwa)
Project2007SQLServer=Project2007sqlserver (instance name of sqlserver,
display name or service name ?)
DraftDB=Project2007ProjectServerDraft ( no idea, where can i find this?)
PublishedDB=Project2007ProjectServerPublished (no idea, where can i find
this?)
[Project Server 2003]
Project2003ProjectTablesDB=Project2003ProjDB (no idea, where can i find
this?)
Project2003WebTablesDB=Project2003WebDB (no idea, where can i find this?)
;Project2003LinkedSQLServer=LinkedSQLServerName


Tx

 

[Bill Busby]

Project2007SQLServer=<server hosting SQLServer>
DraftDB=<default is ProjectServer_Draft> (created by Project Server 2007
install)
PublishedDB=<default is ProjectServer_Published> (created by Project Server
2007 install)
Project2003ProjectTablesDB=<SQL instance of Project Server 2003 db>
Project2003WebTablesDB=<by default the same SQL instance of Project Server
2003 db>

 

[Ben Howard]

Hi Ponch,
WSS Central Admin, click on the SSP, click on PWA instances, edit the
instance and you'll see the DBS.

The Project 2007SQLServer is the server name.
Use SQL Enterprise Manager to find the published DB for 2003. You'll need
this anyway as you'll be restoring it to the same SQL instance as the PS2007
server uses.

The linked SQL server is commented out, you only need if it you can't
restore the 2003DB to the PS2007 SQL instance.