As my Windows installation ages, it collects various versions of development tools, such as SQL Server, SQL Server Management Studio (SSMS), or Visual Studio.
But for every version of Windows the question is: will the next version of product X be installable on Windows Y?
So here is the answer for SQL Server and SSMS on Windows versions 7 (32-bit), 8.1 (64-bit) and 10 (64-bit)
| SQL/SSMS | Version | Win7-32 | Win8.1-64 | Win10-64 |
|---|---|---|---|---|
| 2008 | 10 | Y | ? | ? |
| 2012 | 11 | Y | Y | Y |
| 2014 | 12 | Y | Y | Y |
| SSMS 2016 | 13 | Y | Y | Y |
| SQL 2016 | 13 | – | Y | Y |
| SSMS 17 | 17 | – | Y | Y |
| SQL 2017 | 14 | – | Y | Y |
| SSMS 18 | 18 | – | Y | Y |
| SQL 2019 | 15 | – | – | Y |
