Error = Could not load the setup or translator library

S

sc

I am working on a Project 2003 Migration to Project 2007. Upon running the
the Migration Tool i receive the folling in the log:
07/22/2008 16:24:59.162 Log file Initialized
07/22/2008 16:24:59.162 Migration tool version is 12,0,4518,1014
07/22/2008 16:24:59.162 Configuration file is c:\p12migration.ini
07/22/2008 16:24:59.459 Connecting to Project Server 2007 Draft db...
07/22/2008 16:24:59.459 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= ORBDEVPROJECT, db = ProjectServer_Draft, trusted = 1
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not create DSN MSP-12-WORKING-DB-DSN.
07/22/2008 16:24:59.474 COdbcCmd::CreateDSN failed with status 80004005
07/22/2008 16:24:59.474 ConnectToSQLServer failed for Draft db with status
80004005
07/22/2008 16:24:59.474 ERROR: Initializing Project Server 2007
Communicator object failed
07/22/2008 16:24:59.474 Initialize() failed
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not remove DSN MSP-12-WORKING-DB-DSN.
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.

I have done my best to follow the migration guide to a tee. Can anyone
provide some insight on how to fix the above?

Here is a copy of my MigrationSettings:

[General]

;The Project Server 2007 Migration Tool writes verbose information to the log
;file. If the migration tool cannot write to the log file, it stops running,
;so you can be sure that you can always refer to the log file for more
;information about the migration run. The log file is your main source of
;troubleshooting information for the migration tool.
;The following setting identifies the path to the log file.

LogFilePath=c:\ProjectServer2007Migration

;The following setting identifies the prefix of the migration log file. The
log
;file name is a combination of LogFileNamePrefix and the timestamp of when
the
;migration started. For example: batch1-20060314-1542.log. This log was
;generated from a migration run that started on 3/14/2006 at 3:42 pm.
;You can run the migration tool multiple times. Some reasons for doing this
;could be, for example, to upgrade projects in batches, or if the tool
;crashes. You can use a different Log file name prefix to identify each
;migration run.

LogFileNamePrefix=Batch1

;MigrateAll is a shortcut configuration setting for migrating all projects at
;once. If you specify MigrateAll=Save, all projects in Project Server 2003
;will be migrated to Project Server 2007 and none of them will be published.
;If you specify MigrateAll=Publish, all projects will be migrated, and the
;published projects in Project Server 2003 will be published automatically in
;Project Server 2007.
;NOTE: The MigrateAll setting is ignored if you have specified any project
;names in the [Project Names to Save and Publish] or
;[Project Names to Publish] sections.

MigrateAll=Publish

;If 'FixUpSecurityCategories' property is set to 'yes', projects are
automatically
;added to security categories after they are migrated. If it is set to 'no'
;projects will not be added to any security category after migration.
;Typically, you would set this policy to 'no' if the categories in Project
;Server 2007 will be significantly different from the categories you used in
;Project Server 2003, and you want to add your projects to security categories
;manually.

FixUpSecurityCategories=yes

;By default, the value of 'StopProjectMigrationIfStatusUpdatesPending'
property
;is 'yes'. So, if any project has pending updates, it will not be migrated
;over. But in some cases, customers may want to migrate projects even though
;they have pending updates. Eg. If there are lots of old projects, which
need to
;be migrated, but there are no active project managers for these projects to
;process pending updates. In those cases set the value of this property to
'no'

StopProjectMigrationIfStatusUpdatesPending=yes

;By default, the value of 'NeverPublishMasterProjects' property is set to
'yes'.
;So, master projects are never published, even if they are included in the
;[Project names to Save and Publish] section. This is useful for customers
who
;have set the 'never publish master projects' option in their Project Server
2003
;installation and don't want master projects to be published even by
mistake. But
;if customers want to publish master projects, set the
'NeverPublishMasterProjects'
;option to 'no'. Note that, even if you specify this setting, you need to
;manually include the master projects in the [Project names to Save and
Publish]
;section.
;Note: Publshing a master project in Project Server 2007 will not
;double-count availability (see master project documentation for more details)

NeverPublishMasterProjects=yes

;The policy 'ResetStatusManagerToOwnerOnConflict' controls the migration
tool behaviour
;when a project has a task which has
;different status managers for its assignments. In Project Server 2007, this
situation is
;not supported ie) all assignments in a task can have only one status
manager. By
;default, the value of 'ResetStatusManagerToOwnerOnConflict' property is set
to 'Yes',
;which means that after migration, the status manager for the conflicting
assignments
;would be the project manager. If the value is set to 'No', the project will
not be migrated.
;The customers can fix up the conflict themselves and resubmit the project
for migration.

ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]

