我们如何从SQL SERVER 2008R2 SP2升级到SQL SERVER 2017 [英] How do we upgrade from SQL SERVER 2008R2 SP2 TO SQL SERVER 2017

问题描述

Hi Freinds，

Hi Freinds,

从SQL SERVER 2008R2 SP3的博客中看到，能够升级2017年。但我的SQL版本是2008R2 SP2。我如何从SQL2008R2升级到SQL 2017。

Seen in the blog from SQL SERVER 2008R2 SP3 can able to upgrade 2017 .But my SQL version is 2008R2 SP2 . How DO i upgrade from SQL2008R2 TO SQL 2017.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and -edition-upgrades-2017？view = sql-server-2017

推荐答案

Hi Vanchan，

Hi Vanchan,

您将（遗憾的是）需要分两步执行更新。

You will (unfortunately) need to perform the update in 2 steps.

首先升级到中间版本，如SQL 2014或SQL 2012，然后升级到SQL 2017。

Upgrade to an intermediate version first, like SQL 2014 or SQL 2012, and then upgrade to SQL 2017.

就我个人而言，我不知道你可以将SQL2008R2 SP3升级到SQL 2017，但如果你认为可以，为什么不先安装SP3呢？毕竟，它只是一个服务包。应该不是问题，对吗？

Personally, I didn't know that you can upgrade SQL2008R2 SP3 to SQL 2017, but if you think you can, why not simply install SP3 first? It's just one service pack, after all. Shouldn't be a problem, right?

这篇关于我们如何从SQL SERVER 2008R2 SP2升级到SQL SERVER 2017的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！