SQL Server 2014 released earlier this year with many new and interesting capabilities. For further information, please take a look at the product information at this location: http://www.microsoft.com/en-us/server-cloud/products/sql-server/default.aspx.
Over the last few months, the Microsoft Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to announce that Microsoft Dynamics NAV 2013, Microsoft Dynamics NAV 2013 R2, Microsoft Dynamics NAV 2009 R2, and Microsoft Dynamics NAV 2009 SP1 are compatible with SQL Server 2014!
Please note that this applies to the following editions of Microsoft SQL Server:
The Dynamics NAV team
----- This blog post was updated on September 22, 2014. -----
Thank you for being ahead of time :) Looking forward to 2009R2 tests.
Great news! I can finally answer this popular question with a YES
"we are now proud to announce that Microsoft Dynamics NAV 2013, Microsoft Dynamics NAV 2013 R2, >>>> and Microsoft Dynamics NAV 2009 R2 <<<< are compatible with SQL Server 2014!"
Great. ONE usable release of NAV is copatible with SQL Server 2014. That's good news and bad news in one sentence. Hey, at least it's compatible :)
Is SQL 2014 compatible to NAV 2015?
Does anyboy know if NAV 5.0 SP1 is compatible with SQL Server 2014?
Thanks for your answers.
@SevenGr - As NAV 5.0 SP1 has been "terminated" long time ago (April 10th, 2012) the short answer is No.
The little longer answer is that NV 5.0 SP1 is capable of running on Level 90 - So you could give it a shot trying to run on SQL 2014 with Level no higher than 90 - But I guess all the amazing stuff that SQL 2014 can do...will not work for your installation. This is considered as a bad idea to go in this direction.
IF you want to go stick to your 5.0 SP1, then you should do a runtime upgrade on your client-machines and server to Dynamics NAV 2009R2. You will still be 5.0 SP1 Objects, but your runtime NAV will support SQL 2014, and you should be safe.
You WILL get some performance out of it, BUT as the code has not been changed to use FINDFIRST/FINDLAST and FINDSET (and not FIND('-') and FIND('+')) then your performance might end up being limited depending on the rest of your server configuration.
Thanx, I will stay at SQL 2008 R2.
Which is the latest/greatest version of SQL support by this version?
As PalleA mentions, NAV 5.0 SP1 is long since out of mainstream support, so we have not tested compatibility with versions of SQL Server that are later than SQL Server 2008.
can you run SQL 2012 Runtime on NAV 5.0?
is there any SQL 2014 enterprise feature in Scalability & Performance section such as:
Table and index partitioning
Partition Table Parallelism
Multiple Filestream containers
NUMA Aware Large Page Memory and Buffer Array Allocation
IO Resource Governance
In-Memory OLTP 1
(msdn.microsoft.com/.../cc645993.aspx) that might be used in NAV 2015?
we are still confused which version of SQL that we need to buy.