;The projects you specify in this section will be saved as part of migration,
;but they will not be published.
;Use the full name of the project, which is stored in the PROJ_NAME column in
;the MSP_PROJECTS table.



[Project Names to Save and Publish]

;To save and publish migrated projects, specify them in this section. Note
that
;only projects that were published in Project Server 2003 can be published
to the
;Project Server 2007 database. If you specify a project that is not a
..published
;version in this section (for example, .target version), it will simply be
saved.



[Excluded Project Names]

;Specify any project that you do not want to include during migration. This
;option is typically used with the MigrateAll setting when you want to migrate
;most, but not all, of your projects.



[Project Server 2007]

;The following setting identifies the Project Web Access URL.

Project2007PWAServer=http://ORBDEVPROJECT/pwa


;The following setting identifies the SQL Server instance that hosts the
;Project Server 2007 databases.
;######## IMPORTANT ############
;By default, the Project Server 2003 databases also should be part of the
;same SQL Server instance as Project Server 2007.
;To do this, back up and restore the Project Server 2003 databases into the
;Project Server 2007 SQL Server instance. If this is a major restriction for
;you, refer to the Project2003SQLServer property in the [Project Server 2003]
;section.

Project2007SQLServer=ORBDEVPROJECT

;The following settings specify the names of the Project Server 2007 Draft and
;Published databases.

DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published


[Project Server 2003]

;If your Project Server 2003 database is in single database configuration
;(as opposed to split database configuration), you need to specify the same
;database name for both Project2003ProjectTablesDB and Project2003WebTablesDB.
;Note that the migration tool does not migrate cube tables. You will need to
;rebuild cubes after migration.

Project2003ProjectTablesDB=Project_2003_MigBak
Project2003WebTablesDB=Project_2003_MigBak

;You can specify the Linked SQL Server name that points to the SQL Server
;instance where the Project Server 2003 databases reside. By default, this
;configuration is not enabled (the Project2003LinkedSQLServer property in the
;configuration file is commented out) and the migration tool assumes that the
;Project Server 2003 and 2007 databases reside on the same SQL Server
;instance. This is because specifying this property involves some manual
;steps to create the correct Linked SQL Server.
;To create a linked server, do the following:
;1. Connect to the server running Project Server 2007 by using SQL
; enterprise manager.
;2. In SQL Server 2000 Enterprise Manager: In the tree structure, click to
expand the Security folder.
; In SQL Server 2005 Management Studio: In the tree structure, click to
expand Server Objects folder.
;3. Right-click Linked Servers, and then click New Linked Server.
; Refer to the SQL Server documentation for more information on how to
; create a linked server (search for "linked servers" in the
documentation).
; Make sure you click on the 'Security' tab and select the right security
; option (Eg. select 'be made using the login's current security context'
; radio button OR the 'be made using this security context' option and
; give a valid user name/password that works on the Project 2003 SQL
Server).
; The option you choose will depend on how you are running migration.
Choose
; the one that works for you and refer to SQL Linked Server documentation
for
; more details.
;4. Verify that the linked server you created works. ie) You should see the
; linked server you just created under the "Linked Servers" node. Once you
; expand the linked server, you should see the nodes 'Tables' and 'Views'.
; If you click on 'Tables' or 'Views', you should see some entries.
; NOTE: In some IT environments, specific ports related to Microsoft
; Distributed Transaction Coordinator (MSDTC) might need to be opened
; for the linked server configuration to work. For more information,
; see the SQL Server documentation about linked servers or contact
; your system administrator.
;5. Give the name of the SQL Linked Server as the value for the
; Project2003LinkedSQLServer property.

;Project2003LinkedSQLServer=LinkedSQLServerName
 
G

Gordon

Hi,

This one will be kinda hard to figure out without actually seeing and
investigating the environment.

some pointers

1. Have you tried to just migreate the Ent Global First ?
2. Is the SQL Server version 2005 if yes has the Project Server db moved
from 2000
to 2005?
3. Is the Project Server 2003 DB on the same instance as the target
installion of PS2007?

It is hard wihtout actually seing the environment.

--
Gordon Lewis
http://gordonlewis.spaces.live.com/


