This document contains the steps necessary to move the SiteMinder Policy Store from one data base to another; for example, from MS-SQL to Oracle, when the Policy Store contains Identity Manager Policy Store Objects as well (this is specific to environment where Identity Manager is integrated with SiteMinder).
Please Note: This document does not discuss moving the Identity Manager Object Store, Audit DB, Task Persistence DB, or the Report Snapshot DB (when moving the SiteMinder Policy Store it is not necessary to move any of these other Identity Manager Databases).
The following are the steps that are required to move the SiteMinder Policy Store from one database to another database when the following conditions are true:
For example, moving the Policy Store from MS-SQL Server to an Oracle database.
Note: All the operations listed below should be carried out on the machine where the SiteMinder Policy Server is installed.
Export the existing SiteMinder Policy Store Data
At this point, you will have two export files:
Import the Policy Store Data