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.