赞
踩
关键术语解释
https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver15
SP = Service Pack 服务包版本
RTM = Original release version 原始发布版本,一般是指没有SP1、SP2的情况下的数据库大版本,比如Sql server 2017目前还没有SP1和SP2,就只有RTM
GDR = General Distribution Release 常规分发版本
CU = Cumulative Update 累积更新
Sqlserver大版本下载路径
Sqlserver 2016
https://www.microsoft.com/en-in/evalcenter/download-sql-server-2016
Sqlserver 2019
https://www.microsoft.com/en-in/evalcenter/download-sql-server-2019
Sqlserver 2022
https://www.microsoft.com/en-in/evalcenter/download-sql-server-2022
Sqlserver大版本生命周期
https://learn.microsoft.com/zh-cn/sql/sql-server/end-of-support/sql-server-end-of-support-overview?view=sql-server-ver16
版本 发布年份 主要支持结束年份 延长支持结束年份
SQL Server 2022 2022 2028 2033
SQL Server 2019 2019 2025 2030
SQL Server 2017 2017 2022 2027
SQL Server 2016 2016 2021 2026
SQL Server 2014 2014 2019 2024
SQL Server 2012 2012 2017 2022
SQL Server 2008 R2 2010 2012 2019
SQL Server 2008 2008 2012 2019
SQL Server 2005 2006 2011 2016
SQL Server 2000 2000 2005 2013
Sqlserver 2012生命周期
https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012
Sqlserver 2014生命周期
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2014
Sqlserver 2016生命周期
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2016
Sqlserver 2017生命周期
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2017
Sqlserver 2019生命周期
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2019
Sqlserver 2022生命周期
https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2022
Sqlserver大版本对应的OS版本
https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
Sqlserver 2012可以安装在Windows Server 2008–Windows Server 2019的操作系统
https://learn.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
SQLServer 2014可以安装在Windows Server 2008 R2–Windows Server 2019的操作系统
https://learn.microsoft.com/en-us/previous-versions/sql/2014/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-2014#pmosr
Sqlserver 2016可以安装在Windows Server 2012–Windows Server 2022的操作系统
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver16#operating-system-support-for-sql-server-2016
Sqlserver 2017可以安装在Windows Server 2012–Windows Server 2022的操作系统
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver16#operating-system-support-for-sql-server-2017
Sqlserver 2019可以安装在Windows Server 2016–Windows Server 2022的操作系统
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver16#operating-system-support
Sqlserver 2022可以安装在Windows Server 2016–Windows Server 2022的操作系统
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16#operating-system-support
Sqlserver大版本下的各SP和CU下载路径
https://www.catalog.update.microsoft.com/search.aspx?q=sql%20server
批量打sp和cu的工具
https://dbatools.io/commands/
Sqlserver的中版本对应SP,小版本对应CU,SP和CU安装后(WSUS和手工安装的都一样)都可以在windows update中看到,也就是说它们安装成功后如果有问题都可以卸载
SP或CU可以安装在Enterprise\Developer\Standard等任何版本的SQL Server上,也就是说安装SP或CU后不会改变原来该SQL Server的Enterprise\Developer\Standard版本,官网https://www.microsoft.com/en-US/download/details.aspx?id=54276上System Requirements部分有如下一段话的描述
Service Pack 1 can be applied to any of the following Microsoft SQL Server 2016 editions:
Microsoft SQL Server 2016 Enterprise
Microsoft SQL Server 2016 Developer
Microsoft SQL Server 2016 Standard
Microsoft SQL Server 2016 Web
Microsoft SQL Server 2016 Express
Sqlserver2012的SP和CU列表及介绍
https://support.microsoft.com/en-us/topic/kb2755533-how-to-obtain-the-latest-service-pack-for-sql-server-2012-aea27612-81a4-357d-b6f6-c1eeb5966768
Sqlserver2014的SP和CU列表及介绍
https://support.microsoft.com/en-us/topic/kb2936603-sql-server-2014-build-versions-6f75da99-d86f-53fa-23ce-3d2b4825eccb
Sqlserver2016的SP和CU列表及介绍
https://support.microsoft.com/en-us/topic/kb3177312-sql-server-2016-build-versions-d6cd8e5f-4aa3-20ac-f38f-8faef950840f
Sqlserver2017的SP和CU列表及介绍
https://support.microsoft.com/en-us/topic/kb4047329-sql-server-2017-build-versions-346e8fcd-c07c-5eeb-e10b-e3411ba8d8dd
Sqlserver2019的SP和CU列表及介绍
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/build-versions
Sqlserver2012的SP和CU列表及介绍
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/build-versions
Sqlserver各Edition版本介绍
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16
Enterprise
The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization 1, and end-to-end business intelligence, enabling high service levels for mission-critical workloads and end-user access to data insights.Enterprise edition is available for evaluation. An evaluation deployment is available for 180 days. Review the version specific licensing guide for for details.
Standard
SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premises and cloud, enabling effective database management with minimal IT resources.
Web
SQL Server Web edition is a low total-cost-of-ownership option for Web hosters (including choosing Web edition on IaaS on Azure) and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large-scale Web properties.
Developer
SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications.
Express edition
SQL Server Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications. If you need more advanced database features, SQL Server Express can be seamlessly upgraded to other higher end versions of SQL Server. SQL Server Express LocalDB is a lightweight version of Express edition that has all of its programmability features, runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites.
Sqlserver 2016 的Edition和Scale limits介绍,Express版本数据库最大容量10GB
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver16
Sqlserver 2017 的Edition和Scale limits介绍,Express版本数据库最大容量10GB
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver16
Sqlserver 2019 的Edition和Scale limits介绍,Express版本数据库最大容量10GB
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16
Sqlserver 2022 的Edition和Scale limits介绍,Express版本数据库最大容量10GB
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16
Sqlserver各Edition版本报价
Sqlserver 2017报价
https://www.microsoft.com/en-us/sql-server/sql-server-2017#pricing
Sqlserver 2019报价
https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing
Sqlserver 2022报价
https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。