从早期版本升级到 SQL Server 2016 (13.x)

Ty3306 2023-11-13

605

从早期版本升级到 SQL Server 2016 (13.x)

SQL Server 2016 支持从下列 SQL Server 版本升级：

SQL Server 2008 (10.0.x) SP4 或更高版本
SQL Server 2008 R2 (10.50.x) SP3 或更高版本
SQL Server 2012 (11.x) SP2 或更高版本
SQL Server 2014 (12.x) 或更高版本

备注

若要在 SQL Server 2005 (9.x) 上升级数据库，请参阅 2005 版本支持。

下表列出了从 SQL Server 的早期版本升级到 SQL Server 2016 (13.x) 的支持方案。

从	支持的升级途径
SQL Server 2008 (10.0.x) SP4 Enterprise	SQL Server 2016 (13.x) Enterprise
SQL Server 2008 (10.0.x) SP4 Developer	SQL Server 2016 (13.x) Developer
SQL Server 2008 (10.0.x) SP4 Standard	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard
SQL Server 2008 (10.0.x) SP4 Small Business	SQL Server 2016 (13.x) Standard
SQL Server 2008 (10.0.x) SP4 Web	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web
SQL Server 2008 (10.0.x) SP4 Workgroup	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard
SQL Server 2008 (10.0.x) SP4 Express	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Express
SQL Server 2008 R2 (10.50.x) SP3 Datacenter	SQL Server 2016 (13.x) Enterprise
SQL Server 2008 R2 (10.50.x) SP3 Enterprise	SQL Server 2016 (13.x) Enterprise
SQL Server 2008 R2 (10.50.x) SP3 Developer	SQL Server 2016 (13.x) Developer
SQL Server 2008 R2 (10.50.x) SP3 Small Business	SQL Server 2016 (13.x) Standard
SQL Server 2008 R2 (10.50.x) SP3 Standard	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard
SQL Server 2008 R2 (10.50.x) SP3 Web	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web
SQL Server 2008 R2 (10.50.x) SP3 Workgroup	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard
SQL Server 2008 R2 (10.50.x) SP3 Express	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Express
SQL Server 2012 (11.x) SP2 Enterprise	SQL Server 2016 (13.x) Enterprise
SQL Server 2012 (11.x) SP2 Developer	SQL Server 2016 (13.x) Developer SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Enterprise
SQL Server 2012 (11.x) SP2 Standard	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard
SQL Server 2012 (11.x) SP1 Web	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web
SQL Server 2012 (11.x) SP2 Express	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Express
SQL Server 2012 (11.x) SP2 商业智能	SQL Server 2016 (13.x) Enterprise
SQL Server 2012 (11.x) SP2 Evaluation	SQL Server 2016 (13.x) Evaluation SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Developer
SQL Server 2014 (12.x) Enterprise	SQL Server 2016 (13.x) Enterprise
SQL Server 2014 (12.x) Developer	SQL Server 2016 (13.x) Developer SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Enterprise
SQL Server 2014 (12.x) Standard	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard
SQL Server 2014 (12.x) Web	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web
SQL Server 2014 (12.x) Express	SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Express SQL Server 2016 (13.x) Developer
Business Intelligence	SQL Server 2016 (13.x) Enterprise
SQL Server 2014 (12.x) Evaluation	SQL Server 2016 (13.x) Evaluation SQL Server 2016 (13.x) Enterprise SQL Server 2016 (13.x) Standard SQL Server 2016 (13.x) Web SQL Server 2016 (13.x) Developer
SQL Server 2016 (13.x) 候选发布*	SQL Server 2016 (13.x) Enterprise
SQL Server 2016 (13.x) Developer	SQL Server 2016 (13.x) Enterprise

* 从候选发布升级的 Microsof 支持专门面向参与了技术采用计划 (TAP) 的客户。

升级

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

从早期版本升级到 SQL Server 2016 (13.x)

从早期版本升级到 SQL Server 2016 (13.x)

评论