Is Compatibility level SQL Server 2005(90) supported in SQL Server 2014? - by Manabu Suzuki

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 793444 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 7/10/2013 6:20:59 PM
Access Restriction Public

Description

I confirmed Database Compatibility Level in SQL Server 2014 CTP1.
There are it from SQL Server 2005(90) to SQL Server 2012(110) in Model database.
Compatibility Level SQL Server 2014(120) is not yet implemented.
Is Compatibility level SQL Server 2005(90) supported in SQL Server 2014?

ALTER DATABASE Compatibility Level in MSDN 
<http://msdn.microsoft.com/en-us/library/bb510680(v=sql.120).aspx>
Sign in to post a comment.
Posted by Microsoft on 11/4/2013 at 2:23 PM
Compatibility level 90 (SQL 2005) will not be supported in SQL Server 2014 when it ships. In the interim preview builds it may appear to be working but when we RTM, the feature will not be supported.

Kevin
Posted by Microsoft on 11/4/2013 at 2:22 PM
Compatibility level 90 (SQL 2005) will not be supported in SQL Server 2014 when it ships. In the interim preview builds it may appear to be working but when we RTM, the feature will not be supported.

Kevin
Posted by Microsoft on 7/26/2013 at 4:49 PM
Thank you for submitting this feedback. We will provide you with an answer to your inquiry shortly.