What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

[Anon Anon]

SQl Server 2008 to SQL Server 2012

[jack.saunders]

What version of siteminder?  You need to first validate if SQL Server 2012 is supported - CA SiteMinder Informational Documentation Index - CA Technologies 

[Anon Anon]

Jack,

 

Thank you for the link.
Current Environment 
Siteminder 12.52 SP01 CR05

[Ujwol]

it supports sql 2012

[Ujwol]

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

[Anon Anon]

Thanks Ujwol

[Ujwol]

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

[Anon Anon]

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.

[Ujwol]

Hi Raj,

 

I meant to select following option in the PS config wizard :

 

 

 

Regards,

Ujwol