Installing Sample Data and Creating Your P6 Admin Superuser Password for Microsoft SQL Server
Microsoft SQL Server Database Manual Configuration Overview > Creating the Database Structure for Microsoft SQL Server and Loading Application Data > Creating the P6 EPPM Database Structure for Microsoft SQL Server
To install sample data:
- 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.
- 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:
instancewhere 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:
instancewhere 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).
- Use this command if you want to load sample data.
- 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
Last Published Thursday, October 31, 2024