Upgrading the P6 EPPM Microsoft SQL Server Database

Previous TopicNext TopicContents

To upgrade the P6 EPPM Microsoft SQL Server Database:

  1. If you haven't done so, download the Primavera P6 Enterprise Project Portfolio Management R<release_level> for <platform> folder and extract the contents.
  2. Go to the location of the extracted contents and locate the P6_R<release_level>\p6suite\database folder.

    Notes:

  3. Open Microsoft SQL Server Management Studio and log in as the SA user.
  4. Go to \scripts\install\PM_<release_level> and execute the sspm_create_plus_users.sql script.

    Notes:

  5. Go to scripts\common and execute the ss_disable_triggers.sql script.
  6. Go to \scripts\upgrade\PM_<release_level> on your local drive. Execute one of the following scripts:

    SSPM_p70sp1.sql, if upgrading from P6 version 7.0, 7.0 service pack 1, or 7.0 service pack 2

    SSPM_p70sp3.sql, if upgrading from P6 version 7.0 service pack 3

    SSPM_p70sp5.sql, if upgrading from P6 version 7.0 service pack 5

    SSPM_p80.sql, if upgrading from P6 version 8.0

    SSPM_p81.sql, if upgrading from P6 version 8.1

    SSPM_p81sp3.sql if upgrading from P6 version 8.1 service pack 3

    SSPM_p82.sql, if upgrading from P6 version 8.2

    SSPM_p82sp1.sql if upgrading from P6 version 8.2 service pack 1

    SSPM_p82sp2.sql if upgrading from P6 version 8.2 service pack 2

    SSPM_p82sp2f10.sql if upgrading from P6 version 8.2 service pack 2 Hotfix 10

    SSPM_p83.sql if upgrading from P6 version 8.3

    SSPM_p832.sql if upgrading from P6 version 8.3 service pack 2

    SSPM_p833.sql if upgrading from P6 version 8.3 service pack 3

    SSPM_p834.sql if upgrading from P6 version 8.3 service pack 4

    SSPM_p835.sql if upgrading from P6 version 8.3 service pack 5

    SSPM_p84.sql if upgrading from P6 version 8.4

    SSPM_p841.sql if upgrading from P6 versions 8.4 patch set 1

    SSPM_p843.sql if upgrading from P6 versions 8.4 patch set 3

  7. If you're using version SSPM_p70sp1.sql or later, skip to the next step.

    If you're using a version before SSPM_p70sp1.sql, go to \scripts\common and execute the ss_update_usereng.sql script to grant all users with P6 Professional module access rights to the Projects section in P6.

    Note: Prior to P6 version 7.0, users with Project Management module access also had rights to the Projects section in P6 Web Access. For security reasons, beginning with P6 version 7.0, P6 Professional module access only grants rights to log into the P6 Professional module.

  8. Go to \scripts\common and execute the ss_post_upgrade script.
  9. Go to \scripts\upgrade\PM_<release_level> and execute the sspm_grants.sql script.

    Note: If you changed the default user names, you must update the privuser, pubuser, and PxRptUser names in this script with your custom user names.

  10. Go to \scripts\upgrade\PM_<release_level> and execute the sspm_synonyms.sql script.

    Caution: The sspm_synonyms.sql script contains a table called PUBUSER, do not replace it if you have to change the pubuser user name.

    Note: If you changed the default user names, you must update the privuser, pubuser, and PxRptUser names in this script with your custom user names.

  11. Go to \scripts\source\PM_<release_level> and execute the sspm_src.plb script.

    Notes:

  12. Go to \scripts\install\PM_<release_level> and execute the sspm_database_version.sql and sspm_querylib.sql scripts.
  13. Go to \scripts\common and execute the ss_enable_constraints_triggers.sql script.
  14. Go to \scripts\install\PM_<release_level> and execute the sspm_init_bgjobs.sql script.
  15. Run the databaselogins.bat (on Windows) or databaselogins.sh (on Unix) to upgrade the encryption of privilege user passwords.
  16. Log into the P6 EPPM database as PxRptUser or use your custom PX reporting user name if you created one.
  17. Go to scripts\source\PM_<release_level> and execute the sspm_px_rpt_src.sql script.


Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library