Расширения для SQL Server Management Studio

Полный список полезных платных и бесплатных расширений для SQL Server Management Studio - 29 SSMS аддонов

Название/описание Официальная страница Дата релиза Версии SSMS Разработчик Бесплатная версия Цена
SSMSBoost SSMSBoost 2017-07-07 2008/2012/2014/2016/2017 Solutions Crew GmbH Yes $150
SqlSmash SqlSmash 2017-06-10 2008/2012/2014/2016/2017 Smashing Jedis LLC Yes $99
SQL Code Guard Red Gate SQL Code Guard 2017-07-03 2016 Red Gate Yes No
SQL Search SQL Search 2017-02-27 2008/2012/2014/2016/2017 Red Gate Yes No
SQL Scripts Manager SQL Scripts Manager 2015-05-31 2008/2012/2014 Red Gate Yes No
Red Gate SQL Test Red Gate SQL Test 2017-03-21 2008/2012/2014/2016/2017 Red Gate No $369
Red Gate SQL Source Control Red Gate SQL Source Control 2017-06-30 2012/2014/2016/2017 Red Gate No $495
Supratimas Supratimas 2017-07-11 2008/2012/2014/2016/2017 TTRider LLC Yes No
SSMS Tools Pack SSMS Tools Pack 2016-11-28 2008/2012/2014/2016 Mladen Prajdić No €30
SQL Pretty Printer SQL Pretty Printer 2015-11-05 2008/2012/2014 Gudu Software No $50
SQL Sentry Plan Explorer SQL Sentry Plan Explorer 2017-05-25 2008/2012/2014/2016/2017 SQL Sentry Yes No
TSQL Code Smells Finder TSQL Code Smells Finder 2013-02-15 2008/2012/2014 Dave ballantyne Yes No
SQLTreeo SQLTreeo 2017-06-06 2008/2012/2014/2016/2017 Jakub Dvorak No €50
ApexSQL Complete ApexSQL Complete 2017-04-13 2008/2012/2014/2016/2017 ApexSQL tools Yes No
ApexSQL Refactor ApexSQL Refactor 2017-05-08 2008/2012/2014/2016/2017 ApexSQL tools Yes No
ApexSQL Search ApexSQL Search 2017-04-13 2008/2012/2014/2016/2017 ApexSQL tools Yes No
ApexSQL Source Control ApexSQL Source Control 2017-03-30 2008/2012/2014/2016 ApexSQL tools No $299
Spotlight Developer Spotlight Developer 2016-02-04 2008/2012/2014 Spotlight Essentials Yes No
dbForge Source Control dbForge Source Control 2016-09-28 2005/2008/2012/2014/2016 Devart No $249
dbForge Unit Test dbForge Unit Test 2016-09-09 2008/2012/2014/2016 Devart No $199
dbForge Data Pump dbForge Data Pump 2016-09-16 2008/2012/2014/2016 Devart No $149
dbForge Index Manager dbForge Index Manager 2015-11-30 2008/2012/2014/2016 Devart No $99
dbForge Search dbForge Search 2017-04-20 2008/2012/2014/2016/2017 Devart Yes No
dbForge SQL Complete dbForge SQL Complete 2016-12-05 2008/2012/2014/2016/2017 Devart Yes $119
SoftTree SQL Assistant SoftTree SQL Assistant 2016-03-18 2008/2012/2014 SoftTree No $179
SQL Enlight For SSMS SQL Enlight For SSMS 2016-04-25 2008/2012/2014 UbitSoft No $195
SQL Hunting Dog SQL Hunting Dog 2016-03-03 2008/2012/2014 Alex Maslyukov Yes No
Poor Mans T-SQL Formatter Poor Mans T-SQL Formatter 2013-10-23 2008/2012 Tao Klerks Yes No
Tabs Studio Tabs Studio 2016-08-01 2012/2014/2016/2017 Vlasov Studio No $49
Workload Addin Workload Addin 2017-02-07 2008/2012 Tomáš Bauer Yes No
SQL Server Diagnostics SQL Server Diagnostics 2017-06-22 2016/2017 Microsoft Yes No
VersionSQL VersionSQL 2017-02-16 2012/2014/2016/2017 VersionSQL Yes $149

SSMSBoost

Download page: SSMSBoost
Release date: 2017-05-18
Support Version: 2008/2012/2014/2016/2017
Developer: Solutions Crew GmbH
Free version: Yes
Price: $150

SSMSBoost add-in adds missing features and improves your productivity when working with Microsoft SQL Server in SQL Server Management Studio.
The main goal of the project is to speed-up daily tasks of SQL DBA and SQL developers and to help you avoid destructive DML executions in production environments.

You will realize, that plug-in will save you hundreds of mouse-clicks and key strokes every day!

Licensing options: after 30 day trial period register and get fully-functional free community license or buy the professional version.
Currently both versions have the same set of features.

SqlSmash

