Upgrading the MS SQL Server database (disconnected scenario)
The MS SQL Server database stores information crucial for the operation of the License Metric Tool server. Ensure that you always use a supported version of the database, upgrade it regularly, and create backups for the purpose of disaster recovery.
Upgrading procedure
For a step-by-step procedure of upgrading the database, refer to the MS SQL Server documentation.
Supported versions of MS SQL Server
Before you upgrade the database of the License Metric Tool server, verify whether the new version of the database is supported by your current version of the License Metric Tool server and the version of the server to which you are upgrading. Otherwise, the License Metric Tool server might not work. Refer to the following table for information about versions of MS SQL Server that are supported by particular versions of the License Metric Tool server.
| License Metric Tool | ||||||||
|---|---|---|---|---|---|---|---|---|
| 9.2.0.0 - 9.2.12.0 | 9.2.13.0 - 9.2.15.0 | 9.2.16.0 | 9.2.17.0 - 9.2.18.0 | 9.2.19.0 - 9.2.22.0 | 9.2.23.0 - 9.2.31.0 | 9.2.32 | 9.2.33 | |
| 2008 and 2008 R2 | Supported | Supported | Supported | Not supported | Not supported | Not supported | Not supported | Not supported |
| 2012 and 2012 Express | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Not supported |
| 2014 and 2014 Express | Supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| 2016 | Not supported | Supported | Supported | Supported | Supported | Supported | Supported | Supported |
| 2016 Express SP2 or higher | Not supported | Not supported | Not supported | Supported | Supported | Supported | Supported | Supported |
| 2017 version 14.0.3162.1 or higher | Not supported | Not supported | Supported | Supported | Supported | Supported | Supported | Supported |
| 2017 Express CU15 or higher | Not supported | Not supported | Not supported | Not supported | Supported | Supported | Supported | Supported |
| 2019 and 2019 Express | Not supported | Not supported | Not supported | Not supported | Not supported | Supported | Supported | Supported |
| 2022 and 2022 Express | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Supported | Supported |