Before proceeding with the sync setup, choose one of the following:
- Initial Sync
- Incremental Sync after Dump Restoration
Initial sync is recommended for only small databases where number of projects is less than 100. Otherwise, choose incremental sync after database dump restoration.
Initial Sync Prerequisites
Complete the following prerequisites:
- Create a P6 database (source) with data on an Oracle 12c database instance.
- Enable full auditing in the P6 source database by calling the following procedure: exec auditing_enable(null,3);
- Set JAVA_HOME to the supported version. For more details, see the Client Requirements document.
Incremental Sync after Database Dump Restoration
Complete the following prerequisites:
- A P6 database (source) with data created on an Oracle 12c database instance.
- Enable full auditing in the P6 (source) database by calling the following procedure: exec auditing_enable(null,3);
- Export the P6 database (including all users) from p6 source database and note down the database export timestamp.
- Share the P6 database dump file to on-premise environment.
- Full auditing enabled in the P6 source database by calling the following procedure: exec auditing_enable(null,3);
- Set JAVA_HOME to the supported version. For more details, see the Client Requirements document.