Creating Separate Configuration Databases

After creating a new project database in the GENESIS system configuration wizard, you can create a separate configuration database for each installed GENESIS component that uses databases.

This is an advanced option that may require additional settings since many servers need their configurations to be stored in the same database.

To set up separate databases for each configuration:

  1. In the project settings dialog of the system configuration wizard in the New Project Settings section, select Create each configuration in its own database.

  2. (Optional) Select the Use a prefix for all databases checkbox and enter the desired prefix in the text field.

    The databases' names are assigned automatically and reflect the GENESIS component for which they were created. You can add the prefix to identify the project to which the databases belong.

  3. Click Next.

  4. (Optional) In the Configuration Settings section, select or clear the checkboxes to set your preferences for upgrading or overwriting all configurations and for including sample data.

    The Upgrade option saves any existing data and makes it compatible with the new version, while Overwrite permanently deletes the data and creates a clean database. We strongly recommend keeping one of the checkboxes selected. Including the samples can help you get familiar with GENESIS before you start working with your real data.

  5. (Optional) In the Available Configurations section, select or clear the checkboxes in the Overwrite and Upgrade columns for each configuration type to set the preferences for individual configurations.

  6. (Optional) In the Options column, click for each database (configuration type) to customize the database file and log settings.

    • In the File Size section, set the initial file size and file growth in megabytes or percentages, and optionally, the maximum size for the files.
    • In the Log Size section, set the initial log size and file growth in megabytes or percentages, and optionally, the maximum size for the logs.
    • To change the location of the data files and logs, select the Custom Location checkbox in each section, and then click the folder icon to browse for the new location.

      The default location for the files and logs of both databases is <SystemDrive>:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA.

    • Click OK to apply the changes and close the dialog.
  7. (Optional) Set the preferences for individual configurations in the Samples column.
  8. In the Run On Startup column, select or clear the checkboxes as needed to determine the services (point managers) to be started immediately after the Windows startup, and then click Next.
  9. In the Choose Setup Mode section, select either Create a security user or Do not create a security user. If you select Create a security user, specify the user account credentials in Username and Password. The user must have administrator privileges.
  10. Click Configure. When the configuration process finishes, the system configuration wizard automatically closes, and Workbench opens if installed.