Skip to main content
Solved

Change db compatibility_level

  • March 8, 2021
  • 1 reply
  • 34 views

Hi,

We are running on MS SQL Server 2019, but all of the DBs created from TX  are still on compatibility level 120. Will changing the compatibility_level impact the TX solution?

 

br,
Sturla

Best answer by Syed Yousuf

You may set the compatibility level in the Database Properties > Options in SQL Server using SSMS.  You may also set Deployment target in Advanced settings of your data warehouse in TimeXtender.

 

1 reply

Forum|alt.badge.img+3
  • Contributor
  • 82 replies
  • Answer
  • January 20, 2023

You may set the compatibility level in the Database Properties > Options in SQL Server using SSMS.  You may also set Deployment target in Advanced settings of your data warehouse in TimeXtender.