[external] Update database compatibility level of all existing databases

External content by Daniel Krüger; November 10, 2024 ; 
The original post has appeared on daniels-notes.de

With WEBCON BPS 2025 the maximum supported compatibility level is 160 (SQL Server 2022).

Change log:

Changed the default compatibility level for new SQL databases created during the installation of the WEBCON BPS platform. As a result, the previous compatibility level set to 120 (SQL Server 2014) has been replaced with the highest possible level, which, however, cannot exceed 160 (SQL Server 2022). This modification does not affect existing databases, which will retain their compatibility level of 120.

I put together a little script which can be used to update the level of all '%BPS%' databases. By default, the 'dry run' mode is active, so that you can review what databases would be updated to which level. You actively need to modify this flag to apply the changes.

https://daniels-notes.de/posts/2024/update-database-compatibility-level