This article is meant to provide more information regarding the OPC DA import method "Legacy WIN-911 SQL Database Import" introduced in WIN-911 2021 R5.
IMPORTANT: This import option only applies to those that had/have a previous version of WIN-911 (i.e. V4.x.x or 2021 R1, R2, R3, R4) and have upgraded to 2021 R5 (or later) and wish to import data from the existing older WIN-911 OPC DA database.
The SQL Server Name should appear in the form of Computername\WIN911.
There are two choices for Authenticating to the SQL instance - Current User (default) or Specify SQL User.
If the previous version of WIN-911 was on the local machine, then running Workspace as either the installing user or the WIN-911 service account should permit the 'Current User' option to connect.
If you need to connect to the SQL Server as a different user (as in the case that the SQL Server was relocated, or If the previous version of the WIN-911 database was created by a different user), then select 'Specify SQL User' and enter the username and password for the SQL Server Login (such as the previous WIN-911 service account).
Use the drop-down menu to select the Database Name from which the Items and Alarms are to be imported. The database name will be in the form of “ComputerName”-911.Default.OPCDA.
View of databases In SQL Server Management Studio:
Select the Test Connection button to attempt a connection to the SQL server using your settings.
Upon a successful connection test select Next to advance.
You will see a new screen with information on selecting either "Boolean" or to import items as "No Alarm"
“Digital (aka Discrete) Alarm” conditions from previous versions can be imported as Boolean alarm conditions. Other alarm conditions cannot. Non-Digital Items can be imported but the associated alarm conditions will be ignored and must be manually configured afterward.
Select Next to advance.
All available Items should appear in the “Items and Alarms to Import” table. Selection tools appear in the center column for moving one or several items from one table to the next. The table can be sorted using the column headers and Search bar. Once the desired items are present on the right side of the page select the Import button at the bottom of the page.
IMPORTANT: There is a known issue if your previous WIN-911 system is coming from a SQL 2014 instance.
If you try to import from a SQL 2014 database, you may see the following error:
"OPC import fails with error: 'STRING_AGG' is not a recognized built-in function name."
Older versions of WIN-911 (3.19.X and earlier) shipped with SQL 2014; STRING_AGG was added in SQL 2017.
Since the SQL import for OPC was introduced in WIN-911 2021R5, SQL 2017 is now the minimum supported version of SQL for the 2021 R5 release.
Installs of WIN-911 2021 R5 targeting SQL 2014 will otherwise function, but attempts to import OPC configurations from SQL will result in the error shown above.
Running Microsoft's installer for SQL 2017 or 2019 provides an option to upgrade to a supported SQL Server and enable OPC import functionality as well.