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 utility 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, which 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 in a first-time GENESIS installation:
-
In the Project Settings section of the Configure System utility dialog, enter the database name in the Project database text box. We recommend using the default name IcoSetup.
-
(Optional) Click
next to the database name text box to open advanced database file and log settings.
View the advanced settings
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.SettingDescriptionInitial SizeThe space in megabytes initially allocated for the file.File GrowthThe file growth increment in megabytes or percentages after the file reaches its initial size.Maximum SizeThe limit for the file size in megabytes.Custom LocationSelection of a custom file and log location. The default location of the databases' files and logs isC:\Program Files\Microsoft SQLServer\MSSQL16.SQLEXPRESS\MSSQL\DATATo change the location, select the Custom Location checkbox in each section and clickto browse for the desired folder.
The checkbox in the Log Size section activates after you select the checkbox in the File Size section.
-
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