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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SQL version for SL2015
Microsoft Dynamics SL (Archived)

SQL version for SL2015

(0) ShareShare
ReportReport
Posted on by Bruce.T 459

We are upgrading from SL7 to SL2015CU2. To align with our IT strategy we want to use SQL Server 2014 which the SL2015 system requirements state is supported. However our partner is advising that we need to run SQL Server 2014 in 2008 compatibility mode. Is anyone able to confirm if this is correct?  And if so help us to understand why this is necessary.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ram Peru Profile Picture
    Ram Peru 2,830 on at

    Good day Bruce ,

    Hope you're doing good.

    Your partner is right. The reason is that you previously had an older SQL Server 2008 database and restored/upgraded it on this new SQL Server 2014 instance. The DBs may run well on this new instance but did you really upgrade anything? The answer lies on whether the compatibility level changed during the restore/upgrade process.  A compatibility level is associated with each database. It allows the behavior of the database to be compatible with the specific version of SQL Server it is running on.

    The main reason for having compatibility levels is to allow for Backward Compatibility. Each compatibility level has its own set of features and you must program against those features when developing an application that uses the database. If you want to move your database to a newer instance of SQL Server but at the same time have it backwards compatible, you need to make sure the compatibility level stays the same. 

    Hope this makes sense.

  • Bruce.T Profile Picture
    Bruce.T 459 on at

    Thanks Perumal.

    I needed to check to ensure weren't causing an issue at a later time.

    Bruce

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans