Moving the BigFix Inventory database

To move the BigFix Inventory database to a different computer, back up the database, move it to the target computer, and point to that computer in the server.xml and database.yml files.

About this task

Procedure

  1. Stop the BigFix Inventory server.
  2. Back up the BigFix Inventory database.
  3. Move the database to the target computer and make it operational.
  4. Back up the following files from the installation directory of the BigFix Inventory server.
    • installation_directory/wlp/usr/servers/server1/server.xml
    • installation_directory/wlp/usr/servers/server1/config/database.yml
  5. Update the database location in the server.xml file. Provide the IP address or domain name of the computer on which the database is located.
    • DB2 database
      
      <properties.db2.jcc 
      password="{aes}xxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXX" 
      user="db2inst1" 
      serverName="localhost"
      databaseName="temadb"/>
    • MSSQL database
      
      <properties.microsoft.sqlserver 
      password="{aes}xxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXXxxxxXXXX" 
      user="sa"
      serverName="localhost" 
      databaseName="temadb"/>
  6. Update the database location in the database.yml file. Provide the IP address or domain name of the computer on which the database is located.
    host: localhost
    database: temadb
    database_type: mssql
    windows_authenticated: true
    Tip: Follow the instruction mentioned here while editing the database.yml file.
  7. Start the BigFix Inventory server.