Creating a New Project Database

After starting the system configuration wizard and setting up the SQL server options, you can set up the databases.

If you do not want to use any existing database that the system configuration wizard detects on the selected SQL Server, you can create a new project database. Then you need to select the settings for storing server configurations of all installed GENESIS components that use databases.

We recommend using a unified database, either new or existing. 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 set up GENESIS with a new project database:

  1. In the Project Settings dialog of the system configuration wizard, select Use a new project database and enter the database name in the text field. We recommend using the default name IcoSetup.

    If a database with the same name already exists, it will be overwritten.

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

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

  3. In the New Project Settings section, select one of the following options for the server configuration database.