Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data Stores in a Relational Database › Migrate an Existing Policy Store into a Relational Database

Migrate an Existing Policy Store into a Relational Database

Using the smobjexport and smobjimport tools, you can migrate policy store data from other types of LDAP into database policy stores or move policy stores in one database to another.

The following list identifies the supported migrations:

• Oracle/SQL Servers to LDAP
• Oracle/SQL Server to Oracle/SQL Severs
• LDAP to Oracle/SQL Server

Important! Before running a SiteMinder utility or executable on Windows Server 2008, open the command line window with Administrator permissions. Open the command line window this way, even if your account has Administrator privileges. For more information, see the release notes for your SiteMinder component.

The following procedure assumes you have created a SiteMinder data store in either an Oracle database or a SQL Server database to which you will export your data. Details exist in How to Configure a SiteMinder Data Store in a SQL Server Database and How to Configure a SiteMinder Data Store in an Oracle Database.

To migrate data from one policy store to a Database

1. Export your existing policy store into an .smdif file by doing the following:
   1. Navigate to siteminder_home\bin
   2. Run:

      smobjexport -ofile_name -dsm_super_user_name 
      -wsuper_user_password -v
      

      file_name

      Specifies the name of the output file to which you are exporting the data.

      sm_super_user_name

      Specifies the Super User name of the SiteMinder administrator.

      super_user_password

      Specifies the password for the SiteMinder Super User.

      Example: smobjexport -opstore.smdif -d"SM Admin" -wPassword -v

      Note: If the key store exists in the policy store, use the -k option. By default, keys are not included in the export.

2. Run the import utility to import your old policy store into the new one:

   smobjimport -ifile_name -dsm_super_user_name -wsuper_user_password -v
   

   file_name

   Specifies the name of the file to which you exported the policy store.

   sm_super_user_name

   Specifies the Super User name of the SiteMinder administrator.

   super_user_password

   Specifies the password for the SiteMinder Super User.

   Example: smobjimport -ipstore.smdif -d"SM Admin" -wPassword -v

   Note: If the key store exists in the policy store, use the -k option.

3. Verify that the Policy Server is pointing to the policy store.

   The policy store is configured and you can now log into the Policy Server User Interface.

More Information:

Point the Policy Server at the Policy Store

Export Policy Data Using smobjexport

Import Policy Data Using smobjimport