Installing Sample Data and Creating Your P6 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:pmdb_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 EPPM database.

      rundataloader.bat sample:pmdb_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 EPPM Database Structure for Microsoft SQL Server

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

Creating the Database for Microsoft SQL Server

Creating Users and Tables for Microsoft SQL Server

Creating Remaining Database Objects for Microsoft SQL Server



Legal Notices | Your Privacy Rights
Copyright © 1999, 2021

Last Published Tuesday, December 7, 2021