Creating a Standalone SQLite Database to Work Offline for Cloud

After you install or upgrade P6 Professional with ClickOnce, you can work offline in P6 Professional (that is, not connected to the P6 Professional Cloud Connect database) and then upload the changes to the P6 Professional Cloud Connect database. To do this, you must use dbconfig to create a P6 Professional Standalone SQLite database. dbconfig is included as part of a ClickOnce installation.

To use dbconfig to create a P6 Professional Standalone SQLite database, complete the following steps:

  1. Run dbconfig.exe as an Administrator from the command line. On the Select Driver Type dialog box, in the P6 Professional driver type field, select P6 Pro Standalone (SQLite).
  2. Click Next.
  3. Select Add a new standalone database and connection.
  4. Click Next.
  5. In the Enter new password field and the Confirm new password field, enter a password for the admin user.
  6. Click Next.
  7. Select Load sample data if you want to install sample projects.
  8. Click Next.
  9. When the Connection Successful message displays, click Finish to exit Database Configuration.

Last Published Thursday, October 12, 2023