Creating Separate Configuration Databases

After creating a new project database in the GENESIS Configure System utility, 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 (unified) database.

To set up separate databases for each configuration:

  1. In the project settings dialog of the Configure System utility 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, enter the desired prefix in the text field, and then click Next.

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

  3. (Optional) In the Configuration Settings section, select or clear the checkboxes to set your preferences for upgrading (the default setting) 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. When neither checkbox is selected, the existing data will be used as is and may not be compatible with the new version.

    Including the samples can help you become familiar with GENESIS before you start working with your real data.

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

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

  6. Edit the File size and Log Size options as needed, and then click OK.

    You can set the following advanced preferences:

    • In the File Size section, set the initial database file size, the file growth increment in megabytes or percentages, and optionally, the maximum size for the file.
    • In the Log Size section, set the initial log size, the file growth increment in megabytes or percentages, and optionally, the maximum size for the logs.

    • To change the location of the database file and log folder, select the Custom Location checkbox in each section and click to browse for the desired location. When you select the checkbox in the File Size section, it activates the checkbox in the Log Size section.

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

  7. (Optional) In the Samples column, select the checkboxes for the configurations which you want to include sample data for. Clear all the other checkboxes.

  8. In the Run On Startup column, select the checkboxes for the services (point managers) that you want to start when Windows starts up, and then click Next. Clear all the other checkboxes.

  9. In the Choose Setup Mode section, select one of the following options, and then click Configure.

    • Select Create a security user to create a user account with administrator privileges in Workbench that will be required to make changes to the system. In the GENESIS Security Credentials section that appears, specify the Username and Password.

      You can find the account in Workbench's Project Explorer under the Security > Users node.

    • Select Do not create a security user, which means that anyone can access Workbench and make changes to the GENESIS configuration.

What's Next?