Installation and Upgrade Guides › SiteMinder Upgrade Guide › Upgrading from r6.x › How to Migrate from r6.x › Upgrade an r6.x Policy Store › How to Upgrade an r6.x Policy Store › Extend the MS SQL Server Policy Store Schema

Extend the MS SQL Server Policy Store Schema

You extend the policy store schema to store objects introduced by r12.0 SP2. The existing r6.x policy store schema has not changed.

To extend the Microsoft SQL Server policy store schema

1. Log into SQL Server as the user who administers the Policy Server database information.
2. Start the Query Analyzer.
3. Select the policy store database instance from the database list.
4. Open SQLServer.sql in a text editor and copy the contents of the entire file.

   Note: The SQLServer.sql file is in policy_server_home\xps\db.

   • policy_server_home

     Specifies the Policy Server installation path.

5. Paste the schema from SQLServer.sql into the query and execute the query.

   The policy store schema is extended to store objects introduced by r12.0 SP2.