P6-Migrator SQLite and Oracle - Importing and Exporting

Emerald’s P6-Migrator SQLite and Oracle allows you to export files from your Primavera P6 database, including SQLite databases, and then import those files into a P6 online or local database, cutting out the struggle of manually exporting and cleaning up each file before manually importing them into your database.

This tool has three modules:

Export: This module can be used to export all projects from a P6 database. It lists the projects from the database, lets you pick the ones you need, and then invokes P6 on each project to have the XER generated.

Scrub: This module lets you scrub all XER/XML files in a given folder according to a previously saved P6-Scrubber definition. As the files are processed, they are moved into a success/failure folder, and the P6-Scrubber generated files are placed into an output folder.

Import: This module can be used to import XER/XML-type files from a given folder into a P6 database. This database can be any type that is supported by the P6 client.

All values entered in the parameters here are remembered automatically by the tool.

Export Module

P6 App: The location of the Primavera.CacheService.exe of the P6 program that will be used to export the files. You can find this from the shortcut itself.
P6 Database Alias: The name of the database you are exporting the XERs from.
P6 Username: Database username.
P6 Password: Database password.
P6 Connection: Window to set up the export database.

When the Load button is clicked, the files eligible for export will be displayed. Select the files to export, then click the Run button. Once the files have been exported, the message “Finished project export” will appear in the dialog box.



The generated files appear in the designated Export folder.

Scrubber Module

Scrubber URL: The URL for the P6-Scrubber application.
Scrubber Secret: The password for Module to access P6-Scrubber.
Scrubber Profile: The P6-Scrubber definition already set up in P6-Scrubber.
Input folder: The location of the files to be scrubbed.
Base Output Folder: Where to put the scrubbed files.

Once the parameters are set, click the Run button and the files will be scrubbed.



The scrubbed files will be placed in the output folder created in the designated folder. Both the clean files and a report about what was handled by P6-Scrubber will be created in this folder.

Import Module

P6 App: The location of the Primavera.CacheService.exe of the P6 program that will be used to import the files. You can find this from the shortcut itself.
P6 App Parameters: With older versions of P6, you will sometimes need to set up extra parameters.
Database Alias: Alias for the P6 database you are importing to.
P6 Username: Database username.
P6 Password: Database password.
Import EPS Id: The EPS ID for the projects to land in when they are imported - this must be set up prior to running the tool.
Import Folder: Folder where the Import Module will find the files to import.
Options: When importing the file, there are three options to select from, depending on where you want the project to be imported to in your database.

When it is done importing (which may take a while), it will display a ‘Finished project import’ message.



When completed, the imported projects will appear in the P6 database.



Although it may take a while to run each module, this is not nearly as labor-intensive as manually exporting, scrubbing, and then importing each file from one database to another. Once the module has been started, the user can do other tasks while the module runs.