Creates a T-SQL script to build a table with all supported SQL Server versions and their support dates
Download the latest release. There are two versions of the application:
- a self-contained .NET Core app (.exe) that runs on 64-bit Windows
- run this by extracting the zip and running GetSqlServerVersionInfo.exe
- a (much smaller) Framework-dependent deployment of the .NET Core app (.dll) that run on 64-bit Windows
- requires .NET Core to be present on the machine
- this can be run from the command line by extracting the zip and running
By default, a file named SqlServerVersions.sql will be created in the same directory where you ran the application. To specify a destination folder, pass the path as a command line argument:
GetSqlServerVersionInfo.exe "C:\Temp" // or dotnet GetSqlServerVersionInfo.dll "C:\Temp"
See the \src\SqlServerVersions-2018-05-22.sql in this repository for an example of the output of the application.
How it works
The applications reads information from Microsoft's support site.
Mainstream and extended support dates come from this API endpoint, which is accessed by clicking the "Export" link on this page
All other information (build number, branch, KB article, release date, etc) come from the tables at the bottom of this web page: