SQL version for SL2015

(0) Share

Report

Posted on by Bruce.T

405

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

All responses (2)

Answers (1)

Bruce.T 405 on at

Like (0)

Report

RE: SQL version for SL2015

Thanks Perumal.

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

Bruce
Verified answer

Ram Peru 2,830 on at

Like (0)

Report

RE: SQL version for SL2015

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.