Guidance on upgrading DX UIM SQL database to MS SQL Server 2019

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

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

1. Review the DX UIM Component Support Matrix to ensure compatibility.
2. Verify that the database version you want to upgrade to is supported
3. Deactivate the data_engine on both the Primary and HA server (if you have an HA failover hub).
4. Backup the database via standard backup or take a VM SNAPSHOT
5. Upgrade the database
6. Apply the latest DB vendor-recommended DB service pack/patches
7. 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.
• Please refer to: Microsoft SQL Server
  • Please review the section titled: "Configure the MS SQL Driver"