Creating New Databases

After starting the GENESIS Configure System utility and setting up the SQL server options, you need to set up the databases. If the wizard does not detect any existing databases saved on the selected SQL Server, you need to create a new project database and select the settings for storing server configurations of all installed GENESIS components that use databases.

We recommend creating a unified database. It is a single database that stores all the configurations together. This option grants the best compatibility since many servers require their configurations to be stored in the same database. However, advanced users can create a separate database for each configuration.

To create a new project database on a clean GENESIS installation:

  1. In the Project Settings section of the Configure System utility in the Project database text field, enter the database name. We recommend using the default name IcoSetup.

  2. (Optional) Click next to the database name field to open the database file and log settings dialog.

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

  4. In the New Project Settings section, select one of the following options for the server configuration database, and then click Next.

    • Use a new unified database Learn more
    • (For advanced users) Create each configuration in its own database. Learn more