Create an SQLite database from a template

Learn how to create an SQLite database based on a template in PLA 3.0.

Before you begin

You have created a database template. For details, see the Create database templates topic.

Procedure

To create an SQLite database from a template:
  1. In the Login dialog, select Tools > Database management.
  2. In the Manage database connection profiles dialog, select Add....
  3. In the Database connection management wizard, select the Standard mode option and select Next >.
  4. Select the Create new database option.
  5. If you want to make the new database shareable in your network, select the Database profile is available for all users on this computer option.
  6. From the Type drop-down list, select SQLite and select Next >.
  7. Enter the database connection parameters:
    Figure 1. Database connection parameters for an SQLite database
    1. The SQLite database is created in the directory displayed in the Value field. To select a different directory, select the field and use the ellipsis button (…) to navigate to the directory you want to use.
      Note: If you change the default directory, make sure the new directory is accessible by all users who should be able to connect to the database.
    2. In the Name text box, enter a name for the database connection profile and select Next >.
      When logging in to PLA 3.0, this name will be displayed in the Database drop-down list.
  8. Select Next >.
  9. Select the Custom template option and select […], navigate to the database template you want to use (the file type is .s3db), select it, and then select Open.
    Figure 2. Templates in Database connection management
  10. Select Next >.
  11. Enter the credentials that you want to use for the administrative account of the database and select Finish.
    Important: We recommend storing your database credentials in a secure location. You need them to manage the database and user accounts. We cannot recover your credentials because we do not have access to them.

Result

The following data is copied from the database template to the new database:

  • User roles, permissions, user groups and security contexts

  • Database policies

  • Documents and folders

  • Folder properties

Important: User accounts will not be copied to the new database.