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. 

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.