Updating the server database schema

BigFix Inventory server database schema gets updated when upgrading from one version to another.

Before you begin

MS SQL only

Database user configured for BigFix Inventory must be the owner of the database. A non-owner cannot perform the database update. The following error message appears if a non-database owner tries to update the database:
```
User 'user_name' is not the owner of specified database. Current database owner is 'owner'. As Database 
Administrator use the following query to fix database ownership: ALTER AUTHORIZATION ON DATABASE::db_name 
TO "user_name".
```
MS SQL database has a MS SQL agent created BigFix Inventory database index maintenance. Index maintenance is not supported for MS SQL Express edition. The following message appears for MS SQL Express edition:
```
MS SQL Express Edition is detected. 
There will be not created BFI Index Maintenance Job as this edition does not support SQL Server Agent.
```
The user must have a system admin or has the access of "SQLAgentUserRole" for msdb database to manage SQL Server agent jobs. Without access, the user cannot manage the BigFix Inventory index maintenance job. Instead of the index maintenance job being created or updated, the following warning appears:
```
WARNING - The database user user_name does not have sysadmin nor SQLAgentUserRole for msdb database to
manage SQL Server Agent jobs. BFI Index Maintenance Job will not be created/updated, warnings will be 
printed in logs.
```
The database upgrade is not blocked, but the index maintenance job is not created. The tema.log file includes the failure as a warning for migration scripts running during the job creation attempt.

About this task

Follow the below steps to update the database schema:

After you upgrade the server, go to BigFix Inventory and click on Schema Update to complete the upgrade.
For the MS SQL database, the user who is configured in this database must have the db_owner role assigned. Log in to BigFix Inventory, and click Update Schema.
Important: The time taken to complete the upgrade depends on the size of the environment. It may vary from 2 minutes to 2 hours.
To ensure that all changes are processed, run an import. In BigFix Inventory, click Management > Data Imports, and click Import Now.
Important: The time taken by the first import may take longer as it includes the new software catalog and might require additional computation to prepare existing data for the new version.