How to get SqlServerBuilds data programmatically?
All SQL Server builds are available in a public Google Sheet here:
https://docs.google.com/spreadsheets/d/16Ymdz80xlCzb6CwRFVokwo0onkofVYFoSkc7mYe6pgw/viewGoogle Sheet can be downloaded in these formats:
It can also be downloaded using a program:
Example 1: All SQL Server 2017 builds
Windows PowerShell – file Download.ps1
:
Add-Type -Assembly System.Web # [System.Web.HttpUtility]::UrlEncode() needs this $SqlVersion = "2017" $Query = "select * where A='" + $SqlVersion + "'" $URL = "https://docs.google.com/spreadsheets/d/16Ymdz80xlCzb6CwRFVokwo0onkofVYFoSkc7mYe6pgw/gviz/tq?tq=" ` + [System.Web.HttpUtility]::UrlEncode($Query) ` + "&tqx=out:csv" Invoke-WebRequest $URL -OutFile "C:\Temp\SqlServerBuilds.csv"
Run:
PowerShell.exe -ExecutionPolicy Unrestricted .\Download.ps1
Typical result – content of the file SqlServerBuilds.csv
:
"SQLServer","Version","Build","FileVersion","Description","Link","ReleaseDate","SP","CU","HF","RTM","CTP","New" "2017","14","14.0.3238.1","2017.140.3238.1","Cumulative update 17 (CU17) for SQL Server 2017","https://support.microsoft.com/en-us/help/4515579","2019-10-08","","TRUE","","","","" "2017","14","14.0.3223.3","2017.140.3223.3","Cumulative update 16 (CU16) for SQL Server 2017","https://support.microsoft.com/en-us/help/4508218","2019-08-01","","TRUE","","","","" "2017","14","14.0.3208.1","2017.140.3208.1","On-demand hotfix update package 2 for SQL Server 2017 Cumulative update 15 (CU15)","https://support.microsoft.com/en-us/help/4510083","2019-07-09","","","TRUE","","","" "2017","14","14.0.3192.2","2017.140.3192.2","Security update for SQL Server 2017 CU15 GDR: July 9, 2019","https://support.microsoft.com/en-us/help/4505225","2019-07-09","","","","","","" "2017","14","14.0.3164.1","2017.140.3164.1","On-demand hotfix update package for SQL Server 2017 Cumulative update 15 (CU15)","https://support.microsoft.com/en-us/help/4506633","2019-06-20","","","TRUE","","","" "2017","14","14.0.3162.1","2017.140.3162.1","Cumulative update 15 (CU15) for SQL Server 2017","https://support.microsoft.com/en-us/help/4498951","2019-05-24","","TRUE","","","","" "2017","14","14.0.3103.1","2017.140.3103.1","Security update for SQL Server 2017 Cumulative update 14 (CU14): May 14, 2019","https://support.microsoft.com/en-us/help/4494352","2019-05-14","","","","","","" "2017","14","14.0.3076.1","2017.140.3076.1","Cumulative update 14 (CU14) for SQL Server 2017","https://support.microsoft.com/en-us/help/4484710","2019-03-25","","TRUE","","","","" "2017","14","14.0.3049.1","2017.140.3049.1","On-demand hotfix update package for SQL Server 2017 Cumulative update 13 (CU13)","https://support.microsoft.com/en-us/help/4483666","2019-01-08","","","TRUE","","","" "2017","14","14.0.3048.4","2017.140.3048.4","Cumulative update 13 (CU13) for SQL Server 2017","https://support.microsoft.com/en-us/help/4466404","2018-12-18","","TRUE","","","","" ...
Example 2: RTM + all Cumulative Updates (CUs) for SQL Server 2017
Windows PowerShell – file Download.ps1
:
Add-Type -Assembly System.Web # [System.Web.HttpUtility]::UrlEncode() needs this $Query = "select C,E,F,G where A='2017' and (I='TRUE' or K='TRUE')" $URL = "https://docs.google.com/spreadsheets/d/16Ymdz80xlCzb6CwRFVokwo0onkofVYFoSkc7mYe6pgw/gviz/tq?tq=" ` + [System.Web.HttpUtility]::UrlEncode($Query) ` + "&tqx=out:csv" Invoke-WebRequest $URL -OutFile "C:\Temp\SqlServerBuilds.csv"
Run:
PowerShell.exe -ExecutionPolicy Unrestricted .\Download.ps1
Typical result – content of the file SqlServerBuilds.csv
:
"Build","Description","Link","ReleaseDate" "14.0.3238.1","Cumulative update 17 (CU17) for SQL Server 2017","https://support.microsoft.com/en-us/help/4515579","2019-10-08" "14.0.3223.3","Cumulative update 16 (CU16) for SQL Server 2017","https://support.microsoft.com/en-us/help/4508218","2019-08-01" "14.0.3162.1","Cumulative update 15 (CU15) for SQL Server 2017","https://support.microsoft.com/en-us/help/4498951","2019-05-24" "14.0.3076.1","Cumulative update 14 (CU14) for SQL Server 2017","https://support.microsoft.com/en-us/help/4484710","2019-03-25" "14.0.3048.4","Cumulative update 13 (CU13) for SQL Server 2017","https://support.microsoft.com/en-us/help/4466404","2018-12-18" "14.0.3045.24","Cumulative update 12 (CU12) for SQL Server 2017","https://support.microsoft.com/en-us/help/4464082","2018-10-24" "14.0.3038.14","Cumulative update 11 (CU11) for SQL Server 2017","https://support.microsoft.com/en-us/help/4462262","2018-09-21" "14.0.3037.1","Cumulative update 10 (CU10) for SQL Server 2017","https://support.microsoft.com/en-us/help/4342123","2018-08-27" "14.0.3030.27","Cumulative update 9 (CU9) for SQL Server 2017","https://support.microsoft.com/en-us/help/4341265","2018-07-18" "14.0.3029.16","Cumulative update 8 (CU8) for SQL Server 2017","https://support.microsoft.com/en-us/help/4338363","2018-06-21" "14.0.3026.27","Cumulative update 7 (CU7) for SQL Server 2017","https://support.microsoft.com/en-us/help/4229789","2018-05-23" "14.0.3025.34","Cumulative update 6 (CU6) for SQL Server 2017","https://support.microsoft.com/en-us/help/4101464","2018-04-19" "14.0.3023.8","Cumulative update 5 (CU5) for SQL Server 2017","https://support.microsoft.com/en-us/help/4092643","2018-03-20" "14.0.3022.28","Cumulative update 4 (CU4) for SQL Server 2017","https://support.microsoft.com/en-us/help/4056498","2018-02-17" "14.0.3015.40","Cumulative update 3 (CU3) for SQL Server 2017","https://support.microsoft.com/en-us/help/4052987","2018-01-04" "14.0.3008.27","Cumulative update 2 (CU2) for SQL Server 2017","https://support.microsoft.com/en-us/help/4052574","2017-11-28" "14.0.3006.16","Cumulative update 1 (CU1) for SQL Server 2017","https://support.microsoft.com/en-us/help/4038634","2017-10-23" "14.0.1000.169","Microsoft SQL Server 2017 RTM","https://www.microsoft.com/en-us/sql-server/sql-server-downloads","2017-10-02"
Example 3: All supported SQL Server releases
Windows PowerShell – file Download.ps1
:
Add-Type -Assembly System.Web # [System.Web.HttpUtility]::UrlEncode() needs this $Query = "select * where J<>'TRUE'" $URL = "https://docs.google.com/spreadsheets/d/16Ymdz80xlCzb6CwRFVokwo0onkofVYFoSkc7mYe6pgw/gviz/tq?gid=1648964847&tq=" ` + [System.Web.HttpUtility]::UrlEncode($Query) ` + "&tqx=out:csv" Invoke-WebRequest $URL -OutFile "C:\Temp\SqlServerReleases.csv"
Run:
PowerShell.exe -ExecutionPolicy Unrestricted .\Download.ps1
Typical result – content of the file SqlServerReleases.csv
:
"Release","FullName","Version","DatabaseCompatibilityLevel","InternalDatabaseVersion","ReleaseDate","MainstreamSupportEnds","ExtendedSupportEnds","IsLatest","IsObsolete","IsBeta" "2019","SQL Server 2019","15.0","150","904","2019-11-04","2025-01-07","2030-01-08","TRUE","","" "2017","SQL Server 2017","14.0","140","869","2017-10-02","2022-10-11","2027-10-12","","","" "2016","SQL Server 2016","13.0","130","852","2016-06-01","2021-07-13","2026-07-14","","","" "2014","SQL Server 2014","12.0","120","782","2014-04-01","2019-07-09","2024-07-09","","","" "2012","SQL Server 2012","11.0","110","706","2012-03-06","2017-07-11","2022-07-12","","",""
Based on:
- Google Visualization API Query Language
- Implementing the Chart Tools Datasource Protocol › Response Format
© 2007–2021 SqlServerBuilds.blogspot.com · Contact · Privacy policy
Other useful sites › Exchange Server Version List | SharePoint Server Version List | Microsoft Knowledge Base Monitoring