Skip to main content

SQL Server Required Components

The following lists the required components needed to install and run SQL Server as the Code Insight database:

  • SQL Server 2019 (recommended for best performance), SQL Server 2022, or 2016 Sp2.

  • The JDBC driver file, mssql-jdbc-6.4.0.jre8.jar, which enables Code Insight to connect to your SQL Server database. Download this driver from https://go.microsoft.com/fwlink/?linkid=2122537​ and store in a location accessible to the Code Insight installer.

    During installation, the installer will copy the downloaded driver to the tomcat/lib folder, where it must reside for use by Code Insight.

  • The package sql_server_pre_install_scripts.zip containing the scripts needed to set up the SQL Server database for Code Insight. See Downloading the Scripts Needed to Set Up the SQL Server Database for instructions on the download process.

  • At least one disk (OS or non-OS) with 100 GB free space.

Downloading the Scripts Needed to Set Up the SQL Server Database​

Use the following steps to download the package containing the script files needed to set up the SQL Server database for Code Insight.

To download the package containing the scripts, do the following:

  1. Log into the Customer Community page of the Revenera website:

    https://community.flexera.com/t5/Revenera-Community/ct-p/Revenera_Community

  2. From the Other Resources menu, select the Product and License Center option.

    note

    This option is available only if you are a Product and License Center user or administrator. See Revenera Support for obtaining appropriate Product and License Center permissions.

  3. From the Product and License Center page, select Downloads; and, from the list of available downloads, select Code Insight. (Alternatively, you might be able to select Code Insight directly from the My Downloads list on the Product and License Center page.)

  4. Select the version of Code Insight from the list. The Downloads page appears.

  5. Click the sql_server_pre_install_scripts.zip link to download the SQL Server scripts.

  6. When the download finishes, extract the following files to a location accessible for later execution using the SQL Server console, as described in Setting Up the SQL Server Database:

    • codeinsight_serversettings.sql
    • codeinsight_db_creation_with_maintainenceplan.sql

A third script, codeinsight_db_drop_with_maintainenceplan.sql, is used to drop the database and is not used as part of the database setup. Instructions for dropping the database are found in Dropping the SQL Server Database.