Back

Topic

[KB853]Migration of The HDS Databases to PcVue 15

Tags: HDS, Migration

Upgrade issues
9 years ago
By RM
Options
Print
Applies to:

PcVue 11.2, 12 and 15
The basic content of this article may also be applicable to other versions of PcVue although the detail may vary.
Summary:

This article explains how to migrate HDS databases to PcVue 11.2, 12 or 15. For older versions, please refer to this article (Migration of the HDS Databases to PcVue 10.0)

Notes:

  • Backup your database before migrating it.
  • If you are using SQL native replications, save the jobs related to and deactivate them before migrating.
  • If you are usings triggers, save them and deactivate them before migrating.
Details:

With PcVue 11.2 and 12, HDS Database tables structures have changed:

Log Tables
Column Name Data Type n since PcVue 10 n since PcVue 11.2 n since PcVue 12
AssocLabel varchar(n) 12 255 255
EvtTitle varchar(n) 24 255 255
LogList varchar(n) 12 12 100
Trend Tables
Column Name Data Type n since PcVue 10 n since PcVue 11.2
AssocLabel varchar(n) 12 255

Updating tables structure and data is necessary, it starts automatically the first time you launch your project with PcVue 12 or 15 if you have HDS databases smaller than 10 GB.

Because table structure changes and re-indexation can take time, the migration of HDS databases is not done automatically at startup if they are larger than 10 GB. In this case, the HDS will refuse to start, and you will need to use a T-SQL migration script manually before using PcVue 12 or 15. The T-SQL script is supplied as part of the PcVue installation.

The script is located in PcVue Bin folder (Bin\UpgradeDatabase.SQL), you have to run it with the SQL Server Management Studio.

Please refer to the attached HDS migration document for detailed information about how to use the migration script.

Download attachments: HDS_Database_Migration_PcVue_12.pdf
 

Created on: 06 Dec 2016 Last update: 04 Sep 2024