When importing from P6, what's the difference between the Database and File data source?

Which option should I use?

  • Greg Demchak
  • Aug 13 2015
  • FAQ
  • Sep 15, 2015

    Admin Response

    When you import a P6 file, you will presented with the following dialog asking you to choose which a Data Source: Database or File

    What's the difference?

    If you choose Database, Synchro will connect to your P6 Database via API, allowing you to choose which project to import. In order for this to work properly, you must have previously configured the P6 API.

    If you select File, this will allow you to import a P6 XML file directly into Synchro.

    Which option should I choose?

    Most users should use the File option. The major benefit of the File option is that it does not require the Synchro user to have a P6 license. There is no prior set-up necessary to import via a P6 XML file, as the API does not need to be installed .All you need is an XML file exported from P6. Another benefit is that for large schedules, importing and synchronising from P6 XML is typically faster than import/synchronising from a P6 database via the API.

    P6 XML can be imported, exported, and Synchronised From. P6 XML cannot be used for Synchronise To operations, ie, to update an existing schedule in P6. If you need this capability, you will need to exchange data via the API. A schedule that was initially imported via XML can later be Synchronised To P6 using the API. Data exchange can be performed using a mix of XML and API throughout the lifetime of the project if necessary.

    The Database option requires that the user have P6 installed locally or be able to log into P6 via a remote connection. The user must have a login and password for P6 and sufficient permissions in P6 to access the required data. The API must be installed locally and be set up correctly in Synchro Options.

  • Attach files