SQl Server 2008 to SQL Server 2012
What version of siteminder? You need to first validate if SQL Server 2012 is supported - CA SiteMinder Informational Documentation Index - CA Technologies
Thank you for the link.Current Environment Siteminder 12.52 SP01 CR05
it supports sql 2012
Easiest option is doing it at the database level using restore and backup option.
I just did it couple of days back, took about 5 minutes
Just to close the loop on this ,
My recommendation would be to migrate the policy store at the database level by using Back Up & Restore function in Sql server.
However, you can also do this via normal XPSExport and Import procedure.
Going by this route :
1. Create new Policy store database in 2012 and initialise it with the PS config wizard.
2. Perform full xpsexport from 2008R2 Policy store
XPSExport -xb fullexport.xml -npass
3. Import policy store into the target policy store:
XPSimport fullexport.xml -npass
Thank you for the steps, I have one question. You mentioned "Create new Policy store database in 2012 and initialize it with the PS config wizard". Can you please elaborate on this point.
I meant to select following option in the PS config wizard :