CA Identity Manager Installation Guide › WebLogic Version › Separate Database Configuration › How to Create Separate Databases › Run the SQL Scripts

Run the SQL Scripts

SQL scripts are automatically run against the databases when CA Identity Manager starts, however if you want to run the SQL scripts yourself, perform the following steps before restarting the application server:

These scripts are installed with the CA Identity Manager Administrative Tools.

Follow these steps:

1. Do one of the following:
   • Microsoft SQL Server: Open the Query Analyzer tool and select the script you need.
   • Oracle: Open the SQL prompt for the script you need.
2. Select one of the following scripts (shown with the default Windows locations) depending on what the database was created for:
   • Task Persistence:
     • Microsoft SQL Server: C:\Program Files\CA\Identity Manager\IAM Suite\tools\db\taskpersistence\sqlserver\idm_db_sqlserver.sql
     • Oracle on Windows: C:\Program Files\CA\Identity Manager\IAM Suite\tools\db\taskpersistence\oracle9i\idm_db_oracle.sql
     • Oracle on UNIX: /opt/ca/IdentityManager/IAM_Suite/Identity Manager/tools/db/taskpersistence/oracle9i/idm_db_oracle.sql
   • Auditing:
     • Microsoft SQL Server: C:\Program Files\CA\Identity Manager\IAM Suite\tools\db\auditing\sqlserver\ims_mssql_audit.sql
     • Oracle on Windows: C:\Program Files\CA\Identity Manager\IAM Suite\tools\db\auditing\oracle\ims_oracle_audit.sql
     • Oracle on UNIX: /opt/ca/IdentityManager/IAM_Suite/Identity Manager/tools/db/auditing/oracle/ims_oracle_audit.sql
   • Snapshots:
     • Microsoft SQL Server: C:\Program Files\CA\Identity Manager\IAM Suite\tools\imrexport\db\sqlserver\ims_mssql_report.sql
     • Oracle on Windows: C:\Program Files\CA\Identity Manager\IAM Suite\tools\imrexport\db\oracle\ims_oracle_report.sql
     • Oracle on UNIX: /opt/ca/IdentityManager/IAM_Suite/Identity Manager/imrexport/db/oracle/ims_oracle_report.sql
   • Workflow: See the Section "Run the SQL Scripts for Workflow."
3. Run the script file.
4. Verify that no errors appeared when you ran the script.