SQLite is the default database type for a P6 Professional standalone database.
Why SQLite?
- Prior to R8.4, P6 Professional standalone accessed a locally installed Oracle XE database. Due to the complexity of Oracle XE software and issues associated with it, an embedded SQLite database is available as an alternative data store for P6 Professional standalone version.
What are the advantages of SQLite?
- No separate install of Database Management Software (DBMS) is required. The SQLite DBMS is embedded in the P6 Professional application.
- With embedded SQLite database as the data store, a standalone install becomes a true single-user system.
- Data is stored in a single file on the client workstation’s disk, so you can easily share the entire database with a colleague.
- The SQLite Database size can grow as needed. It is limited only by available disk space and the file size limitation of your filesystem. (See
https://www.sqlite.org/limits.html.) Tests verify that SQLite behaves correctly when a database reaches the maximum file size of the underlying filesystem (which is usually much less than the maximum theoretical database size) and when a database is unable to grow due to disk space exhaustion.
What are the disadvantages of SQLite?
- P6 Professional (SQLite) databases cannot be used for a workgroup.
- Update Baseline and features on the advanced tab of XML Import are not currently available on SQLite. Additionally Primavera Risk Analysis integration or other integrations that use the P6 Professional API are not supported.
Should I continue using Oracle XE as my standalone database or use SQLite?
Use P6 Professional (SQLite) standalone DB if:
- You are looking for the simplest way to have a standalone Primavera P6 database.
- You are not allowed to install programs outside of the Windows Program Files folder.
- You want to be able to copy the entire database as a single file to share with colleagues.
Use Oracle XE standalone database if:
- You need to run Update Baseline and features on the advanced tab of XML Import.
- You need integration with Primavera Risk Analysis.
- You prefer to use Oracle XE.
How do I upgrade my existing standalone database to the current schema?
The Standalone Upgrade Utility upgrades the schema for an existing P6 Professional database with Oracle XE or Microsoft SQL Server 2005 Express Edition SP3. During installation, you can install the Standalone Upgrade Utility, which you can run at any time. See Running the Standalone Upgrade Utility for details.
How do I migrate my existing standalone database to SQLite?
After upgrading the schema, you can use the Standalone Database Migration Tool to migrate an existing P6 Professional database from Oracle XE or Microsoft SQL Server 2005 Express Edition SP3 to SQLite. The Standalone Database Migration Tool is installed along with P6 Professional and you can run it at any time. See Running the Standalone Database Migration Tool for details.
What happens when I migrate my Oracle XE database to SQLite?
- A new database is added as a single file on your hard disk.
- A connection is made to the new P6 Professional (SQLite) database.
- Your existing Oracle XE database remains available.
I did not upgrade my schema or migrate my database immediately after running the Installation Wizard. Can I still upgrade and migrate my existing standalone database?
You can run the Standalone Upgrade Utility or the Standalone Database Migration Tool to upgrade or migrate your database at any time.
Note: The Standalone Upgrade Utility is not installed by default. If you did not install it, rerun the P6 Professional Installation Wizard. See Upgrading with an Oracle XE or Microsoft SQL Express Database for details.
What do I do if I need to run Update Baseline, advanced features of XML Import, or Primavera Risk Analysis on my standalone database?
These features are not supported by the P6 Professional (SQLite) database. They continue to be supported on Oracle XE and Microsoft SQL Server 2005 Express Edition SP3 databases.
I previously installed Oracle XE database management software. How do I install SQLite database management software?
SQLite is built into P6 Professional. By installing P6 Professional 8.4 or higher, you have the ability to create or attach to a P6 Professional (SQLite) database. A separate install of SQLite software is not needed.
I have migrated to SQLite and do not need my Oracle XE database. Do I need to uninstall Oracle XE?
Oracle XE software is not removed automatically. You can use Windows Programs and Features to uninstall Oracle XE software.
Can I share my new SQLite database with my workgroup?
P6 Professional (SQLite) databases are true single-user databases that cannot be used for a workgroup.
Can I create more than one SQLite database?
Yes, each SQLite database is fully independent and exists in a different file on your computer’s disk drive.
I have a P6 Professional 7.x database. How do I migrate it to SQLite?
Upgrade your P6 Professional application and database from P6 Professional 7.0.3 to P6 Professional 8.4.0 with an existing Oracle XE database. Then run the P6 Professional Standalone Database Migration Tool to migrate data from your Oracle XE database to SQLite.