How to Migrate the LabVIEW DSC Database, NI Citadel, from a 32-bit to 64-bit SQL Database.

The LabVIEW Datalogging and Supervisory Control Module (LV DSC), version 2024 Q1 and later, ship with Microsoft SQL Server 2022, a 64-bit database. Earlier versions of LV DSC shipped with a 32-bit version of the SQL Server. Reasons for changing the version of SQL Server include:

• Microsoft ended support for 32-bit versions of SQL Server.
• The 64-bit versions of SQL Server resolve known security issues.

This tutorial describes the steps required to migrate Citadel databases from the 32-bit to a 64-bit SQL Server installation.

Scenario 1: A previous version of LabVIEW and LabVIEW DSC is installed.

1. Stop the NITaggerService.
2. Detach Database using NI MAX.
3. Backup ALL Database files (eg: location of default database, “C:\ProgramData\National Instruments\Tagger\database”)
4. Uninstall LabVIEW DSC (DSC & DSC RTS feeds), restart. 
5. Uninstall SQL Server. 
6. Install LabVIEW DSC 2024 Q1.
7. Copy the backed-up database files locally.
8. Using NI MAX, attach the databases (which is copied in step 7) 

Scenario 2: No prior version of LabVIEW DSC is installed, but a version of SQL Server is installed.

Ensure that none of your SQL Server instances are named "CITADEL". 

If any of your instances are named "CITADEL",

1. Create a backup of all the databases under this instance using SQL Server Management Studio (SSMS)
2. In order to delete the SQL Server instance, we recommend following the steps in this article - Uninstall an existing instance of SQL Server by Microsoft
3. Install LabVIEW DSC 2024 Q1
4. Create a new instance of "CITADEL"
5. In order to restore data from the backed-up database under the new instance, follow the steps in the article - Restore a SQL Server database by Microsoft 

Migrate LabVIEW DSC, SQL Citadel databases from a 32-bit to 64-bit installation of Microsoft Server SQL database.