If the compatibility mode has a negative affect on any queries, you will want to find that in development, not in production. In your case, since it is a development system and there is a production server partner with the upgraded compatibility mode, I would certainly get it upgraded. Lastly-this question is a day old and nobody has commented or answered with any warnings, and I'm quite certain someone would have already commented if there was any known significant risk. If you aren't sure of why this change should be safe, then I would recommend that you do a bit of reading on what the compatibility mode actually does, and then it should be clear that it is OK to change it-particularly since you've already tested the configuration in production.Īdditionally, I have not been able to find anything to suggest that it's not OK to change it, and I have found a couple of references that suggest it should be done:
The only reason I say should be safe is that I've been in IT way to long to ever say anything will be safe. So if everything is working fine in production with the higher compatibility mode, then it should be safe to change the compatibility mode in development. Unfortunately, this documentation doesn't give any guidance on whether it should be changed after the upgrade. See Change the Database Compatibility Level and use the Query Store. The upgrade worked as expected in regard to the master database compatibility mode. I'm not certain what you mean by one application "running its queries from the master database." As you likely know, this would fall into the category of "worst practices."
0 kommentar(er)
