migrate 2003 to 2007

[Ponch]

Hello,


I try to migrate my Project 2003 data to Project 2007.

First, i have made a backup of my 2003 database.
I restored this database on my Project 2007 Server.

Then i run the migration tool: p12migrationtool.exe -c
c:\migration\p12migration.ini

This is my ini file :

[General]
LogFilePath=C:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
[Project Names to Save]
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
Project2007PWAServer=http://srvwin04/pwa
Project2007SQLServer=srvwin04
DraftDB=Projectserver_Draft
PublishedDB=ProjectServer_Published
[Project Server 2003]
Project2003ProjectTablesDB=Projectserver_ProjDB
Project2003WebTablesDB=Projectserver_WebDB
;Project2003LinkedSQLServer=LinkedSQLServerName

when i run this tool , this is the result :

Migration tool version is 12,0,4518,1014
Config file = c:\migration\p12migration.ini
Press 'q' to quit at any point of time.
Using log file folder: C:\ProjectServer2007Migration
Using log file: C:\ProjectServer2007Migration\Batch1-20071107-1503.log
Connecting to Project Server 2007 Draft db...
ConnectToSQLServer failed for Draft db with status 80004005
ERROR: Initializing Project Server 2007 Communicator object failed
and this the log file :

11/05/2007 11:26:56.976 Log file Initialized
11/05/2007 11:26:56.976 Migration tool version is 12,0,4518,1014
11/05/2007 11:26:56.976 Configuration file is
c:\migration\p12Migration.ini
11/05/2007 11:26:57.085 Connecting to Project Server 2007 Draft db...
11/05/2007 11:26:57.085 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= srvwin04, db = ProjectServer_Draft, trusted = 1
11/05/2007 11:26:57.101 Created DSN MSP-12-WORKING-DB-DSN
11/05/2007 11:27:13.758 Connecting to DSN DSN=MSP-12-WORKING-DB-DSN failed
11/05/2007 11:27:13.758 ConnectToSQLServer failed for Draft db with status
80004005
11/05/2007 11:27:13.758 ERROR: Initializing Project Server 2007
Communicator object failed
11/05/2007 11:27:13.758 Initialize() failed
11/05/2007 11:27:13.774 Error = Invalid DSN
11/05/2007 11:27:13.774 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
11/05/2007 11:27:13.774 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.



I am not sure about the name of the projectserver2007 draft database, but
when i start SQL server management studio and i go to
databases, i see this draft database :
PWA_Draft_BB71653A_445B_4E12_9DF7_A99EA877C164.

Also when i specify this name in the ini file, i have the same error.

Any help would be very appreciate,

Tx,

 

[James Fraser]

Hello,

I try to migrate my Project 2003 data to Project 2007.

First, i have made a backup of my 2003 database.
I restored this database on my Project 2007 Server.

Then i run the migration tool: p12migrationtool.exe -c
c:\migration\p12migration.ini

This is my ini file :

[General]
LogFilePath=C:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
[Project Names to Save]
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
Project2007PWAServer=http://srvwin04/pwa
Project2007SQLServer=srvwin04
DraftDB=Projectserver_Draft
PublishedDB=ProjectServer_Published
[Project Server 2003]
Project2003ProjectTablesDB=Projectserver_ProjDB
Project2003WebTablesDB=Projectserver_WebDB
;Project2003LinkedSQLServer=LinkedSQLServerName

when i run this tool , this is the result :

Migration tool version is 12,0,4518,1014
Config file = c:\migration\p12migration.ini
Press 'q' to quit at any point of time.
Using log file folder: C:\ProjectServer2007Migration
Using log file: C:\ProjectServer2007Migration\Batch1-20071107-1503.log
Connecting to Project Server 2007 Draft db...
ConnectToSQLServer failed for Draft db with status 80004005
ERROR: Initializing Project Server 2007 Communicator object failed
and this the log file :

