Updating the database

Notes on database updates

Perform the following activities to update the Callback database after an upgrade.

Running database upgrade scripts

Navigate to C:\Program Files (x86)\Virtual Hold Technology\SQL Server Database Installation Scripts) and execute the following scripts:

  • VHT_Config
  • VHT_Config_Inserts
  • VHT_RPT
  • VHT_RPT_Inserts
  • (Optional) VHT_Audit_Create_Tables

If the VHT_Config scripts fail to run when upgrading to VHT Callback version 8.10.1 or later, check the QueueGroups table for a site name record that does not exist in the SiteNameDesc table.

(Optional) VHT_Audit_Create_Tables

If you set up user audit logging on a pre-8.2 version of VHT Callback software, and you upgrade to a newer version, you must also run the VHT_Audit_Create_Tables.sql script after upgrading.

The following scripts are optional and only need to be run if you plan to audit and report user activity in the Launchpad application:

  • VHT_Audit_Create_Connection.sql, VHT_Audit_Create_Tables.sql, and VHT_Audit_Report_Query_Example.sql

The following scripts are optional and only need to be run if you are working with Support to implement the Monthly License Utilization custom report:

  • VHT_RPT_Utilization_CreateTableAndJob.sql, VHT_RPT_Utilization_PopulateTable.sql

Setting Outreach extensions

If upgrading to On-Premise Callback version 8.11.0 or later and using the Outreach application, the Outreach extensions must be updated to use Treatment Type 20 in the database.