Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Changing multiple databases

To change connection string parameters (such as host name, port, or instance name) in multiple databases (reports data warehouse, portal, and ETL repositories) at one time, use the postinstallation reconfiguration wizard available in the BMC Decision Support for Server Automation Console. 

Note

Restore the backup copies of the portal database and reports data warehouse and use the restored databases while using the postinstallation reconfiguration wizard.

To change the reports data warehouse, portal content store, and ETL databases

  1. Launch the BMC Decision Support for Server Automation Console, as described in Accessing-the-console.
  2. Click Configuration > Database Details.
  3. In the Database Details section, click Reconfigure.
  4. Provide information on the Database Prerequisites tab (see Oracle-Database-Prerequisites-tab or SQL-Server-Database-Prerequisites-tab). 
    • If you have already set up the database, select the check box and skip to step 6. 
    • If you have not created the users and tablespaces (for Oracle) or databases and users (for SQL Server), click the Download Database Scripts button to download the script and go to step 5. 
  5. Set up the database:
    • If you are using Oracle, create users and tablespaces by using the script and start the configuration process again. For instructions for creating users and tablespaces, see Setting-up-the-Oracle-database. 
    • If you are using SQL Server, create users and databases by using the script and start the configuration process again. For instructions for creating users and databases, see Setting-up-the-SQL-Server-database.
  6. Click Next.
  7. Provide information on the ETL Master Repository tab, and click Next.

  8. Provide information on the Warehouse Database tab, and click Next.

    Note

    Enter details of the restored reports data warehouse.

     

  9. Provide information on the ETL Work Repository tab, and click Next.

  10. Provide information on the Portal Database tab, and click Next.

    Note

    Enter details of the restored portal database.

     

  11. Click Finish.
    The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*