May 6


Should I migrate to SQL 2014 or wait for 2016?

By Charles

May 6, 2016

You may have seen either my blog post about SQL 2016 found here or one of many of the other posts by SQL professionals leaving you with the question. Should I migrate to SQL 2014 or wait for 2016? Microsoft gives access to several release candidates of SQL server prior to the general release to the public. Software vendors rarely announce support for the latest version as soon as the general release is available. Either they have not completed all their testing or they might be waiting for any initial teething issues to be fixed by Microsoft first.

That leaves a gap between the general release and vendors announcing that they will support the latest version of their applications on the latest SQL platform. This then leaves businesses that want to move to the latest version with a dilemma. Do I move to SQL 2016 anyway and hope I do not have any support issues or do I wait for it to be formally announced.

This is hard enough to decide for just one application but what if your environment is shared and you have dozens of different applications using your SQL servers. You now need to decide if you only move the applications with announced support and split your environment into two. Those supported on SQL 2016 and those that are not or wait for all of your applications to announce they are supported. Splitting the environment can literally double your licensing costs overnight which can be very expensive.

[h2_heading]Should I migrate to SQL 2014 or wait for 2016[/h2_heading]

SQL does allow you to put a database into compatibility mode which makes it feel like it is running on a previous SQL Server. You can usually go back about two versions prior to the server version. This may or may not allow your application to work you will need to test it on each database as it will be application specific.

If you are currently on any version of SQL Server prior to SQL 2014 then it might be worth ignoring SQL 2016 for the near future. By getting everything that is currently on a previous version of SQL server onto SQL 2014 you can make sure that all of your databases are on a supported platform. Supported by both the vendors and by Microsoft. This will also give you a good idea about your applications and if they will work on SQL 2016. If any of your application vendors do not support SQL 2012 or SQL 2014 then it is very unlikely that they will support SQL 2016.

By consolidating any SQL versions in your business onto a supported SQL platform you might be able to save on licensing costs which can be substantial especially if your business is suffering from a rapid growth cycle creating server sprawl. This will at least give you a good starting position to move to SQL 2016 later on.

I personally do not like running applications on SQL versions, OS versions or even hardware that is not supported by the vendor. I like the security of knowing if I phone up about an issue they will not tell me that is an unsupported configuration. Two words which can strike fear into the heart of any administrator. If you hear those words they are basically saying you are on your own.

The reason that you might want to jump to SQL 2016 could be the need to use one of the new features such as the support for R or the new mobile reports. You might just want to get access to the faster query processing or latest version of AlwaysOn. If you need these features then you will of course need to check that your application will run on SQL 2016 and do thorough testing.

So should I migrate to SQL 2014 or wait for 2016?

If you absolutely need one of the new or latest versions of features then you need those features and will need to go to SQL 2016.

If you do not need the new features and are worried about using an unsupported application on SQL 2016 they do not go to SQL 2016.

If you want to go to SQL 2016 but can wait for your application vendors to announce support then wait a bit longer. Once they announce support you can test and then move in your own time.

What do you think the answer is for the question ‘should I migrate to SQL 2014 or wait for 2016?’ for your business?

About the author

Microsoft Certified SQL Server DBA with over a decades experience including work for large FTSE 250 companies amongst others. The SQL Server stack has been the focus of almost all of my career in IT. I have experience designing, supporting and troubleshooting large Data Platform deployments.

You might also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}