Compatibility Level versus the Real Version

Question

Compatibility Level versus the Real Version

JediSQL

SSCrazy

Points: 2118
More actions
May 9, 2018 at 3:06 pm

#334584

We have a third party application that "supports" up through SQL Server 2016. We are planning this year's SQL Server upgrades, and we would like to get all our machines on SQL Server 2017 to simplify administration. I would like to run the application's database at Compatibility Level 2016 on a 2017 instance. Has anyone had any troubles with this type of scenario (not limited to these two specific versions)?
Sincerely,
Daniel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

DHeath SSCertifiable Points: 5200 More actions · Answer 1

I have not had any issues with running the databases in a compatibility mode BUT what you might run into is that if your application has problems and its not vendor supported(on 2017) they might come back and tell you that they cant help because they don't support the application on 2017 in compatibility mode. The SQL aspects will most likely be okay... Call vendor and get support verification and see what they say. Just my .02 🙂 good luck

DHeath

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 2

I agree with DHeath above. It doesn't matter what any of us think or say. It only matters what the vendor says. Ask them to verify and then sign off on it if they agree because if you don't get the signoff, you don't actually have an agreement.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

JediSQL SSCrazy Points: 2118 More actions · Answer 3

Man! You guys have to go and take the fun out of everything 😉. But, yeah, you're probably right. Thank you.

Sincerely,
Daniel