Forum Sponsor:

An innovation in P6 Professional training from RPCuk in partnership with Oracle. All the topics that matter to you in workshops customised to your role and industry.  Now get superior training value when you book our Blended Learning Bundle. Learn more here.

Viewer for .xer, xml and xls schedule files Schedule Reader™Free Trial

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Restore P6 Pro Standalone (SQLite)

4 replies [Last post]
Rana Ahmad Raza
User offline. Last seen 44 weeks 11 hours ago. Offline
Joined: 29 Dec 2015
Posts: 2
Groups: None

Dear Members,

I've P-6 file name as "PPMDBSQLite". This is only file as primavera database of all my projects. I want to access them on another PC. Could I access them? What should be the way to upload?

I'm worried about this because this is only backup file, I've from my previous computer. I need this because all projects are in this.

Your comments/suggestions / solutions will be appreciated.



Zoltan Palffy
User offline. Last seen 9 hours 52 min ago. Offline
Joined: 13 Jul 2009
Posts: 2433
Groups: None

Steven you are correct MSSQLthanks for catching this 

Steven Auld
User offline. Last seen 1 week 2 days ago. Offline
Joined: 13 Sep 2017
Posts: 106
For SQLite, Santosh is correct - find the file on your computer, copy to either a network drive or USB stick etc.
On the new location, when you open the login page, select add to add the new database, you can now select the existing database from there.
Make sure you select SQLite as database type.
The process Zoltan refers to is for MSSQL installations not SQLite.
Zoltan Palffy
User offline. Last seen 9 hours 52 min ago. Offline
Joined: 13 Jul 2009
Posts: 2433
Groups: None

you can go into MSSQL and select backup and back it up to a thumb drive or somewhere and then on the new computer go into MSSQL and select restore and restore the database 

Santosh Bhat
User offline. Last seen 10 hours 8 min ago. Offline
Joined: 15 Apr 2005
Posts: 215

As its SQLite , that single file, is an entire P6 database. You can copy and rename it and you've replicated your entire database. If you want to move it to another PC, simply copy it and then point your new P6 client to the copied SQLite file.