TDM: gtrep SQL Server database compatibility level

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Our security team is flagging the gtrep database for running in SQL Server 2008 compatibility mode. We can see one of the first lines of the gtrep setup script is explicitly forcing this via this command:

ALTER DATABASE [gtrep] SET COMPATIBILITY_LEVEL = 100

Can you provide any input to why this is set to SQL 2008 (level 100)? Is there something that would break by changing this to SQL 2019 (level 150)?

Environment

TDM 4.10

Cause

N/A

Resolution

SQL Server 2008 is not supported with TDM 4.10. Refer to this documentation for supported databases for GTREP:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/install-test-data-manager/system-requirements.html#concept.dita_a5bb631567e0ae7aead6971e0b45c6ab14a1bb93_databaserequirements

SQL Server 2019 is a supported database for this TDM Release.

100  is the lowest level, so having greater than that would be ok.