Installation Guides › WebLogic Version › Database Creation › 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 Identity Manager Administrative Tools.

To run the SQL scripts

1. Do one of the following:
   • MS 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:
     • MS SQL: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence\sqlserver\idm_db_sqlserver.sql
     • Oracle: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence\oracle9i\idm_db_oracle.sql
   • Workflow: Run the CreateDatabase script outlined in the next section.
   • Auditing:
     • MS SQL: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\auditing\sqlserver\ims_mssql_logs.sql
     • Oracle: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\db\auditing\oracle\ims_oracle_logs.sql
   • Snapshots:
     • MS SQL: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\imrexport\db\sqlserver\ims_mssql_report.sql
     • Oracle: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\imrexport\db\oracle\ims_oracle_report.sql
3. Run the script file.

To verify that the database instance is correctly configured, check the database tables for CA Identity Manager objects that begin with the letters idm.