We are going to be upgrading our SQL servers housing the UIM database to SQL 2019 on new servers. I am going to be working with the DBAs to ensure UIM has the least outages as possible and I need guidance on if there are any specific instructions we need to follow and pitfalls we need to watch out for when we do this.
Environment
Release: 20.4
Database: MS SQL Server 2019
Cause
Guidance
Resolution
Review the DX UIM Component Support Matrix to ensure compatibility.
Verify that the database version you want to upgrade to is supported
Deactivate the data_engine on both the Primary and HA server (if you have an HA failover hub).
Backup the database via standard backup or take a VM SNAPSHOT
Upgrade the database
Apply the latest DB vendor-recommended DB service pack/patches
Re-activate the data_engine probe as needed on the Primary then the HA server after the Primary is back up
Additional Information
If youre using a DB cluster, if possible, keep the server cluster naming convention the same on the new servers as the current servers and make sure that the new cluster FQDN and port remains the same as well.
Provider and data_engine TLS option
The latest provider MSOLEDBSQL may also be used successfully withe the TLS option enabled in the data_engine.