Creating the Database

To create the database:

  1. Log in to the server as the SA user.
  2. Open Microsoft SQL Server Management Studio. Go to \database\scripts\install\PPM_<release level> and run the ssppm_init_db.sql script. This script creates a database called PMDB. If you want to use a different database name, modify the line in the script as follows:

    set @DB_NAME='<database_name>'

    where <database_name> is the name for the database

    Notes:

    • Instead of running the ssppm_init_db.sql script, you can manually create a database named PMDB with a data file of 500 MB or more and a log file of 200 MB or more.
    • Do not use special characters in the database name, privileged user, or public user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
    • You can change the initial data file and log file sizes and increase or decrease these amounts depending on how much data you plan to store in the database. You can also select the Automatically Grow File option to specify that these values automatically increase based on need.

Related Topics

Creating the P6 Professional Database Structure

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

Creating Users and Tables

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

Creating Remaining P6 Professional Database Objects


Last Published Tuesday, December 12, 2023