Download page: SqlSmash
Release date: 2017-06-10
Support Version: 2008/2012/2014/2016/2017
Developer: Smashing Jedis LLC
Free version: Yes
Price: $99

Write maintainable SQL scripts, Understand code better and Navigate faster with SqlSmash, a productivity plugin for SQL Server Management Studio.

SQL Code Guard

Download link: Red Gate SQL Code Guard
Release date: 2017-02-17
Support Version: 2016
Developer: Red Gate
Free version: Yes
Price: No

SQL Code Guard is a free solution for SQL Server that provides fast and comprehensive static analysis for T-Sql code, shows code complexity and objects dependencies.

SQL Search

Download page: SQL Search
Release date: 2017-02-27
Support Version: 2008/2012/2014/2016/2017
Developer: Red Gate
Free version: Yes
Price: No

SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

SQL Scripts Manager

Download page: SQL Scripts Manager
Release date: 2015-05-31
Support Version: 2008/2012/2014
Developer: Red Gate
Free version: Yes
Price: No

Powerful and reliable scripts written by SQL Server experts

Red Gate SQL Test

Download page: Red Gate SQL Test
Release date: 2017-03-21
Support Version: 2008/2012/2014/2016/2017
Developer: Red Gate
Free version: No
Price: $369

Write unit tests (using the open-source tSQLt framework) for SQL Server databases in SQL Server Management Studio

Red Gate SQL Source Control

Download page: Red Gate SQL Source Control
Release date: 2017-06-30
Support Version: 2012/2014/2016/2017
Developer: Red Gate
Free version: No
Price: $495

Connect your databases to your source control system

Supratimas

Download page: Supratimas
Release date: 2017-07-11
Support Version: 2008/2012/2014/2017
Developer: TTRider LLC
Free version: Yes
Price: No

SQL Server query plan execution visualizer

SSMS Tools Pack

Download page: SSMS Tools Pack
Release date: 2016-11-28
Support Version: 2008/2012/2014/2016
Developer: Mladen Prajdić
Free version: No
Price: €30

SQL Pretty Printer

Download page: SQL Pretty Printer
Release date: 2015-11-05
Support Version: 2008/2012/2014
Developer: Gudu Software
Free version: No
Price: No

SQL Sentry Plan Explorer

Download page: SQL Sentry Plan Explorer
Release date: 2017-05-25
Support Version: 2008/2012/2014/2016/2017
Developer: SQL Sentry
Free version: Yes
Price: No

With both a free and PRO version, Plan Explorer builds upon the graphical plan view in SSMS to make query plan optimization more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database.

TSQL Code Smells Finder

Download page: TSQL Code Smells Finder
Release date: 2013-02-15
Support Version: 2008/2012/2014
Developer: Dave ballantyne
Free version: Yes
Price: No

TSQL Code can smell, it may work just fine but there can be hidden dangers held within. This is a proof of concept work which will analyze TSQL scripts in an attempt to weed out some of these dangers.

SQLTreeo

Download page: SQLTreeo
Release date: 2017-06-06
Support Version: 2008/2012/2014/2016/2017
Developer: Jakub Dvorak
Free version: No
Price: €50

ApexSQL Complete

Download page: ApexSQL Complete
Release date: 2017-04-13
Support Version: 2008/2012/2014/2016/2017
Developer: ApexSQL tools
Free version: Yes
Price: No

ApexSQL Refactor

Download page: ApexSQL Refactor
Release date: 2017-05-08
Support Version: 2008/2012/2014/2016/2017
Developer: ApexSQL tools
Free version: Yes
Price: No

With ApexSQL Refactor you can:

ApexSQL Search

Download page: ApexSQL Search
Release date: 2017-04-13
Support Version: 2008/2012/2014/2016/2017
Developer: ApexSQL tools
Free version: Yes
Price: No

With ApexSQL Search you can:

ApexSQL Source Control

Download page: ApexSQL Source Control
Release date: 2017-03-30
Support Version: 2008/2012/2014/2016
Developer: ApexSQL tools
Free version: No
Price: $299

Spotlight Developer

Download page: Spotlight Developer
Release date: 2016-02-14
Support Version: 2008/2012/2014
Developer: Spotlight Essentials
Free version: Yes
Price: No

Users of SQL Server Management Studio can monitor all their connections via a heatmap, alarms list and realtime diagnostics for FREE. Once installed and configured, users can monitor their connections immediately. The powerful monitoring features communicate important information regarding the status of connections. Severity is color coded so it’s easy to see at a glance what needs your attention. It is easy to connect Spotlight Developer to your Spotlight on SQL Server Diagnostic Server. This makes it possible for you to take advantage of data collections for all your connections in Spotlight on SQL Server. You also get a FREE System health Check, Performance Health Analysis and comprehensive information about your most expensive queries.

dbForge Source Control

Download page: dbForge Source Control
Release date: 2016-09-28
Support Version: 2005/2008/2008R2/2012/2014/2016
Developer: Devart
Free version: No
Price: $249

