Office

    Project Professional 2003 Database Compatibility Scripts for Microsoft Project Server 2002

    Select Language:
    Downloads the database upgrade scripts required for users to be able to connect Microsoft Office Project Professional 2003 to the Microsoft Project Server 2002 database.
    • Version:

      1.0

      File Name:

      P11toP10-ENU.EXE

      Date Published:

      6/21/2004

      File Size:

      100 KB

        Due to the addition of new features in Microsoft Office Project Professional 2003, you cannot use Project Professional 2003 to save projects to an existing Microsoft Project Server 2002 installation without first making some minor modifications to the database schema. You can load and view projects from an unmodified Microsoft Project Server 2002 database in Project Professional 2003, but if you want to make changes or create new projects in Project Professional 2003 and save them back to Project Server 2002, you must download and run the four SQL scripts provided here. These scripts will add some additional fields to the database tables that are required by Project Professional 2003, but will be ignored by earlier versions, so users of Microsoft Project Professional 2002 or Microsoft Project Standard 2002 can continue to connect as normal to the upgraded Microsoft Project Server 2002 database.

        When attempting to open a project file stored on a Microsoft Project Server 2002 database, you may receive the following message:

        You are opening projects or resources from a Microsoft Project Server 2002 database that have not been upgraded to contain the additional fields required by the new features in Project Professional 2003. Until the database is upgraded, you will only be able to open projects and resources as read-only. If you want to save changes back to the Microsoft Project Server 2002 database, click Help for information about how to upgrade the database.

        If you click OK, the file stored in the Microsoft Project Server 2002 database will be opened in Project Professional 2003 in read-only mode.

        If you click Help, Microsoft Project Help opens to a page that indicates that in order to save projects to the Microsoft Project Server 2002 database by using Project Professional 2003, a Project Server administrator must first install SQL scripts that update the Microsoft Project Server 2002 database. Click the download the scripts link (this takes you to the Microsoft Download Center page for the database upgrade scripts).
    • Supported Operating System

      Windows Server 2003

        • This download works with the following Office applications:
          • Microsoft Office Project Server 2002
          • Microsoft Office Project Professional 2003
      • To install this download:

        1. Download the file by clicking the Download button (above) and saving the files to your hard disk.

        2. Run the UPGPRJDB.CMD program file using the instructions included in the download.


        Removal of this download: There is no uninstall feature for this download.
      • To install the database upgrade scripts:

        1. As a user who has administrative privileges to the Microsoft Project Server 2002 database, create a folder in which to place the downloaded scripts, and then download the scripts from the Microsoft Download Center and extract them to this folder.
        2. The extracted files should include:
          PROJSPS.sql
          SECVIEWS.sql
          UPGPRJ10.sql
          UPGPRJDB.cmd
        3. Open a command prompt, browse to the folder you created, and run the following command: UPGPRJDB.cmd sqlservername projectserverdatabase sa password
        4. After the scripts have been run, you should be able to save files to the Microsoft Project Server 2002 database using Microsoft Office Project Professional 2003.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    The power of Office. Everywhere. Learn more.
    The power of Office. Everywhere.
    Start your free month of Office 365 now.
    Learn more