The environment which I am working right now is on SQL Server 2008, 2008 R2. Do you think its a good idea to first patch it with the latest service pack and then upgrade to SQL Server 2014?
Thanks
Sql-server – Patching SQL Server 2008 and upgrading to 2014
service-packsql server 2014sql-server-2008update
Related Question
- Sql-server – Upgrade SQL Server 2008 R2 Express to SQL Server 2014 Developer edition
- Sql-server – Practicing AlwaysOn on SQL Server 2014 – Windows 10 Home
- Migrating from SQL Server 2008 R2 to SQL Server 2014
- Sql-server – Upgrading SQL Server 2012 from SP2 to SP3
- Do I Need to Upgrade to SQL Server 2014 SP2?
- How Does Patching Work in SQL Server
Best Answer
The SQL Server 2014 Upgrade Techincal Guide states that you need the following as the minimal version for an in-place upgrade
So if you are not on the stated service pack level you will need to upgrade to at least that.
It is not neccessary, but start by running the upgrade advisor. Thomas LaRock has a checklist on his page both for the tasks needed before an inplace upgrade and what to do afterwards.