11/05/2007 11:26:56.976 Log file Initialized
11/05/2007 11:26:56.976 Migration tool version is 12,0,4518,1014
11/05/2007 11:26:56.976 Configuration file is
c:\migration\p12Migration.ini
11/05/2007 11:26:57.085 Connecting to Project Server 2007 Draft db...
11/05/2007 11:26:57.085 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= srvwin04, db = ProjectServer_Draft, trusted = 1
11/05/2007 11:26:57.101 Created DSN MSP-12-WORKING-DB-DSN
11/05/2007 11:27:13.758 Connecting to DSN DSN=MSP-12-WORKING-DB-DSN failed
11/05/2007 11:27:13.758 ConnectToSQLServer failed for Draft db with status
80004005
11/05/2007 11:27:13.758 ERROR: Initializing Project Server 2007
Communicator object failed
11/05/2007 11:27:13.758 Initialize() failed
11/05/2007 11:27:13.774 Error = Invalid DSN
11/05/2007 11:27:13.774 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
11/05/2007 11:27:13.774 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.

I am not sure about the name of the projectserver2007 draft database, but
when i start SQL server management studio and i go to
databases, i see this draft database :
PWA_Draft_BB71653A_445B_4E12_9DF7_A99EA877C164.

Also when i specify this name in the ini file, i have the same error.

If you are not sure of what the name of your 2007 draft database is,
you should talk with the person who installed Project Server 2007 and
get the name with some certainty. Also, you mention that you moved the
Project Server 2003 database over, but in the .ini file you have two
different Project Server 2003 databases specified.

Next, does the account you are using to run the migration tool have
rights on the databases?


James Fraser

 

[wvdp1812leen]

James,

i did the installation, but it was the standard install from project 2007
and sql 2005 express.
The only draft database that i find is the one that i specified:
PWA_Draft_BB71653A_445B_4E12_9DF7_A99EA877C164

Which standard name is given to the draft database when you do the standard
install?

Tx,


--
Word-User

Hello,


I try to migrate my Project 2003 data to Project 2007.

First, i have made a backup of my 2003 database.
I restored this database on my Project 2007 Server.

Then i run the migration tool: p12migrationtool.exe -c
c:\migration\p12migration.ini

This is my ini file :

[General]
LogFilePath=C:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
[Project Names to Save]
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
Project2007PWAServer=http://srvwin04/pwa
Project2007SQLServer=srvwin04
DraftDB=Projectserver_Draft
PublishedDB=ProjectServer_Published
[Project Server 2003]
Project2003ProjectTablesDB=Projectserver_ProjDB
Project2003WebTablesDB=Projectserver_WebDB
;Project2003LinkedSQLServer=LinkedSQLServerName

when i run this tool , this is the result :

Migration tool version is 12,0,4518,1014
Config file = c:\migration\p12migration.ini
Press 'q' to quit at any point of time.
Using log file folder: C:\ProjectServer2007Migration
Using log file: C:\ProjectServer2007Migration\Batch1-20071107-1503.log
Connecting to Project Server 2007 Draft db...
ConnectToSQLServer failed for Draft db with status 80004005
ERROR: Initializing Project Server 2007 Communicator object failed
and this the log file :

11/05/2007 11:26:56.976 Log file Initialized
11/05/2007 11:26:56.976 Migration tool version is 12,0,4518,1014
11/05/2007 11:26:56.976 Configuration file is
c:\migration\p12Migration.ini
11/05/2007 11:26:57.085 Connecting to Project Server 2007 Draft db...
11/05/2007 11:26:57.085 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= srvwin04, db = ProjectServer_Draft, trusted = 1
11/05/2007 11:26:57.101 Created DSN MSP-12-WORKING-DB-DSN
11/05/2007 11:27:13.758 Connecting to DSN DSN=MSP-12-WORKING-DB-DSN failed
11/05/2007 11:27:13.758 ConnectToSQLServer failed for Draft db with status
80004005
11/05/2007 11:27:13.758 ERROR: Initializing Project Server 2007
Communicator object failed
11/05/2007 11:27:13.758 Initialize() failed
11/05/2007 11:27:13.774 Error = Invalid DSN
11/05/2007 11:27:13.774 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
11/05/2007 11:27:13.774 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.



I am not sure about the name of the projectserver2007 draft database, but
when i start SQL server management studio and i go to
databases, i see this draft database :
PWA_Draft_BB71653A_445B_4E12_9DF7_A99EA877C164.

Also when i specify this name in the ini file, i have the same error.

