How to Create Primavera P6 EPPM Database Schemas in Microsoft Sql Server
In this section, I have explained how to create a Primavera P6 EPPM Database Schemas in Microsoft SQL Server.
Follow the links If you are interested in Microsoft SQL Server Installation
Related Articles
Microsoft SQL Server 2017 Developer Edition Installation
Microsoft SQL Server Management Studio 2017 Installation
Open Microsoft SQL server Ports in Firewall
Creating Primavera P6 EPPM schemas in MS SQL Server
Follow the instruction to Create p6 EPPM schemas. Assume you have downloaded the Primavera P6 software or installed the Primavera P6 Home in your computer
1. Go to your P6_Home\database folder and double click on the database.bat file
2. The Primavera database setup wizard will open on the screen like below
3. Input the MS SQL Server database details (The user SA is the admin super account in MS SQL Server Database. Please refer the Step 15 of MS SQL Server DB Installation)
4. Input database keystore if any or skip the details and click Next
5. Click Next
6. Input the PUBUSER, PRIVUSER AND PXRPTUSER password
7. Input Primavera P6 application administration username and password, Load/Unload the sample P6 database and select the currency for the database
8. Click Next once all are successful
9. Click Finish Once Done
10. Open the Microsoft SQL Server Management Studio >> Click Connect >> Input SA connection details >> Click Connect
11. You will notice the database PMDB under the database & PUBUSER, PRIVUSER, PXRTPTUSER under Security > Logins as like below
This post first appeared on Oracle ADF, BPM, BI And Primavera P6 Tutorials, please read the originial post: here