sc said:
I am working on a Project 2003 Migration to Project 2007. Upon running the
the Migration Tool i receive the folling in the log:
07/22/2008 16:24:59.162 Log file Initialized
07/22/2008 16:24:59.162 Migration tool version is 12,0,4518,1014
07/22/2008 16:24:59.162 Configuration file is c:\p12migration.ini
07/22/2008 16:24:59.459 Connecting to Project Server 2007 Draft db...
07/22/2008 16:24:59.459 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= ORBDEVPROJECT, db = ProjectServer_Draft, trusted = 1
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not create DSN MSP-12-WORKING-DB-DSN.
07/22/2008 16:24:59.474 COdbcCmd::CreateDSN failed with status 80004005
07/22/2008 16:24:59.474 ConnectToSQLServer failed for Draft db with status
80004005
07/22/2008 16:24:59.474 ERROR: Initializing Project Server 2007
Communicator object failed
07/22/2008 16:24:59.474 Initialize() failed
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not remove DSN MSP-12-WORKING-DB-DSN.
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.

I have done my best to follow the migration guide to a tee. Can anyone
provide some insight on how to fix the above?

Here is a copy of my MigrationSettings:

[General]

;The Project Server 2007 Migration Tool writes verbose information to the log
;file. If the migration tool cannot write to the log file, it stops running,
;so you can be sure that you can always refer to the log file for more
;information about the migration run. The log file is your main source of
;troubleshooting information for the migration tool.
;The following setting identifies the path to the log file.

LogFilePath=c:\ProjectServer2007Migration

;The following setting identifies the prefix of the migration log file. The
log
;file name is a combination of LogFileNamePrefix and the timestamp of when
the
;migration started. For example: batch1-20060314-1542.log. This log was
;generated from a migration run that started on 3/14/2006 at 3:42 pm.
;You can run the migration tool multiple times. Some reasons for doing this
;could be, for example, to upgrade projects in batches, or if the tool
;crashes. You can use a different Log file name prefix to identify each
;migration run.

LogFileNamePrefix=Batch1

;MigrateAll is a shortcut configuration setting for migrating all projects at
;once. If you specify MigrateAll=Save, all projects in Project Server 2003
;will be migrated to Project Server 2007 and none of them will be published.
;If you specify MigrateAll=Publish, all projects will be migrated, and the
;published projects in Project Server 2003 will be published automatically in
;Project Server 2007.
;NOTE: The MigrateAll setting is ignored if you have specified any project
;names in the [Project Names to Save and Publish] or
;[Project Names to Publish] sections.

MigrateAll=Publish

;If 'FixUpSecurityCategories' property is set to 'yes', projects are
automatically
;added to security categories after they are migrated. If it is set to 'no'
;projects will not be added to any security category after migration.
;Typically, you would set this policy to 'no' if the categories in Project
;Server 2007 will be significantly different from the categories you used in
;Project Server 2003, and you want to add your projects to security categories
;manually.

FixUpSecurityCategories=yes

;By default, the value of 'StopProjectMigrationIfStatusUpdatesPending'
property
;is 'yes'. So, if any project has pending updates, it will not be migrated
;over. But in some cases, customers may want to migrate projects even though
;they have pending updates. Eg. If there are lots of old projects, which
need to
;be migrated, but there are no active project managers for these projects to
;process pending updates. In those cases set the value of this property to
'no'

StopProjectMigrationIfStatusUpdatesPending=yes

;By default, the value of 'NeverPublishMasterProjects' property is set to
'yes'.
;So, master projects are never published, even if they are included in the
;[Project names to Save and Publish] section. This is useful for customers
who
;have set the 'never publish master projects' option in their Project Server
2003
;installation and don't want master projects to be published even by
mistake. But
;if customers want to publish master projects, set the
'NeverPublishMasterProjects'
;option to 'no'. Note that, even if you specify this setting, you need to
;manually include the master projects in the [Project names to Save and
Publish]
;section.
;Note: Publshing a master project in Project Server 2007 will not
;double-count availability (see master project documentation for more details)

NeverPublishMasterProjects=yes

;The policy 'ResetStatusManagerToOwnerOnConflict' controls the migration
tool behaviour
;when a project has a task which has
;different status managers for its assignments. In Project Server 2007, this
situation is
;not supported ie) all assignments in a task can have only one status
manager. By
;default, the value of 'ResetStatusManagerToOwnerOnConflict' property is set
to 'Yes',
;which means that after migration, the status manager for the conflicting
assignments
;would be the project manager. If the value is set to 'No', the project will
not be migrated.
;The customers can fix up the conflict themselves and resubmit the project
for migration.

ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]

