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
- 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
Tip: Follow the instruction mentioned here while editing the database.yml file. - Start the BigFix Inventory server.