Upgrade from SQL Server 2008 R2 to SQL Server 2012 or 2014 or 2016
Posted on 2016-07-18
Our organization wants to upgrade from SQL Server 2008 R2 ==> SQL Server 2012 or 2014 or 2016
We are not sure what version we should go for.
We don't use too many of the new features on the SQL server but would like to have a version that is supported by Microsoft for a a longer time
I am thinking that we can go for a stable version lets say 2012 SP3 or 2014 SP2.
What might be the potential issues that might happen and that we need to take care of from the application standpoint and from installation standpoint.
PS. Right now we are using Windows Server 2008 R2 for hosting the SQL server.
Please help as I am not sure which one to choose. You can give me some good pointers.