;The projects you specify in this section will be saved as part of migration,
;but they will not be published.
;Use the full name of the project, which is stored in the PROJ_NAME column in
;the MSP_PROJECTS table.



[Project Names to Save and Publish]

;To save and publish migrated projects, specify them in this section. Note
that
;only projects that were published in Project Server 2003 can be published
to the
;Project Server 2007 database. If you specify a project that is not a
.published
;version in this section (for example, .target version), it will simply be
saved.



[Excluded Project Names]

;Specify any project that you do not want to include during migration. This
;option is typically used with the MigrateAll setting when you want to migrate
;most, but not all, of your projects.



[Project Server 2007]

;The following setting identifies the Project Web Access URL.

Project2007PWAServer=http://ORBDEVPROJECT/pwa


;The following setting identifies the SQL Server instance that hosts the
;Project Server 2007 databases.
;######## IMPORTANT ############
;By default, the Project Server 2003 databases also should be part of the
;same SQL Server instance as Project Server 2007.
;To do this, back up and restore the Project Server 2003 databases into the
;Project Server 2007 SQL Server instance. If this is a major restriction for
;you, refer to the Project2003SQLServer property in the [Project Server 2003]
;section.

Project2007SQLServer=ORBDEVPROJECT

;The following settings specify the names of the Project Server 2007 Draft and
;Published databases.

DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published


[Project Server 2003]

;If your Project Server 2003 database is in single database configuration
;(as opposed to split database configuration), you need to specify the same
;database name for both Project2003ProjectTablesDB and Project2003WebTablesDB.
;Note that the migration tool does not migrate cube tables. You will need to
;rebuild cubes after migration.

Project2003ProjectTablesDB=Project_2003_MigBak
Project2003WebTablesDB=Project_2003_MigBak

;You can specify the Linked SQL Server name that points to the SQL Server
;instance where the Project Server 2003 databases reside. By default, this
;configuration is not enabled (the Project2003LinkedSQLServer property in the
;configuration file is commented out) and the migration tool assumes that the
;Project Server 2003 and 2007 databases reside on the same SQL Server
;instance. This is because specifying this property involves some manual
;steps to create the correct Linked SQL Server.
;To create a linked server, do the following:
;1. Connect to the server running Project Server 2007 by using SQL
; enterprise manager.
;2. In SQL Server 2000 Enterprise Manager: In the tree structure, click to
expand the Security folder.
; In SQL Server 2005 Management Studio: In the tree structure, click to
expand Server Objects folder.
;3. Right-click Linked Servers, and then click New Linked Server.
; Refer to the SQL Server documentation for more information on how to
; create a linked server (search for "linked servers" in the
documentation).
; Make sure you click on the 'Security' tab and select the right security
; option (Eg. select 'be made using the login's current security context'
; radio button OR the 'be made using this security context' option and
; give a valid user name/password that works on the Project 2003 SQL
Server).
; The option you choose will depend on how you are running migration.
Choose
; the one that works for you and refer to SQL Linked Server documentation
for
; more details.
;4. Verify that the linked server you created works. ie) You should see the
; linked server you just created under the "Linked Servers" node. Once you
; expand the linked server, you should see the nodes 'Tables' and 'Views'.
; If you click on 'Tables' or 'Views', you should see some entries.
; NOTE: In some IT environments, specific ports related to Microsoft
; Distributed Transaction Coordinator (MSDTC) might need to be opened
; for the linked server configuration to work. For more information,
; see the SQL Server documentation about linked servers or contact
; your system administrator.
;5. Give the name of the SQL Linked Server as the value for the
; Project2003LinkedSQLServer property.

;Project2003LinkedSQLServer=LinkedSQLServerName
 
S

sc

Hi Gordon,

Thank you for your suggestions. This was a bit of a tricky issue but i did
get it figured out with some help from a friend.

i finally discovered that the SQLUNIRL.DLL and SQLSRV32.DLL files were
missing from c:\windows\system32 so the ODBC connection was failing. Once we
copied them over from another server things worked and i was able to
successfully migration my server.

Steve

Gordon said:
Hi,

This one will be kinda hard to figure out without actually seeing and
investigating the environment.

some pointers

