HOW TO: Upgrade Project Central Database 2000 to Microsoft Project Server 2002 (321344)

SUMMARY

You can update the Microsoft Project Central database when you install Microsoft Project Server. This article explains how to upgrade the database.

back to the top

NOTE: Upgrading an existing Microsoft Project Central installation requires that you convert the database for use by Microsoft Project Server. The steps in this article assume the following:

• Follow this procedure only when you upgrade from Microsoft Project Central to Microsoft Project Server for use with Microsoft Project Standard. If you upgrade to Microsoft Project Server for use with Microsoft Project Professional, install Microsoft Project Server on a different computer first and then migrate your existing data.
• If you install Microsoft Project Server on the same computer on which Microsoft Project Central is installed, remove Microsoft Project Central before you install Microsoft Project Server.
• Customizations to Microsoft Project Central pages are lost during the upgrade.
• User permissions that permitted some users to view assignments for other users are lost during the upgrade.
• Any Microsoft Project Central views that you added are preserved, although you may have to reapply some customizations.

back to the top

How to Upgrade the Project Central Database to Microsoft Project Server 2002

Follow these steps to upgrade the Project Central Database to Microsoft Project Server:

1. Back up your existing Microsoft Project Central database.
   
   CAUTION: The conversion process deletes any Microsoft Project plans that are stored in the Microsoft Project Central database. Also, any pending Team Update messages are lost during conversion.
   
2. (Optional) Copy the Microsoft Project Central database to a different computer.
   
   You can use Microsoft SQL Server tools, such as the Data Transformation Services Import/Export Wizard or the Copy Database Wizard, to copy your data to that computer. To locate the wizards, start SQL Server Enterprise Manager, point to Tools, and then click Wizards. The Data Transformation Services Import/Export Wizard is listed as DTS Import Wizard under Data Transformation Services, and the Copy Database Wizard is listed under Management.
   
   NOTE: If you are switching to Microsoft SQL Server from Microsoft Data Engine (MSDE) as part of your upgrade process, this step is strongly recommended.
3. Insert the Microsoft Project Server CD into the CD-ROM or DVD-ROM drive, or connect to a network installation point.
4. From a command prompt, access the CD-ROM drive or network installation point, and then open the following folder:

   \Support\Database

5. Type the following command to convert the Microsoft Project Central database for use by Microsoft Project Server

   osql -S server_name -U account_name -P password -d database_name -i Upgwtbls.sql

   where server_name, account_name, password, and database_name are placeholders.
   
   NOTE: The parameter letters S, U, P, d, and i are case sensitive.
   
   For example, type:
   
   

   osql -S ProjCentralSvr01 -U sa -P SApass*22 -d ProjCentralDB -i Upgwtbls.sql

   TIP: You can edit this file to specify where to place specific data, log, and index files for performance or administration reasons.
   
   TIP: You can use the Upgdb.cmd file to convert the database, create the Microsoft Project Server tables, and insert default data in one step.
6. Type the following commands to create the Microsoft Project Server tables and insert default data.
   • To create the Microsoft Project 2002 table schema (table names beginning with "MSP_"):

     osql -S server_name -U account_name -P password -d database_name -i Projtbls.sql

   • To create the stored procedures that Microsoft Project Server uses to ensure project data integrity:

     osql -S server_name -U account_name -P password -d database_name -i Projsps.sql

   • To create the tables that store the data that you use when you view projects in the Project Center (table names beginning with "MSP_VIEW"):

     osql -S server_name -U account_name -P password -d database_name -i Viewtbls.sql

   • To create the Microsoft Project Server OLAP cube staging tables (table names beginning with "MSP_CUBE"):

     osql -S server_name -U account_name -P password -d database_name -i Cubetbls.sql

   • To create the Microsoft Project Server stored procedures:

     osql -S server_name -U account_name -P password -d database_name -i Websps.sql

   • To create the Microsoft Project Server security views:

     osql -S server_name -U account_name -P password -d database_name -i Secviews.sql

   • To insert localized data into the Microsoft Project 2002 tables:
     
     

     osql -S server_name -U account_name -P password -d database_name -i Locdata.sql

     NOTE: This script is located in the folder that corresponds to the locale ID (LCID) for your language. The English version, for example, is located in the following folder:

     \Support\Database\1033

   • To insert the Enterprise Global and Enterprise Resources into the Microsoft Project 2002 tables:
     
     

     osql -S server_name -U account_name -P password -d database_name -i Eglobal.sql

     NOTE: This script is located in the folder that corresponds to the locale ID (LCID) for your language. The English version, for example, is located in the following folder:

     \Support\Database\1033

   • To convert localized data in the Microsoft Project Web Access tables:
     
     

     osql -S server_name -U account_name -P password -d database_name -i Upgdef.sql

     NOTE: This script is located in the folder that corresponds to the locale ID (LCID) for your language. The English version, for example, is located in the following folder:

     \Support\Database\1033

   • To insert language pack data into the Microsoft Project Web Access tables:
     
     

     osql -S server_name -U account_name -P password -d database_name -i Insdeflp.sql

     NOTE: This script is located in the folder that corresponds to the locale ID (LCID) for your language. The English version, for example, is located in the following folder:

     \Support\Database\1033

     If you install a localized version of Microsoft Project Server, run the English version of this script after you run the version that is specific to your language.
   • To map Microsoft Project Central user roles to groups in Microsoft Project Server:

     osql -S server_name -U account_name -P password -d database_name -i Upgwsec.sql

7. For Microsoft Internet Information Server to have access to the Microsoft Project Server database, create a SQL Server user account for it (or have an existing Integrated Windows authentication trusted account), grant it access permission to the database, and assign it the MSProjectServerRole role.
8. For Microsoft Project Professional to have access to the Microsoft Project Server database, create a SQL Server user account for it, grant it access permission to the database, and assign it the MSProjectRole role.
9. Run the Microsoft Project Server Setup program, and then click Custom.
   
   On the database connection page of the Setup program, click Connect to an existing database, and then enter the requested information for the database that you updated.

NOTE: Using the OSQL tool is required because the lines in some of the scripts are too long for Query Analyzer. The OSQL tool is located in the following folder: back to the top