MS SQL 2016 to 2019 migration with Policy Server Stores

Products

• SITEMINDER

Issue/Introduction

 

Running Policy Server, what is the procedure to migrate Microsoft SQL Server (MSSQL) 2016 to 2019?

 

Resolution

 

At first glance, as per documentation, depending for which component the Microsoft SQL Server is used for, refer to the documentation here:

Policy Store:

  How to Configure a Microsoft SQL Server/Microsoft Azure SQL Database Policy Store
  

Key Store:

  Store Key Information in Microsoft SQL Server/Microsoft Azure SQL Database
  

Session Store:

  Store Session Information in Microsoft SQL Server/Microsoft Azure SQL Database
  

Audit Store:

  Store Audit Logs in Microsoft SQL Server/Microsoft Azure SQL Database
  

User Store:

  Configure a Microsoft SQL Server Database Connection Over SSL
  

  Configure an SQL Server Data Source