1. Have you tried to just migreate the Ent Global First ?
2. Is the SQL Server version 2005 if yes has the Project Server db moved
from 2000
to 2005?
3. Is the Project Server 2003 DB on the same instance as the target
installion of PS2007?

It is hard wihtout actually seing the environment.

--
Gordon Lewis
http://gordonlewis.spaces.live.com/


sc said:
I am working on a Project 2003 Migration to Project 2007. Upon running the
the Migration Tool i receive the folling in the log:
07/22/2008 16:24:59.162 Log file Initialized
07/22/2008 16:24:59.162 Migration tool version is 12,0,4518,1014
07/22/2008 16:24:59.162 Configuration file is c:\p12migration.ini
07/22/2008 16:24:59.459 Connecting to Project Server 2007 Draft db...
07/22/2008 16:24:59.459 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= ORBDEVPROJECT, db = ProjectServer_Draft, trusted = 1
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not create DSN MSP-12-WORKING-DB-DSN.
07/22/2008 16:24:59.474 COdbcCmd::CreateDSN failed with status 80004005
07/22/2008 16:24:59.474 ConnectToSQLServer failed for Draft db with status
80004005
07/22/2008 16:24:59.474 ERROR: Initializing Project Server 2007
Communicator object failed
07/22/2008 16:24:59.474 Initialize() failed
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not remove DSN MSP-12-WORKING-DB-DSN.
07/22/2008 16:24:59.474 Error = Could not load the setup or translator
library
07/22/2008 16:24:59.474 Could not remove DSN MSP-12-PUBLISHED-DB-DSN.

I have done my best to follow the migration guide to a tee. Can anyone
provide some insight on how to fix the above?

Here is a copy of my MigrationSettings:

[General]

;The Project Server 2007 Migration Tool writes verbose information to the log
;file. If the migration tool cannot write to the log file, it stops running,
;so you can be sure that you can always refer to the log file for more
;information about the migration run. The log file is your main source of
;troubleshooting information for the migration tool.
;The following setting identifies the path to the log file.

LogFilePath=c:\ProjectServer2007Migration

;The following setting identifies the prefix of the migration log file. The
log
;file name is a combination of LogFileNamePrefix and the timestamp of when
the
;migration started. For example: batch1-20060314-1542.log. This log was
;generated from a migration run that started on 3/14/2006 at 3:42 pm.
;You can run the migration tool multiple times. Some reasons for doing this
;could be, for example, to upgrade projects in batches, or if the tool
;crashes. You can use a different Log file name prefix to identify each
;migration run.

LogFileNamePrefix=Batch1

;MigrateAll is a shortcut configuration setting for migrating all projects at
;once. If you specify MigrateAll=Save, all projects in Project Server 2003
;will be migrated to Project Server 2007 and none of them will be published.
;If you specify MigrateAll=Publish, all projects will be migrated, and the
;published projects in Project Server 2003 will be published automatically in
;Project Server 2007.
;NOTE: The MigrateAll setting is ignored if you have specified any project
;names in the [Project Names to Save and Publish] or
;[Project Names to Publish] sections.

MigrateAll=Publish

;If 'FixUpSecurityCategories' property is set to 'yes', projects are
automatically
;added to security categories after they are migrated. If it is set to 'no'
;projects will not be added to any security category after migration.
;Typically, you would set this policy to 'no' if the categories in Project
;Server 2007 will be significantly different from the categories you used in
;Project Server 2003, and you want to add your projects to security categories
;manually.

FixUpSecurityCategories=yes

;By default, the value of 'StopProjectMigrationIfStatusUpdatesPending'
property
;is 'yes'. So, if any project has pending updates, it will not be migrated
;over. But in some cases, customers may want to migrate projects even though
;they have pending updates. Eg. If there are lots of old projects, which
need to
;be migrated, but there are no active project managers for these projects to
;process pending updates. In those cases set the value of this property to
'no'

StopProjectMigrationIfStatusUpdatesPending=yes

;By default, the value of 'NeverPublishMasterProjects' property is set to
'yes'.
;So, master projects are never published, even if they are included in the
;[Project names to Save and Publish] section. This is useful for customers
who
;have set the 'never publish master projects' option in their Project Server
2003
;installation and don't want master projects to be published even by
mistake. But
;if customers want to publish master projects, set the
'NeverPublishMasterProjects'
;option to 'no'. Note that, even if you specify this setting, you need to
;manually include the master projects in the [Project names to Save and
Publish]
;section.
;Note: Publshing a master project in Project Server 2007 will not
;double-count availability (see master project documentation for more details)

