Manual update of the VTS SQL database

This page describes how to manually update the VTS database to a newer version. These instructions apply only if you want to update to a VTS version that do not use the included Microsoft® SQL Server Express version. For such installations, the update cannot be performed by the setup program and must be completed manually.

Prerequisites

The required update scripts are available. These can be found in the installation files in the Scripts folder.
If you are using a VTS version older than 8.25.00, the password for the SQL login wtsnx must be changed. Please contact our Support for assistance.

1. Update Sentinel runtime

Update Sentinel Run-time to version 10.21.186893.1 via Safenet_Dongle_Driver_Setup.exe located in content folder.

Additional step for updates from VTS version 8.23 and earlier

Execute the following tool:
- CandidateDecryptionTool.exe located in Tools\CandidateDecryptionTool
- For details see Manual decryption of person data

2. Update the VTS database

The scripts are located in the installation files under Scripts\Update Installation.

v10.X.X stands for the corresponding VTS version. If you install VTS 10.00, for example, the scripts are labeled v10.0.0.

Run the following scripts in the exact order listed below and follow the instructions provided for executing the scripts.

wts_1_update_schema_v10.X.X.sql
wts_2_update_data_v10.X.X.sql
wts_3_optimize_database_v10.X.X.sql
wts_4_updateCompatiblityLevel_v10.X.X.sql

Notes on executing the scripts

All scripts can be executed in Microsoft^® SQL Server Management Studio.

3. Update the DTC database

This step is only necessary if you are installing a VTS version 8.30 or earlier and only if you are updating from a VTS version that uses a DTC database. From VTS version 10.00 onwards, the DTC database is no longer necessary.

The DTC database should be deleted after running the setup successfully.

Execute the script dtc_1_update_schema_v10.X.X.sql.
Execute the script dtc_2_migrate_to_wts_v10.X.X.sql.