Reasons to upgrade to SQL Server 2014
There has been quite few new SQL Server versions released frequently since the launch of SQL Server 2008. Currently the most used versions in most of the organizations are SQL Server 2005, SQL Server 2008 R2 and BDAs or organizations have been planning to upgrade from these versions to next higher version SQL Server 2012, however there has been another new release which is SQL Server 2014. Now there could be confusion about upgrading to which version? should we upgrade from SQL Server 2005/2008 R2 to SQL Server 2012 or 2014?
If you are planning to upgrade to higher version, then it is advisable to go with the latest release of SQL Server 2014, by skipping SQL Server 2012, as you can avoid use this version for longer time and there will be no need for another upgrade in few years, instead we can run with SQL Server 2014 for many years. Along with this there are also few other things which will prove to go ahead with SQL Server 2014 instead of SQL Server 2012, which include the license cost, which is almost same for both SQL Server 2012 and SQL Server 2014. Another important thing is that the end of life cycle date is far to ahead, so there is no force to upgrade to higher versions atleast for next 10+ years, unless we want to use any particular latest feature.
By upgrading directly to SQL Server 2014, you can get chance to use new features of SQL Server 2014 like In-Memory-OLTP, etc and also there are many enhancements to features like AlwaysON and also there are many enhancements to BI technology like SSAS, SSRS and SSIS. So, if you are planning to upgrade, it is better to prefer to go ahead with the latest releases always and in this case it is SQL Server 2014.
Hope this was helpful.
This is applicable for below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings