Creating a New Unified Database

After creating a new project database in the GENESIS Configure System utility, you can create a new unified database to store the related server configurations.

A unified database stores server configurations of all installed GENESIS features that use databases.

To set up a new unified database:

  1. In the New Project Settings section of the Configure System utility dialog, select Use a new unified database.

  2. Enter the database name in the text box. We recommend using the default name, IcoUnifiedConfig.

    If a database with the same name already exists, it will be overwritten. In steps 5 and 6, you can select the parts of the data that you do not want to overwrite.

  3. (Optional) Click next to the database name text box to open advanced database file and log settings. When finished, click Next.

    Edit the File size and Log Size options as needed, and then click OK.
    You can set the following advanced preferences in both the File Size section and the Log Size section.
    Setting
    Description
    Initial Size
    The space in megabytes initially allocated for the file.
    File Growth
    The file growth increment in megabytes or percentages after the file reaches its initial size.
    Maximum Size
    The limit for the file size in megabytes.
    Custom Location
    Selection of a custom file and log location. The default location of the databases' files and logs is
    C:\Program Files\Microsoft SQLServer\MSSQL16.SQLEXPRESS\MSSQL\DATA
    To change the location, select the Custom Location checkbox in each section and click to browse for the desired folder.
    The checkbox in the Log Size section activates after you select the checkbox in the File Size section.

  4. (Optional) On the next screen in the Configuration Settings section, select or clear the checkboxes to set your preferences for upgrading or overwriting (the default setting) all configurations and for including sample data.

    Selecting Automatically upgrade all configurations saves any existing data and makes it compatible with the new version, while selecting Overwrite all configuration permanently deletes the data and creates a clean database. When neither checkbox is selected, the existing data is used as is and may not be compatible with the new version.

    Including sample data by selecting Include samples in all configurations can help you become 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, Upgrade, and Samples columns to customize the preferences from the previous step for individual configurations.

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

  7. On the next screen in the FrameWorX Connection Mode section, select either Normal Setup (the default option) or Secured Setup.

    For Secured Setup, select the desired option in the drop-down list.

    • Generate a new self-signed certificate: A self-signed certificate will be created during the configuration and used to secure the connection.

    • Select an installed certificate: In the Certificate text box that appears, select an existing certificate from the drop-down list.

    The HTTPS Hostname field displays the Fully Qualified Name specified in the selected certificate.

  8. In the Choose Setup Mode section, select one of the following options.

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

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

    • Select Do not create a security user to allow anyone to access Workbench and make changes to the GENESIS configuration.

  9. Click Configure to begin the configuration process. When successfully completed, the window automatically closes.

    If you have selected Normal Setup in the FrameWorX Connection Mode section, a message appears. Click Yes to confirm the action.

What's Next?