P6 Primavera V16.2

Tahir 

is it a ms sql database

give me your email adress and I will email instructions

1) Backup your P6 database

a) Log as SA into your Servername in SQL Server Management Studio

b) Expand database folder

c) Select your database --> Right-click on your database --> Tasks --> Backup

d) Choose your database, backup type, backup component and destination in General page

e) Click OK

2) Add the users manually in your new SQL Server

a) Expand Security Folder --> Right-click on Logins folder --> New Login

b) Add a new user pubuser in General page

c) Choose SQL Server Authentication

d) Type and confirm a password for pubuser

e) Uncheck Enforce password policy

f) Uncheck Enforce password expiration

g) Uncheck User must change password at next login

h) Click OK

i) Expand Security Folder --> Right-click on Logins folder --> New Login

j) Add a new user privuser in General page

k) Choose SQL Server Authentication

l) Type and confirm a password for privuser

m) Uncheck Enforce password policy

n) Uncheck Enforce password expiration

o) Uncheck User must change password at next login

p) Click OK

3) Restore your P6 database in your new SQL Server

a) Log as SA into your Servername in SQL Server Management Studio

b) Right-click on databases folder --> Restore a Database

c) Type the name of the database that you want to import in textbox To Database

d) Select From device --> Click on ellipsis button --> Add --> Browse your backup file

e) Check Restore checkbox of your backup.

4) As SA in SQL Server Management Studio, run sync script for all users

Good day All,

I want to transfer P6 database from one laptop to another new laptop, both are standalone installations. Exporting xer would take time and effort in recreating the WBS & OBS structures alongwith other settings.  Its SQL db

Any Idea ?

Robert, Primavera bar styles are essentially thin or thinner. It doesn't have much flexibility in presentation. I've actually used the product that I've developed Turbo-Chart to be abel to produce Gantt style charts from P6 data, and you can effectively set bars to be as thick as you like. It does require some creativity and discipline in applying codes/UDF values into P6 however, its explained here:  https://www.turbo-chart.com/turbo-chart-gantt-charts/

right click in the bar area and select bars 

got to the Bar Style and select the widest bar

I think it is not possible to set bar height in P6.

the workaround is to use 2 bars for each activity