Upgrade the Historian version (Microsoft SQL Server 32-bit)

Beginning with Historian 2020, only 64-bit versions of Microsoft SQL Server are supported. If your existing databases are hosted on a 32-bit version of Microsoft SQL Server, you must migrate them to a 64-bit version.

To upgrade the Historian when using 32-bit Microsoft SQL Server:

1. Shut down and disable the Historian using the Operations Control Management Console. Any remote IDAS nodes will go into store-and-forward mode.

2. Back up the Runtime, Holding, and A2ALMDB databases.

3. Uninstall the 32-bit version of Microsoft SQL Server.

4. Install a supported 64-bit version of Microsoft SQL Server that is compatible with your database backups.

5. Restore the Runtime, Holding, and A2ALMDB databases.

6. Run the System Platform installation program to perform the upgrade. For more information, see Upgrading the Wonderware System Platform.

7. In the configurator, configure 'Server' without selecting the 'Drop and Create' option. Provide the correct path to the data files for the restored databases. For example, C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA.

8. Configure the remaining components, if not already configured.

9. Start the Historian. The Historian will start acquiring and storing the store-and-forward data from the existing remote IDASs.

10. After the Historian Server node is upgraded, you can upgrade any remote IDAS nodes.