Collation and server compatibility level for production onprem BC database

(1) Share

Report

Posted on by LS-11090637-0

Hello, default collation for czech onprem demo db is Czech_100_CI_AS, but it was Czech_100_CS_AS before. Can there be any issues running on Czech_100_CS_AS, or why the change has occured? What may be prefered option for our onprem solution?

The Compatibility LVL is 130 in the demo db, which is not supported by the minimum requirements. Our db experts say that they before experienced issues from the increasing the compatibility lvl. We would like to run this on SQL19, can we increase the compatibility lvl to our server value without any issues?

Categories:

Other