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?
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).