Manual update of the VTS SQL database

This guide describes how to perform a manual update to a new version of the VTS database. This guide only applies if you want to update a VTS installation that does not use the provided Microsoft^® SQL Server Express version. For such VTS installations, the update cannot be performed by the setup program, but must be done manually instead.

Prerequisites

• You have the necessary scripts for the update. These can be found in the installation files in the Scripts folder.

• If you are using a VTS version older than VTS version 8.25.00, the password for the SQL login wtsnx be changed. Please contact our Support for assistance.

1. Update the VTS database

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

v8.X.X stands for the corresponding VTS version. If you install VTS 8.29, for example, the scripts are labeled v8.29.0.

Execute the following scripts one after the other in the exact order specified and observe the notes below on executing the scripts!

1. wts_1_update_schema_v8.X.X.sql

2. wts_2_update_data_v8.X.X.sql

3. wts_3_optimize_database_v8.X.X.sql

Notes on executing the scripts

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

2. Update the DTC database

• Execute the script dtc_1_update_schema_v8.X.X.sql.

If you are updating from a VTS version that did not yet use a DTC database, first create a DTC database. A description can be found on the page: Manual installation of the VTS SQL database (section 2).

3. Update the WTSKatalog database

This step is only necessary if you are installing with a VTS version 8.28 or earlier. From VTS version 8.29 onwards, this database is no longer necessary.

1. Delete the currently used WTSKatalog database and attach the current version of the WTSKatalog database.

   1. A description of how to attach the current WTS catalog database can be found on the page: Manual installation of the VTS SQL database (section 3).

   2. Note: If you are updating from a VTS version that did not yet use a VTS catalog database, it is sufficient to attach the current VTS catalog database for the update as described in point a).

2. Run the script productdb_1_update_schema_v8.X.X.sql