Policy Server and Policy Store ODBC Database upgrade
search cancel

Policy Server and Policy Store ODBC Database upgrade

book

Article ID: 367057

calendar_today

Updated On:

Products

SITEMINDER

Issue/Introduction


After having upgraded the Policy Server to 12.8SP8, do the files under the folder siteminder/db/SQL have to be run and applied to the ODCB instance?

 

Resolution


When upgrading the Policy Server 12.8SP5 to 12.8SP8, as per documentation, only upgrade the Policy Store following these instructions is needed (1):

  Import the Policy Store Data Definitions
  Import the Default Policy Store Objects
  Import the Federation Policy Store Objects

The files like

  sm_mssql_ps_upgrade_nestedvariables_to_12.52

don't have to be run.
  
This file is to fix a problem in former versions which is no longer supported.

Further, ensure the Policy Store data are 100% healthy before upgrading it (2).

Finally, the Policy Server 12.8SP8 offers the possibility to use still the DataDirect drivers, or the Native Drivers for ODBC (3).

 

Additional Information