Moving database instance from one server to another

This topic provides information about how to change the database connection information on the reports server when the database instance moves from one server to another. You might need to move your instance in case of database crash. 

Before you begin

Before you start moving the database instance, ensure that you meet the following requirements:

• Restore the backup copies of the reports data warehouse and use the restored databases while using the post-installation reconfiguration wizard.
• (Microsoft SQL Server only) Ensure that you have permission to create a database link between TrueSight Server Automation - Data Warehouse and TrueSight Server Automation.

To update the database connection information

1.  Launch the console by performing the following steps: 
   
   1. To view the home page for the console on Microsoft Windows or UNIX systems, click Start > Programs > TrueSight Server Automation - Data Warehouse > Console.
      Alternatively, you can enter the following address into a web browser: 
      https://reportsServer:portNumber/tssa-dw
      
      • reportsServer is the server that hosts TrueSight Server Automation - Data Warehouse. 
      • portNumber is the web server secure port that you specified during installation. 
   2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse Administrator (DWAdmin) credentials. By default, the password is hidden. To view the password, click .
   3. In Site, select a site. The Primary Site is the default site.
   4. In Authentication Method, select a authentication method. SRP is the default authentication method.
   5. Click LOG IN.
    
2. Click Configuration > Database Details.
3. In the Database Details section, click Reconfigure.
4. Provide information on the Database Prerequisites tab.
   The Database Prerequisites tab validates whether you have created the required tablespaces and users.
   • Using new databases
     • If you have already created databases and users, select the Fresh database and users are already created? If yes, select the radio button and proceed. If not, download database scripts. option and click Next.
     • If not, click the Download the scripts to create users/database/schema link to download the database and user creation scripts. Set up the database:
       • (Oracle) Create users and tablespaces using the downloaded script and start the configuration process again. For instructions for creating users and tablespaces, see Setting up the Oracle database. 
       • (SQL Server) Create users and databases using the downloaded script and start the configuration process again. For instructions for creating users and databases, see Setting up the SQL Server database. 
   • Using the existing BMC Decision Support for Server Automation databases - Select the Use the existing BladeLogic Decision Support for Server Automation (BDSSA) databases. option and click Next. 
5. Provide information on the ETL Master Repository tab, and click Next.
   Field definitions

   Field	Description
   Host Name	Host name or IP address of ETL master repository server
   Port	Port number on which the ETL master repository server listens
   SID (Oracle) or Database Name (SQL Server)	Service ID or Service name for the ETL master repository
   User Name	ETL master repository user name
   Password	Password for the ETL master repository userNote: Using any of the following special characters in the password will cause the configuration to fail, requiring you to reconfigure the database schema. Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;)
   Confirm Password	Same password for confirming the ETL master repository user

   WarningIn case of SQL Server if databases are created on Named Instance, you should provide the Hostname and valid Port number of named instance instead of <Hostname/NamedInstance> in the Host Name field.

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

   Note

   Enter details of the restored reports data warehouse.

   Field definitions

   Field	Description
   Database Character Set	(Applicable only for new TrueSight Server Automation - Data Warehouse configuration) Database character set for the reports data warehouse Values can be CHAR or NCHAR. This field does not appear if you are using the existing BMC Decision Support for Server Automation database.
   Host Name	Host name or IP address of the reports data warehouse database server Note: LOCALHOST is not allowed.
   Port	Port number on which the reports data warehouse database server listens
   SID (Oracle)/ Database Name (SQL Server)	Service ID or Service name for the reports data warehouse
   User Name	Reports data warehouse user name
   Password	Password for the reports data warehouse user Note: Using any of the following special characters in the password will cause the configuration to fail, requiring you to reconfigure the database schema. Ampersand (&) Double quotes (" ") Pipe (|) Less than sign (<) Greater than sign (>) Single quotes (' ') Forward slash (/) Semicolon (;)
   Confirm Password	Confirmed password for the reports data warehouse user

   Warning

   In case of SQL Server if databases are created on Named Instance, you should provide the Hostname and valid Port number of named instance instead of <Hostname/NamedInstance> in the Host Name field.

7. Provide information on the ETL Work Repository tab, and click Next.
   Field definitions

   Field	Description
   Host Name	Host name or IP address of the ETL work repository server
   Port	Port number on which the ETL work repository server listens
   SID (Oracle) or Database Name (SQL Server)	Service ID or Service name for the ETL work repository
   User Name	ETL work repository user name
   Password	Password for the ETL work repository user
   Confirm Password	Same password for confirming the ETL work repository user

   WarningIn case of SQL Server if databases are created on Named Instance, you should provide the Hostname and valid Port number of named instance instead of <Hostname/NamedInstance> in the Host Name field.
8. Click Finish.
   The Last Task Details page lists the tasks that are run during the reconfiguration process and their status.