Any help would be very appreciate,

Tx,

 

[James Fraser]

James,

i did the installation, but it was the standard install from project 2007
and sql 2005 express.
The only draft database that i find is the one that i specified:
PWA_Draft_BB71653A_445B_4E12_9DF7_A99EA877C164

Which standard name is given to the draft database when you do the standard
install?

Tx,

--
Word-User

Hello,

I try to migrate my Project 2003 data to Project 2007.

First, i have made a backup of my 2003 database.
I restored this database on my Project 2007 Server.

Then i run the migration tool: p12migrationtool.exe -c
c:\migration\p12migration.ini

This is my ini file :

[General]
LogFilePath=C:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
[Project Names to Save]
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
Project2007PWAServer=http://srvwin04/pwa
Project2007SQLServer=srvwin04
DraftDB=Projectserver_Draft
PublishedDB=ProjectServer_Published
[Project Server 2003]
Project2003ProjectTablesDB=Projectserver_ProjDB
Project2003WebTablesDB=Projectserver_WebDB
;Project2003LinkedSQLServer=LinkedSQLServerName

when i run this tool , this is the result :

Migration tool version is 12,0,4518,1014
Config file = c:\migration\p12migration.ini
Press 'q' to quit at any point of time.
Using log file folder: C:\ProjectServer2007Migration
Using log file: C:\ProjectServer2007Migration\Batch1-20071107-1503.log
Connecting to Project Server 2007 Draft db...
ConnectToSQLServer failed for Draft db with status 80004005
ERROR: Initializing Project Server 2007 Communicator object failed
and this the log file :

11/05/2007 11:26:56.976 Log file Initialized
11/05/2007 11:26:56.976 Migration tool version is 12,0,4518,1014
11/05/2007 11:26:56.976 Configuration file is
c:\migration\p12Migration.ini
11/05/2007 11:26:57.085 Connecting to Project Server 2007 Draft db...
11/05/2007 11:26:57.085 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= srvwin04, db = ProjectServer_Draft, trusted = 1
11/05/2007 11:26:57.101 Created DSN MSP-12-WORKING-DB-DSN
11/05/2007 11:27:13.758 Connecting to DSN DSN=MSP-12-WORKING-DB-DSN failed
11/05/2007 11:27:13.758 ConnectToSQLServer failed for Draft db with status
80004005
11/05/2007 11:27:13.758 ERROR: Initializing Project Server 2007
Communicator object failed
11/05/2007 11:27:13.758 Initialize() failed
11/05/2007 11:27:13.774 Error = Invalid DSN
11/05/2007 11:27:13.774 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
11/05/2007 11:27:13.774 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.

I am not sure about the name of the projectserver2007 draft database, but
when i start SQL server management studio and i go to
databases, i see this draft database :
PWA_Draft_BB71653A_445B_4E12_9DF7_A99EA877C164.

Also when i specify this name in the ini file, i have the same error.

Any help would be very appreciate,

Tx,

I am not very familiar with the limitations of SQL Express. I'm not
sure if migration to a SQL Express environment is supported.

I suppose that the DB above is the draft database, SharePoint 2007 now
appends GUID's to database names to try to keep them unique, so there
are no "standard" names for the databases.


James Fraser

 

[winzigm]

Hi most likely is this problem caused by previous run on migration
tool, you should create new instance of PWA and run migration tool
again.


But my recomendation is do not migrate mps 2003 to mps 2007 befor SP1
will be released
- i supporting a lot of cliets and i have a lot of incidents.


For example there are same bugs :
1) When you close Project pro with open project plan you are asked if
you want to save plan but plan isn't correctly saved.
2) You can change project owner - combo with project owners are
populated only wit people with permissios save on my organization.
and you have to change also other project property. In order to updare
project OWNER.
3) When you create graphical indicator for enterprice custom field you
will nod be able update project properties on the web using PSI.
4) Blank lines in project plans causing project corruption!!!
5) I discovered many ways of corrupted project plans - task with fron
parents assignments betwen user and deleted tasks. 2 diferent values
for one enterprise project property. Project with 2 resources with the
same name.


PS I created command line utility which detecting same basic types of
project corruption.
http://projectserver.cz/cms/index.php?itemid=9