You can manually run the SQL upgrade scripts. To manually upgrade the Insight, Insight_Archive, and 2020 Construct databases, run and/or apply a series of scripts to those databases from the distribution media.
WARNING: You must upgrade the databases in the order indicated by the SQL Modifications\Upgrade folder names:
Each upgrade folder contains subfolders whose names indicate the order in which they should be executed. The following table summarizes the purpose of the scripts and indicates the tool to be used to execute the scripts.
| Script Folder | Description of Scripts | Tool |
|---|---|---|
| 01 PreUpgrade | Detect problematic data that might not allow you to complete the database upgrade. | MS SQL Server Management Studio |
| 02 Upgrade Scripts (MS) | Upgrade the database. | MS SQL Server Management Studio |
| 03 Upgrade Scripts | Upgrade the database. | InSightInstaller.exe |
| 04 Upgrade SQL Objects | Upgrade SQL objects in the database. | InSightInstaller.exe |
| 05 PostUpgrade | Perform necessary post-upgrade modifications. | InSightInstaller.exe |
| (optional) | Apply these scripts if instructed by your Cyncly Project Manager. | MS SQL Server Management Studio |
After you update the Insight_Archive database, repeat the following steps for the Insight database and other databases that you use.
- Run 01 PreUpgrade Scripts
- Run 02 Upgrade Scripts
- Run 03 Upgrade Scripts
- Run 04 Upgrade SQL Objects Scripts
- Run 05 PostUpgrade Scripts
- Run Optional Scripts
TIP: After completing all upgrade scripts, back up the database.