Полезные платные и бесплатные расширения для SQL Server Management Studio (SSMS) — полный список из 26 расширений. Github версия в формате markdown и кратким описанием каждого расширения на английском языке доступна на Github.
Для тех, кто возможно пропустил очень важную новость, — SSMS теперь является отдельным продуктом, релиз которого происходит ежемесячно, что позволяет внедрять новый функционал намного быстрее.
Скачать последнюю версию можно по официальной ссылке, на момент написания статьи актуальный релиз June 2016.
Сайт разработчика | Дата релиза | Совместимость | Разработчик | Бесплатная версия | Цена |
---|---|---|---|---|---|
SSMSBoost | 2015-12-21 | 2008/2012/2014 | Solutions Crew GmbH | Да | $150 |
SQL Code Guard | 2015-05-04 | 2008/2012/2014 | Oleksii Kovalov | Да | Нет |
SQL Search | 2015-11-05 | 2008/2012/2014 | Red Gate | Да | Нет |
SQL Scripts Manager | 2015-05-31 | 2008/2012/2014 | Red Gate | Да | Нет |
Red Gate SQL Test | 2015-11-17 | 2008/2012/2014 | Red Gate | Нет | $369 |
Red Gate SQL Source Control | 2016-02-03 | 2008/2012/2014 | Red Gate | Нет | $495 |
Supratimas | 2015-01-27 | 2008/2012/2014 | TTRider LLC | Да | $35 |
SSMS Tools Pack | 2015-10-07 | 2008/2012/2014 | Mladen Prajdić | Нет | €30 |
SQL Pretty Printer | 2015-11-05 | 2008/2012/2014 | Gudu Software | Нет | $50 |
SQL Sentry Plan Explorer | 2015-09-01 | 2008/2012/2014 | SQL Sentry | Да | $295 |
TSQL Code Smells Finder | 2013-02-15 | 2008/2012/2014 | Dave ballantyne | Да | Нет |
SQLTreeo | 2014-05-18 | 2008/2012/2014 | Jakub Dvorak | Нет | €50 |
ApexSQL Complete | 2016-04-01 | 2008/2012/2014 | ApexSQL tools | Да | Нет |
ApexSQL Refactor | 2016-02-11 | 2008/2012/2014 | ApexSQL tools | Да | Нет |
ApexSQL Search | 2015-09-04 | 2008/2012/2014 | ApexSQL tools | Да | Нет |
ApexSQL Source Control | 2015-04-27 | 2008/2012/2014 | ApexSQL tools | Нет | $299 |
Spotlight Developer | 2016-02-04 | 2008/2012/2014 | Spotlight Essentials | Да | Нет |
dbForge Source Control | 2015-12-22 | 2008/2012/2014 | Devart | Нет | $250 |
dbForge Unit Test | 2015-12-04 | 2008/2012/2014 | Devart | Нет | $200 |
dbForge Data Pump | 2015-12-04 | 2008/2012/2014 | Devart | Нет | $150 |
dbForge Index Manager | 2015-11-30 | 2008/2012/2014 | Devart | Нет | $100 |
dbForge Object Search | 2015-11-30 | 2008/2012/2014 | Devart | Да | Нет |
dbForge SQL Complete | 2016-07-20 | 2008/2012/2014 | Devart | Да | $120 |
SoftTree SQL Assistant | 2016-03-18 | 2008/2012/2014 | SoftTree | Нет | $179 |
SQL Enlight For SSMS | 2016-04-25 | 2008/2012/2014 | UbitSoft | Нет | $195 |
SQL Hunting Dog | 2016-03-03 | 2008/2012/2014 | Alex Maslyukov | Да | Нет |
Самое полезное расширение по моему субъективному мнению — это SSMSBoost.
Если в качестве основного иснтрумента для работы с SQL Server вы используете SSMS и при это ни разу не пробовали SSMSBoost, срочно установите данное расширение и включите его в список обязательных для каждого нового разработчика.
SSMSBoost
Download page: SSMSBoost
Release date: 2015-12-21
Support Version: 2008/2012/2014
Free version: Yes
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.
SQL Code Guard
Download link: SQL Code Guard
Release date: 2015-05-04
Support Version: 2008/2012/2014
Free version: Yes
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.
- Integration with SSMS 2008/2012/2014
- Integration with Visual Studio 2012/2013
- Checkin Policy for TFS (how to install & use)
- Support of msbuild (how to use msbuild)
- Command line utility (how to use command line utility).
- API for custom tool development (demo projects can be found in SQL Code Guard folder)
SQL Search
Download page: SQL Search
Release date: 2015-11-05
Support Version: 2008/2012/2014
Free version: Yes
SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.
- Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more
- Quickly navigate to objects wherever they happen to be on a server
- Search across multiple object types and multiple databases
- Find all references to an object
- Search with booleans and wildcards
SQL Scripts Manager
Download page: SQL Scripts Manager
Release date: 2015-05-31
Support Version: 2008/2012/2014
Free version: Yes
Powerful and reliable scripts written by SQL Server experts
Red Gate SQL Test
Download page: Red Gate SQL Test
Release date: 2015-11-17
Support Version: 2008/2012/2014
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: 2016-02-03
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $495
Connect your databases to your source control system
Supratimas
Download page: Supratimas
Release date: 2015-01-27
Support Version: 2008/2012/2014
Free version: Yes
SQL Server query plan execution visualizer
SSMS Tools Pack
Download page: SSMS Tools Pack
Release date: 2015-10-07
Support Version: 2008/2012/2014
Free version: No
- Keeps your query or window history safe in local files or database
- Run script at cursor location and an Accidental data destruction protector
- Keep your favorite statements accessible with a shortcut of your choice
- Format SQL
- Color the query windows based on the server/database name or a regex
- Add custom replacement texts to your scripts in four different features
- Modifies New Query windows with a template of your choice
- Run custom scripts from a chosen node in Object Explorer
SQL Pretty Printer
Download page: SQL Pretty Printer
Release date: 2015-11-05
Support Version: 2008/2012/2014
Free version: No
- improve SQL readability
- use a standard style within your organization
- use automatic formatting eliminates any disagreements
- embed well formatted and syntax colored SQL into your documents
- add SQL format feature within 5 minutes
- quickly convert between SQL and C#, Java, etc.
SQL Sentry Plan Explorer
Download page: SQL Sentry Plan Explorer
Release date: 2015-09-01
Support Version: 2008/2012/2014
Free version: Yes
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
Free version: Yes
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: 2014-05-18
Support Version: 2008/2012/2014
Free version: No
SQL Treeo enables users to create custom folders for databases, stored procedures, views, functions and tables. You can organize your SQL objects in logical modules which are aligned with your project structure.
ApexSQL Complete
Download page: ApexSQL Complete
Release date: 2015-09-04
Support Version: 2008/2012/2014/2016
Free version: Yes
With ApexSQL Complete you can:
- Automatically complete SQL statements
- Review an objects script and description
- Improve productivity with snippets
- Identify the structure of complex SQL queries
- Keep track of all your tabs
- Log every executed query
- Easily navigate to SQL objects
- Check queries in test mode
ApexSQL Refactor
Download page: ApexSQL Refactor
Release date: 2015-12-11
Support Version: 2008/2012/2014/2016
Free version: Yes
With ApexSQL Refactor you can:
- Format SQL with over 160 options
- Qualify objects and expand wildcards
- Encapsulate SQL into procedures
- Add surrogate keys
- Replace one-to-many relationships
- Change procedure parameters
- Safely rename SQL objects
- Locate & highlight unused variables
ApexSQL Search
Download page: ApexSQL Search
Release date: 2015-09-04
Support Version: 2008/2012/2014
Free version: Yes
With ApexSQL Search you can:
- Search for SQL objects
- Quickly find data in SQL tables
- Visualize relationships between objects
- Edit extended properties
- Easily navigate to result objects
- Rename SQL objects safely
ApexSQL Source Control
Download page: ApexSQL Source Control
Release date: 2015-04-27
Support Version: 2008/2012/2014
Free version: No
- Integrate SQL source control directly into SSMS
- Use dedicated or shared development models
- View conflicts and resolve directly in the UI
- View a detailed history of changes
- Lock objects to prevent overwrites
- Set team policies for check outs and locks
- Apply changes with dependency aware scripts
- Create and apply label from source control
Spotlight Developer
Download page: Spotlight Developer
Release date: 2016-02-14
Support Version: 2008/2012/2014
Free version: Yes
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: 2015-12-22
Support Version: 2008/2012/2014
Free version: No
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: 2015-12-04
Support Version: 2008/2012/2014
Free version: No
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: 2015-12-04
Support Version: 2008/2012/2014
Free version: No
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: 2015-11-30
Support Version: 2008/2012/2014
Free version: No
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 Object Search
Download page: dbForge Object Search
Release date: 2015-11-30
Support Version: 2008/2012/2014
Free version: Yes
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-07-20
Support Version: 2008/2012/2014
Free version: Yes
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
Free version: No/$178.80
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
- Advanced static analysis
- T-SQL code formatting
- Statements history
- Validate T-SQL code for syntax errors
- Script Summary
- Refactoring
- Continuous integration support
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
- Quickly find tables, stored procedure, functions and views
- Completely removes the pain of clunky Object Explorer
- Switch between different servers and databases
- Perform common operation (select data, modify table, design table, etc.) with ease
Уведомление: SQL Management studio автоподстановка - sql-server