You can update the Microsoft Project Central database when you install Microsoft Project Server. This article explains how to upgrade the database.
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.
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:
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.
(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.
Insert the Microsoft Project Server CD into the CD-ROM or DVD-ROM drive, or connect to a network installation point.
From a command prompt, access the CD-ROM drive or network installation point, and then open the following folder:
Type the following command to convert the Microsoft Project Central database for use by Microsoft Project Server
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.
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.
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: