web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Database Compatibility...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Database Compatibility Level on SQL2017

(0) ShareShare
ReportReport
Posted on by HFLo 202

we upgraded to GP2018, and also upgraded from SQL2014 to SQL2017 (version 14.0.3335.7)

the DYNAMICS and COMPANY DB compatibility level are now set as SQL Server 2014 (120)

should I just keep it as it is or change to 

SQL Server 2016 (130)

SQL Server 2017 (140)

thanks.

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    I always set the compatibility level to the version of SQL running. However, I have never seen this addressed  so it will be interesting to see what ansewrs come back on this.

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh Microsoft Employee on at

    We recommend setting the compatibility level of the database to be that of the SQL version unless there is a reason to do differently, which isn't that common.

    I did hear it mentioned that with SQL 2014 there was a performance issue where changing to SQL 2012 helped resolve it, but other than that, nothing from the Dynamics GP side.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 310 Super User 2026 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 276 Most Valuable Professional

#3
Anton Venter Profile Picture

Anton Venter 266 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans