In Primavera P6 versions lower than Primavera P6 v8.4 you need to export a xer file so that you can have a backup for your schedule. If you have many schedules to need to export as many schedules in xer file for you to be able to transfer all those schedules to another computer.
But in Primavera P6 higher than v8.3, you can just copy the standalone sqlite database to have a backup of all you schedules or you can transfer all you schedules to another computer by just copying the database file even without exporting a single xer file.
Setting-up a New Database in Primavera P6 v8.4
So in creating a database in Primavera P6 higher than v8.3, your job would be easier if you use sqlite database instead of mysql or oracle. In the login menu click the browse database the click add. Then database configuration appears, choose sqlite see the picture below. For new database choose add an new and standalone database and connection in the next dialog box.
Copying Database Backup in Primavera P6 v.8.4
Sqlite database is a standalone database so you can just copy it and transfer to another computer just like copying and transfering a simple document file without hassle.You just have to know where the database file is located so that you can copy that database and paste it to a backup folder in your computer, your external drive, or to another computer. At the login dialog box, click the browse button.
Then see the details below and you will see the location of your database. You can open your folders explorer to find that particular database and copy it so that you can paste it somewhere else.
After pasting it to another location in you computer, you can add that copied database to include in you Primavera P6 accessible database. At the login box, click the add button and select driver type sqlite and choose connection to existing database, then browse the location the database. You will now see the additional database in you Primavera P6. Highlight the database you want to use and click select.