Creating the Database for Microsoft SQL Server

Previous TopicNext TopicContents

To create the database:

  1. Register to the server as SA user.
  2. Open Microsoft SQL Server Management Studio. Go to \database\scripts\install\PM_<release_level> and execute the sspm_init_db.sql script. This script creates a database called PMDB. If you want to change it, you must modify the sspm_init_db.sql script.
  3. Open Microsoft SQL Server Management Studio. Go to \database\scripts\install\PPM_<release_level> and execute the ssppm_init_db.sql script. This script creates a database called PMDB. If you want to change it, you must modify the ssppm_init_db.sql script.

    Notes:

Related Topics

Creating the P6 EPPM Database Structure for Microsoft SQL Server

Copying the Script Files to a Local Drive for Microsoft SQL Server

Creating Users and Tables for Microsoft SQL Server

Installing Sample Data and Creating Your P6 Admin Superuser Password for Microsoft SQL Server

Creating Remaining Database Objects for Microsoft SQL Server



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

Last Published Wednesday, July 29, 2015

PDF Library