Symantec Access Management

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-21-2017 01:05 PM

    SQl Server 2008 to SQL Server 2012



  • 2.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-21-2017 03:00 PM

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



  • 3.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-21-2017 03:06 PM

    Jack,

     

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



  • 4.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-21-2017 03:33 PM

    it supports sql 2012



  • 5.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-21-2017 03:15 PM

    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



  • 6.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-22-2017 01:11 PM

    Thanks Ujwol



  • 7.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012
    Best Answer

    Posted 03-22-2017 06:53 PM

    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



  • 8.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-23-2017 12:33 PM

    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.



  • 9.  Re: What are the steps required to Migrate Policy Store from SQl Server 2008 to SQL Server 2012

    Posted 03-26-2017 10:39 PM

    Hi Raj,

     

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

     

     

     

    Regards,

    Ujwol