question

nikhithbirru-3837 avatar image
0 Votes"
nikhithbirru-3837 asked OlafHelper-2800 commented

REST API to get microsoft sql server version history

Is there any REST API to get all the Service Packs and respective latest cumulative packs for each SP of SQL Server Version?
expected results should be somewhere near around the table in this doc: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server?view=sql-server-ver15
I was able to scrap html content from this page but its not at all a reliable approach in long run.
Thanks in advance.

sql-server-generalsql-server-integration-services
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @nikhithbirru-3837,

Did you mean code a REST API for Microsoft SQL Server to get MS SQL server version history? If I misunderstood, please let us know.

0 Votes 0 ·

Thanks for getting back.
For our customers, we want to compare their on-prem SQL Server version to the latest one available in the market and suggest them if they need to upgrade the SQL Server based on few thresholds from our end.
We are looking for an API which gives all the available SQL Server version and their Service Packs. In each Service Pack what is the latest CU.

0 Votes 0 ·

In each Service Pack what is the latest CU.

Not a API, but a comprehensive site and always up-to-date with links for download:
https://sqlserverbuilds.blogspot.com/

2 Votes 2 ·

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

What's that good for?

MS SQL Server Release Services offers a RSS feed, which you/your app can consume.

https://techcommunity.microsoft.com/t5/sql-server/bg-p/SQLServer/label-name/SQLReleases

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.