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

To install sample data:

  1. Open a command prompt and change your directory to the location of the rundataloader.bat file, which is on the root of the database folder by default.
  2. Run a statement similar to one of the following.
    • Use this command if you want to load sample data.

      rundataloader.bat sample:ppmdb_mk.zip
      sa@sqlserver:host:port:instance

      where sa is the administrator for the system database,

      host is the server machine name or IP address where Microsoft SQL Server is installed,

      sa is the system administrator or database user,

      port is the port number that Microsoft SQL Server is using (the default is 1433), and

      instance is the database name (for example, PMDB).

    • Use this command if you do not want to load sample data. Empty data is loaded in a secure state and includes only the most basic information needed to run the P6 Professional database.

      rundataloader.bat sample:ppmdb_mk_empty.zip
      sa@sqlserver:host:port:instance

      where sa is the administrator for the system database,

      host is the server machine name or IP address where Microsoft SQL Server is installed,

      port is the port number that Microsoft SQL Server is using (the default is 1433), and

      instance is the database name (for example, PMDB).

  3. In the Please select a password for the P6 'admin' SuperUser account prompt, enter or verify your superuser password.

Related Topics

Creating the P6 Professional Database Structure

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

Creating the Database

Creating Users and Tables

Creating Remaining P6 Professional Database Objects



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Friday, March 19, 2021