📜 ⬆️ ⬇️

Full list of extensions for SQL Server Management Studio (SSMS)

Useful paid and free extensions for SQL Server Management Studio (SSMS) - a complete list of 29 extensions.


A github version in markdown format and a brief description of each extension in English is available on Github .


Also, you might be interested in other articles on Microsoft SQL Server:



For those who may have missed a very important news, SSMS is now a separate product, which is released monthly, which allows you to implement new functionality much faster.
You can download the latest version from the official link , at the time of this writing, the current release is June 2016 .


Developer sitedate of releaseCompatibilityDeveloperFree versionPrice
SSMSBoost2015-12-212008/2012/2014Solutions Crew GmbHYes$ 150
SqlSmash2016-07-312008/2012/2014/2016Smashing Jedis LLCYes$ 99
SQL Code Guard2015-05-042008/2012/2014Oleksii kovalovYesNot
SQL Search2015-11-052008/2012/2014Red gateYesNot
SQL Scripts Manager2015-05-312008/2012/2014Red gateYesNot
Red Gate SQL Test2015-11-172008/2012/2014Red gateNot$ 369
Red Gate SQL Source Control2016-02-032008/2012/2014Red gateNot$ 495
Supratimas2015-01-272008/2012/2014TTRider LLCYes$ 35
SSMS Tools Pack2015-10-072008/2012/2014Mladen PrajdićNot€ 30
SQL Pretty Printer2015-11-052008/2012/2014Gudu softwareNot$ 50
SQL Sentry Plan Explorer2015-09-012008/2012/2014SQL SentryYes$ 295
TSQL Code Smells Finder2013-02-152008/2012/2014Dave ballantyneYesNot
Sqltreeo2014-05-182008/2012/2014Jakub dvorakNot€ 50
ApexSQL Complete2016-04-012008/2012/2014ApexSQL toolsYesNot
ApexSQL Refactor2016-02-112008/2012/2014ApexSQL toolsYesNot
ApexSQL Search2015-09-042008/2012/2014ApexSQL toolsYesNot
ApexSQL Source Control2015-04-272008/2012/2014ApexSQL toolsNot$ 299
Spotlight Developer2016-02-042008/2012/2014Spotlight EssentialsYesNot
dbForge Source Control2015-12-222008/2012/2014DevartNot$ 250
dbForge Unit Test2015-12-042008/2012/2014DevartNot$ 200
dbForge Data Pump2015-12-042008/2012/2014DevartNot$ 150
dbForge Index Manager2015-11-302008/2012/2014DevartNot$ 100
dbForge Object Search2015-11-302008/2012/2014DevartYesNot
dbForge SQL Complete2016-07-202008/2012/2014DevartYes$ 120
SoftTree SQL Assistant2016-03-182008/2012/2014SofttreeNot$ 179
SQL Enlight For SSMS2016-04-252008/2012/2014UbitsoftNot$ 195
SQL Hunting Dog2016-03-032008/2012/2014Alex MaslyukovYesNot
Poor Mans T-SQL Formatter2013-10-232008/2012Tao klerksYesNot
Tabs studio2016-08-012012/2014/2016Vlasov StudioNo$ 49

In my previous article, The Complete List of Tools for Microsoft SQL Server , there were many comments in the comments related to the lack of a brief description of each utility for SQL Server.
Here is one of the significant comments:


<And what's the point in such a compilation? It is assumed that the reader clicks on all the utilities in order to understand what each of them is doing? They are here 143 and by name you can understand, God forbid, in 10%. Why not add at least a short description for each utility?


Anticipating the appearance of comments of this kind to this article, I will try to immediately answer them:


  1. Lists are primarily made purely for personal use, are published in Habré only as a starting point when looking for a convenient tool for working with SQL Server (I personally could not find more detailed and relevant lists who can do it, please let us know in the comments, it will help ).
  2. A brief description of each extension is in English (see Github ), and yes (answer to the comment above), the reader should call out a good one and choose only what is useful to him.
  3. If there is a useful tool that is not in the list, then you can always get a pull request on github or just write a comment about it.
  4. The location of the extensions in the list is made in the order of personal utility, i.e. on top are extensions that are constantly used in the work, below those that are poorly understood.
  5. All extensions were once downloaded and tested for compatibility with SQL Server 2012 and SQL Server 2014.

The most useful extension in my subjective opinion is SSMSBoost .
If you use SSMS as the main tool for working with SQL Server and have never tried SSMSBoost, immediately install this extension and include it in the list of required for each new developer.


Update 2016-09-02 : Added SqlSmash and Poor Mans T-SQL Formatter
Update 2016-12-12 : Tabs Studio has been added


')

Source: https://habr.com/ru/post/304036/


All Articles