Creating a New Unified Database

After creating a new project database in the GENESIS system configuration wizard, 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 project settings dialog of the system configuration wizard in the New Project Settings section, select Use a new unified database.

  2. Enter the database name in the text field. 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. Click next to the database name field to customize the database file and log settings, and then click Next.

    • 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.

  4. (Optional) In the Configuration Settings section, select or clear the checkboxes to set your preferences for upgrading or overwriting (the default setting) the existing 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, clear the Overwrite checkbox, and then select the Upgrade checkbox for each configuration type that you want to keep.

  6. (Optional) Set the preferences for individual configurations in the Samples column.
  7. 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.
  8. 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.
  9. Click Configure. When the configuration process finishes, the system configuration wizard automatically closes, and Workbench opens if installed.