SQL CLR for fuzzy rule analysis

Fuzzy rule analysis uses SQL CLR for calculating match score. You can configure IRC not to use SQL CLR.

Note: For fresh deployments, SQL CLR is in the disabled state. However, if you upgrade IRC from a version older than 10.1.5, SQL CLR is in the enabled state as the SQL CLR retains the status prior to the upgrade.

Disable SQL CLR

  • Execute script from [INSTALL_PATH]\BRPublisher\bin\db\Fuzzy_DisableSQLCLR.sqlon the IRC database.
    Note: When you disable the SQL CLR, the fuzzy rule analysis may take a longer time to complete.
Enable SQL CLR
Note: Ensure that the CLR integration is enabled for the SQL Server. For details, see https://docs.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling.
  • Execute script from [INSTALL_PATH]\BRPublisher\bin\db\Fuzzy_EnableSQLCLR.sql on the IRC database.