dbForge Source Control for SQL Server is a powerful SSMS add-in for managing SQL Server database changes in source control. The tool can link your databases to all popular source control systems, and delivers smooth and clear workflow in a familiar interface.

dbForge Unit Test

Download page: dbForge Unit Test
Release date: 2016-09-09
Support Version: 2005/2008/2008R2/2012/2014/2016
Developer: Devart
Free version: No
Price: $199

An intuitive and convenient GUI for implementing automated unit testing in SQL Server Management Studio. The tool is based on the open-source tSQLt framework, so SQL developers can now benefit from writing unit tests in regular T-SQL. dbForge Unit Test for SQL Server functionality allows you to develop stable and reliable code that can be properly regression tested at the unit level.

dbForge Data Pump

Download page: dbForge Data Pump
Release date: 2016-09-16
Support Version: 2005/2008/2008R2/2012/2014/2016
Developer: Devart
Free version: No
Price: $149

dbForge Data Pump for SQL Server is an SSMS add-in for filling SQL databases with external source data and migrating data between systems. The tool supports 10+ widely used data formats and includes a number of advanced options and templates for recurring scenarios.

dbForge Index Manager

Download page: dbForge Index Manager
Release date: 2016-09-16
Support Version: 2005/2008/2008R2/2012/2014/2016
Developer: Devart
Free version: No
Price: $99

dbForge Index Manager for SQL Server is a handy SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation. The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use. dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort.

dbForge Search

Download page: dbForge Search
Release date: 2017-04-20
Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016/2017
Developer: Devart
Free version: Yes
Price: No

dbForge Object Search for SQL Server is a FREE add-in for SQL Server Management Studio that allows you to search SQL objects and data in your databases. It can be very difficult to find a required table or to remember names of your stored routines, when a database contains lots of objects. With dbForge Object Search for SQL Server you no longer need to look through the entire SSMS Object Explorer to find a required object.

dbForge SQL Complete

Download page: dbForge SQL Complete
Release date: 2016-12-05
Support Version: SQL Server Compact/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016
Developer: Devart
Free version: Yes
Price: $119

dbForge SQL Complete provides a wide range of code completion features that relieve users from remembering long and complex object names, column names, SQL operators, etc., but instead allows concentrating on writing high-quality SQL code with proper formatting that is easy to understand and interpret.

SoftTree SQL Assistant

Download page: SoftTree SQL Assistant
Release date: 2016-03-18
Support Version: 2008/2012/2014
Developer: SoftTree
Free version: No
Price: $179

SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

SQL Enlight for SSMS

Download page: SQL Enlight for SSMS
Release date: 2016-04-25
Support Version: 2008/2012/2014
Developer: UbitSoft
Free version: No
Price: $195

SQL Hunting Dog

Download page: SQL Hunting Dog
Release date: 2016-03-03
Support Version: 2008/2012/2014
Developer: Alex Maslyukov
Free version: Yes
Price: No

Poor Mans T-SQL Formatter

Download page: Poor Mans T-SQL Formatter
Release date: 2013-10-23
Support Version: 2008/2012
Developer: Tao Klerks
Free version: Yes
Price: No

This formatter does implement a high-level SQL tokenizer and parser, but the granularity of the parser is not very high. It does not distinguish between different types of DML, it does not parse full expression trees, etc - there's a lot it doesn't do, it just does the bare minimum to support the target formatting.

Tabs Studio

Download page: Tabs Studio
Release date: 2016-08-01
Support Version: 2012/2014/2016/2017
Developer: Vlasov Studio
Free version: No
Price: $49

Tabs Studio is a Visual Studio and SSMS extension empowering you to work comfortably with any number of open documents.

Workload Addin

Download page: Workload Addin
Release date: 2017-02-07
Support Version: 2008/2012
Developer: Tomáš Bauer
Free version: Yes
Price: No

There are tools in SQL Server that allow to collect SQL statements for a certain period. The problem of these tools is that the amount of data recorded in this way may not be small and that the recorded data requires further processing. Also, work with these tools may not be easy. This article describes a tool that solves the problem described above. This tool can automatically collect information about executed SQL statements and it does their analysis and stores the required information in a custom SQL database, avoiding unnecessary or duplicate SQL statements being stored.

SQL Server Diagnostics

Download page: SQL Server Diagnostics
Release date: 2017-06-22
Support Version: 2016/2017
Developer: Microsoft
Free version: Yes
Price: No

SQL Server Diagnostics is a collection of micro-services which enables SQL Server customers to self-help and debug SQL Server issues related to memory dumps and receive recommended fixes for their issues.

VersionSQL

Download page: VersionSQL
Release date: 2017-02-16
Support Version: 2012/2014/2016/2017
Developer: VersionSQL
Free version: Yes
Price: $149

Lightweight add-in to connect your databases to your source control system