Update the SQL Server Database Schema - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external

Brainware Intelligent Capture Update

Brainware Intelligent Capture
Foundation 23.1

Note: After the update, you cannot revert the database schema to an older version.

To update the database schema, complete the following steps.

  1. Launch the SQL Server Management Studio.
  2. Log on using an account with administrator rights.
  3. From the [drive:]\[setup directory]\FirstPart\Database\UpdateScripts\SQL Server directory, execute the BRW_Upgrade_Database.sql script against the BIC database.
  4. Review the Messages pane for errors.
    Note: If there are errors, you can rerun the script as often as required.
  5. In addition, when upgrading from version EP2 or earlier, complete the following steps.
    1. Clear the plan cache.
    2. Rebuild all indexes.