Antwort Is SQL 2016 still supported? Weitere Antworten – How long will SQL 2016 be supported

Is SQL 2016 still supported?
Support Dates

Listing Start Date Extended End Date
SQL Server 2016 Jun 1, 2016 Jul 14, 2026

SQL Server 2016 and older versions are not supported on Windows Server 2022 or Windows 11.You can perform the upgrade from DVD, from a mounted ISO, or from files extracted from an ISO image. Direct upgrades from SQL Server version prior to 2016 are not supported.

What is the current version of SQL Server 2016 : Latest updates available for currently supported versions of SQL Server

Version Latest service pack
SQL Server 2016 – Build information – Installation Azure Connect pack (13.0.7000.253 – May 2022) SP3 (13.0.6300.2 – September 2021) SP2 (13.0.5026.0 – April 2018) SP1 (13.0.4001.0 – November 2016)

What version of SQL Server is still supported

SQL Server Support dates

Version Release Date End of Mainstream Support
SQL Server 2022 16-11-2022 11-01-2028
SQL Server 2019 04-11-2019 07-01-2025
SQL Server 2017 29-09-2017 11-10-2022
SQL Server 2016 01-06-2016 13-07-2021

How long will SQL Server 2017 be supported : Support Dates

Listing Start Date Mainstream End Date
SQL Server 2017 Sep 29, 2017 Oct 11, 2022

The following requirements must be met to upgrade to SQL 2022. An overview of the most important requirements: You have to install the latest service pack for the existing SQL Server beforehand. On servers, Windows Server 2016 or greater must be in use.

Mainstream support for Windows Server 2016 ended on Jan. 11, 2022. Windows Server 2016 is part of the Windows NT family of OSes.

How to migrate SQL 2016 to 2022

Procedure

  1. To upgrade a previous version of SQL Server to SQL Server 2022 Express software, click this link, download and run SQLEXPR_x64_ENU.exe.
  2. In the SQL Server Installation Center window, click Installation.
  3. In the right pane, click Upgrade from a previous version of SQL Server.

Yes, it's possible to run multiple versions of Microsoft SQL Server on the same machine without major issues. Each version can operate independently, using separate instances and ports.July 14th, 2026 is the end of Extended Support for SQL Server 2016. At this time Microsoft will no longer provide non security updates to the version of SQL Server and for most, security updates will not be provided unless you are a part of the Extended Security Updates program.

Overview

Version Release Date End of Mainstream Support
SQL Server 2016 06/01/2016 07/13/2021
SQL Server 2017 09/29/2017 10/11/2022
SQL Server 2019 11/04/2019 02/28/2025
SQL Server 2022 11/16/2022 01/11/2028

Can I upgrade SQL Server 2017 to 2019 : To upgrade a previous version of SQL Server to SQL Server 2019 Express software, click this link, download and run SQLEXPR_x64_ENU.exe. Note: If you do not have a required prerequisite, a box appears and indicates what is missing. Click OK, install the missing prerequisite, and then restart the procedure.

Is SQL 2014 compatible with server 2022 : If you haven't already met Microsoft SQL Server 2022, it may be time to say 'hello. ' Especially if you're still running an older version like SQL 2012 or 2014. While SQL 2012 reached the end of support (EOS) on July 12, 2022, SQL 2014 is slated to end support on July 9, 2024.

How to update SQL 2016

Upgrading the SQL Server

  1. Log in as an administrator on the server (of the workstation for a standalone installation).
  2. Insert the SQL Server installation DVD into the DVD drive.
  3. Click Installation on the left panel, and then click Upgrade from a previous version of SQL Server on the right panel.


Windows Server Lifecycle Dates

Windows Server Release Support Start Date End of Extended Support
Windows Server 2012 25th November, 2013 10th October, 2023
Windows Server 2016 15th October, 2016 12th January, 2027
Windows Server 2019 13th November, 2018 9th January, 2029
Windows Server 2022 18th August, 2021 14th October, 2031

Microsoft Windows Operating Systems

Windows Server version Edition EOL Date
Windows Server 2016 Datacenter January 12, 2027
Standard January 12, 2027
Essentials January 12, 2027
Windows Server 2012 R2 Datacenter October 10, 2023

What is the latest version of SQL Server : The current version is Microsoft SQL Server 2022, released November 16, 2022. The RTM version is 16.0.1000.6.