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.
Procedure
- Stop the BigFix Inventory server.
- Back up the BigFix Inventory database.
- Move the database to the target computer and make it operational.
-
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
-
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"/>
- DB2
database
-
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
- Start the BigFix Inventory server.