Microsoft SQL Server Management Studio (SSMS) — это полноценная и удобная среда для работы с инфраструктурой SQL Server. Скачать SQL Server Management Studio можно с официального сайта, все ссылки представлены ниже. С её помощью вы можете управлять базами данных, настраивать сервер, отслеживать его состояние и производительность, а также выполнять администрирование — всё это через понятный графический интерфейс.
SSMS позволяет:
- Подключаться к любым версиям SQL Server и управлять ими;
- Разворачивать, обновлять и контролировать компоненты уровня данных, используемые в ваших приложениях (например, базы данных);
- Работать со скриптами на языках Transact-SQL (T-SQL), MDX, DMX и XML — с поддержкой подсветки синтаксиса, автодополнения и отладки кода.
Важно: Management Studio — это полностью автономное приложение, которое не привязано к конкретной версии SQL Server и не требует отдельной лицензии. То есть вы можете скачивать и использовать его бесплатно.
🔽 Как скачать SQL Server Management Studio (SSMS)
| Version | Alternative names | Build number | Release year | Download latest |
|---|---|---|---|---|
| SQL Server Management Studio 21 | SSMS 21 SSMS21 SSMS 2021 SSMS2021 SSMS 21.x |
21.0.x.x | Not released | |
| SQL Server Management Studio 20 | SSMS 20 SSMS20 SSMS 2020 SSMS2020 SSMS 20.x |
20.0.x.x | 2024 | Direct download 20.2 |
| SQL Server Management Studio 19 | SSMS 19 SSMS19 SSMS 2019 SSMS2019 SSMS 19.x |
19.0.x.x | 2023 | Direct download 19.3 |
| SQL Server Management Studio 18 | SSMS 18 SSMS18 SSMS 2018 SSMS2018 SSMS 18.x |
15.0.x.x | 2019 | Direct download 18.12.1 |
| SQL Server Management Studio 17 | SSMS 17 SSMS17 SSMS 2017 SSMS2017 SSMS 17.x |
14.0.x.x | 2017 | Direct download 17.9.1 |
| SQL Server Management Studio 16 | SSMS 16 SSMS16 SSMS 2016 SSMS2016 SSMS 16.x |
13.0.x.x | 2016 | Direct download 16.5.3 |
| Not standalone (integral part of SQL Server): | ||||
| SQL Server Management Studio 2014 | SSMS 2014 SSMS2014 SSMS 12 SSMS12 SSMS 12.x |
12.0.x.x | 2014 | Download 2014 |
| SQL Server Management Studio 2012 | SSMS 2012 SSMS2012 SSMS 11 SSMS11 SSMS 11.x |
11.0.x.x | 2012 | Download 2012 |
| SQL Server Management Studio 2008 R2 | SSMS 2008 R2 SSMS2008R2 SSMS 10.5 SSMS10.50 |
10.50.x.x | 2010 | Download 2008 R2 |
| SQL Server Management Studio 2008 | SSMS 2008 SSMS2008 SSMS 10 SSMS10 SSMS 10.x |
10.0.x.x | 2008 | Download 2008 |
| SQL Server Management Studio 2005 | SSMS 2005 SSMS2005 SSMS 9 SSMS9 SSMS 9.x |
9.0.x.x | 2005 | |
SSMS 18 can be installed side-by-side with SSMS 17 / 16 or SQL Server 2014 SSMS and earlier.
Build numbers:
| Version | Build | Description | Release date |
|---|---|---|---|
| 21.0 | 21.0.107.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 5) Beta | *new |
| 21.0 | 21.0.85.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 4.1) Beta | *new |
| 21.0 | 21.0.85.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 4) Beta | *new |
| 21.0 | 21.0.83.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 3) Beta | |
| 21.0 | 21.0.73.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 2.1) Beta | |
| 21.0 | 21.0.73.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 2) Beta | |
| 21.0 | 21.0.47.0 | SQL Server Management Studio (SSMS) 21.0 (Preview 1) Beta | |
| 20.2 | 20.2.30.0 | SQL Server Management Studio (SSMS) 20.2 Latest Direct download | |
| 20.1 | 20.1.10.0 | SQL Server Management Studio (SSMS) 20.1 | |
| 20.0 | 20.0.70.0 | SQL Server Management Studio (SSMS) 20.0 | |
| 20.0 | 20.0.65.0 | SQL Server Management Studio (SSMS) 20.0 (Preview 1) Beta | |
| 19.3 | 19.3.4.0 | SQL Server Management Studio (SSMS) 19.3 | |
| 19.2 | 19.2.56.2 | SQL Server Management Studio (SSMS) 19.2 | |
| 19.1 | 19.1.56.0 | SQL Server Management Studio (SSMS) 19.1 | |
| 19.0.2 | 19.0.20209.0 | SQL Server Management Studio (SSMS) 19.0.2 | |
| 19.0.1 | 19.0.20200.0 | SQL Server Management Studio (SSMS) 19.0.1 | |
| 19.0 | 19.0.20196.0 | SQL Server Management Studio (SSMS) 19.0 | |
| 19.0 | 19.0.20179.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 4) Beta | |
| 19.0 | 16.0.19061.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 3) Beta | |
| 19.0 | 16.0.19056.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 2) Beta | |
| 18.12.1 | 15.0.18424.0 | SQL Server Management Studio (SSMS) 18.12.1 | |
| 18.12 | 15.0.18420.0 | SQL Server Management Studio (SSMS) 18.12 | |
| 18.11.1 | 15.0.18410.0 | SQL Server Management Studio (SSMS) 18.11.1 | |
| 18.11 | 15.0.18404.0 | SQL Server Management Studio (SSMS) 18.11 | |
| 18.10 | 15.0.18390.0 | SQL Server Management Studio (SSMS) 18.10 | |
| 18.9.2 | 15.0.18386.0 | SQL Server Management Studio (SSMS) 18.9.2 | |
| 18.9.1 | 15.0.18384.0 | SQL Server Management Studio (SSMS) 18.9.1 | |
| 18.9 | 15.0.18382.0 | SQL Server Management Studio (SSMS) 18.9 | |
| 18.8 | 15.0.18369.0 | SQL Server Management Studio (SSMS) 18.8 | |
| 18.7.1 | 15.0.18358.0 | SQL Server Management Studio (SSMS) 18.7.1 | |
| 18.7 | 15.0.18357.0 | SQL Server Management Studio (SSMS) 18.7 | |
| 18.6 | 15.0.18338.0 | SQL Server Management Studio (SSMS) 18.6 | |
| 18.5.1 | 15.0.18333.0 | SQL Server Management Studio (SSMS) 18.5.1 | |
| 18.5 | 15.0.18330.0 | SQL Server Management Studio (SSMS) 18.5 | |
| 18.4 | 15.0.18206.0 | SQL Server Management Studio (SSMS) 18.4 | |
| 18.3.1 | 15.0.18183.0 | SQL Server Management Studio (SSMS) 18.3.1 | |
| 18.3 | 15.0.18178.0 | SQL Server Management Studio (SSMS) 18.3 Withdrawn | |
| 18.2 | 15.0.18142.0 | SQL Server Management Studio (SSMS) 18.2 | |
| 18.1 | 15.0.18131.0 | SQL Server Management Studio (SSMS) 18.1 | |
| 18.0 | 15.0.18118.0 | SQL Server Management Studio (SSMS) 18.0 | |
| 18.0 | 15.0.18116.0 | SQL Server Management Studio (SSMS) 18.0 Private Beta | |
| 18.0 | 15.0.18098.0 | SQL Server Management Studio (SSMS) 18.0 Release Candidate 1 (RC1) Beta | |
| 18.0 | 15.0.18092.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 7) Beta | |
| 18.0 | 15.0.18075.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 6) Beta | |
| 18.0 | 15.0.18068.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 5) Beta | |
| 18.0 | 15.0.18040.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 4) Beta | |
| 17.9.1 | 14.0.17289.0 | SQL Server Management Studio (SSMS) 17.9.1 | |
| 17.9 | 14.0.17285.0 | SQL Server Management Studio (SSMS) 17.9 | |
| 17.8.1 | 14.0.17277.0 | SQL Server Management Studio (SSMS) 17.8.1 | |
| 17.8 | 14.0.17276.0 | SQL Server Management Studio (SSMS) 17.8 Withdrawn | |
| 17.7 | 14.0.17254.0 | SQL Server Management Studio (SSMS) 17.7 | |
| 17.6 | 14.0.17230.0 | SQL Server Management Studio (SSMS) 17.6 | |
| 17.5 | 14.0.17224.0 | SQL Server Management Studio (SSMS) 17.5 | |
| 17.4 | 14.0.17213.0 | SQL Server Management Studio (SSMS) 17.4 | |
| 17.3 | 14.0.17199.0 | SQL Server Management Studio (SSMS) 17.3 | |
| 17.2 | 14.0.17177.0 | SQL Server Management Studio (SSMS) 17.2 | |
| 17.1 | 14.0.17119.0 | SQL Server Management Studio (SSMS) 17.1 | |
| 17.0 | 14.0.17099.0 | SQL Server Management Studio (SSMS) 17.0 | |
| 17.0 | 14.0.16140.0 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 3 (RC3) | |
| 17.0 | 14.0.16140.0 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 2 (RC2) | |
| 17.0 | 14.0.16000.64 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 1 (RC1) | |
| 16.5.3 | 13.0.16106.4 | SQL Server Management Studio (SSMS) 16.5.3 | |
| 16.5.2 | 13.0.16105.4 | SQL Server Management Studio (SSMS) 16.5.2 Withdrawn | |
| 16.5.1 | 13.0.16100.1 | SQL Server Management Studio (SSMS) 16.5.1 | |
| 16.5 | 13.0.16000.28 | SQL Server Management Studio (SSMS) 16.5 | |
| 16.4.1 | 13.0.15900.1 | SQL Server Management Studio (SSMS) 16.4.1 | |
| 16.4 | 13.0.15800.18 | SQL Server Management Studio (SSMS) 16.4 Withdrawn | |
| 16.3 | 13.0.15700.28 | SQL Server Management Studio (SSMS) 16.3 | |
| 13.0.15600.2 | SQL Server Management Studio (SSMS) July 2016 Hotfix Update | ||
| 13.0.15500.91 | SQL Server Management Studio (SSMS) July 2016 Withdrawn | ||
| 13.0.15000.23 | SQL Server Management Studio (SSMS) June 2016 | ||
| 13.0.14000.36 | SQL Server Management Studio (SSMS) April 2016 Preview | ||
| 13.0.13000.55 | SQL Server Management Studio (SSMS) March 2016 Preview Refresh | ||
| 13.0.12500.29 | SQL Server Management Studio (SSMS) March 2016 Preview Withdrawn | ||
| 13.0.12000.65 | SQL Server Management Studio (SSMS) February 2016 Preview | ||
| 13.0.11000.78 | SQL Server Management Studio (SSMS) January 2016 Preview | ||
| 13.0.900.73 | SQL Server Management Studio (SSMS) December 2015 Preview | ||
| 13.0.800.111 | SQL Server Management Studio (SSMS) November 2015 Preview | ||
| 13.0.700.242 | SQL Server Management Studio (SSMS) October 2015 Preview | ||
| 13.0.600.65 | SQL Server Management Studio (SSMS) September 2015 Preview | ||
| 13.0.500.53 | SQL Server Management Studio (SSMS) August 2015 Preview | ||
| 13.0.400.91 | SQL Server Management Studio (SSMS) July 2015 Preview | ||
| 13.0.300.44 | SQL Server Management Studio (SSMS) June 2015 Preview |