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, select Use a new unified database.

  2. Enter the database name in the 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 field to open the database file and log settings dialog.
  4. 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.

  5. Click Next.
  6. (Optional) 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.

    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.

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

  8. (Optional) In the Samples column, select the checkboxes for the configurations which you want to include sample data for. Clear all the other checkboxes.
  9. 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.

  10. 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?