NeverPublishMasterProjects=yes

;The policy 'ResetStatusManagerToOwnerOnConflict' controls the migration
tool behaviour
;when a project has a task which has
;different status managers for its assignments. In Project Server 2007, this
situation is
;not supported ie) all assignments in a task can have only one status
manager. By
;default, the value of 'ResetStatusManagerToOwnerOnConflict' property is set
to 'Yes',
;which means that after migration, the status manager for the conflicting
assignments
;would be the project manager. If the value is set to 'No', the project will
not be migrated.
;The customers can fix up the conflict themselves and resubmit the project
for migration.

ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]

;The projects you specify in this section will be saved as part of migration,
;but they will not be published.
;Use the full name of the project, which is stored in the PROJ_NAME column in
;the MSP_PROJECTS table.



[Project Names to Save and Publish]

;To save and publish migrated projects, specify them in this section. Note
that
;only projects that were published in Project Server 2003 can be published
to the
;Project Server 2007 database. If you specify a project that is not a
.published
;version in this section (for example, .target version), it will simply be
saved.



[Excluded Project Names]

;Specify any project that you do not want to include during migration. This
;option is typically used with the MigrateAll setting when you want to migrate
;most, but not all, of your projects.



[Project Server 2007]

;The following setting identifies the Project Web Access URL.

Project2007PWAServer=http://ORBDEVPROJECT/pwa


;The following setting identifies the SQL Server instance that hosts the
;Project Server 2007 databases.
;######## IMPORTANT ############
;By default, the Project Server 2003 databases also should be part of the
;same SQL Server instance as Project Server 2007.
;To do this, back up and restore the Project Server 2003 databases into the
;Project Server 2007 SQL Server instance. If this is a major restriction for
;you, refer to the Project2003SQLServer property in the [Project Server 2003]
;section.

Project2007SQLServer=ORBDEVPROJECT

;The following settings specify the names of the Project Server 2007 Draft and
;Published databases.

DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published


[Project Server 2003]

;If your Project Server 2003 database is in single database configuration
;(as opposed to split database configuration), you need to specify the same
;database name for both Project2003ProjectTablesDB and Project2003WebTablesDB.
;Note that the migration tool does not migrate cube tables. You will need to
;rebuild cubes after migration.

Project2003ProjectTablesDB=Project_2003_MigBak
Project2003WebTablesDB=Project_2003_MigBak

;You can specify the Linked SQL Server name that points to the SQL Server
;instance where the Project Server 2003 databases reside. By default, this
;configuration is not enabled (the Project2003LinkedSQLServer property in the
;configuration file is commented out) and the migration tool assumes that the
;Project Server 2003 and 2007 databases reside on the same SQL Server
;instance. This is because specifying this property involves some manual
;steps to create the correct Linked SQL Server.
;To create a linked server, do the following:
;1. Connect to the server running Project Server 2007 by using SQL
; enterprise manager.
;2. In SQL Server 2000 Enterprise Manager: In the tree structure, click to
expand the Security folder.
; In SQL Server 2005 Management Studio: In the tree structure, click to
expand Server Objects folder.
;3. Right-click Linked Servers, and then click New Linked Server.
; Refer to the SQL Server documentation for more information on how to
; create a linked server (search for "linked servers" in the
documentation).
; Make sure you click on the 'Security' tab and select the right security
; option (Eg. select 'be made using the login's current security context'
; radio button OR the 'be made using this security context' option and
; give a valid user name/password that works on the Project 2003 SQL
Server).
; The option you choose will depend on how you are running migration.
Choose
; the one that works for you and refer to SQL Linked Server documentation
for
; more details.
;4. Verify that the linked server you created works. ie) You should see the
; linked server you just created under the "Linked Servers" node. Once you
; expand the linked server, you should see the nodes 'Tables' and 'Views'.
; If you click on 'Tables' or 'Views', you should see some entries.
; NOTE: In some IT environments, specific ports related to Microsoft
; Distributed Transaction Coordinator (MSDTC) might need to be opened
; for the linked server configuration to work. For more information,
; see the SQL Server documentation about linked servers or contact
; your system administrator.
;5. Give the name of the SQL Linked Server as the value for the
; Project2003LinkedSQLServer property.

;Project2003LinkedSQLServer=LinkedSQLServerName
 

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