Full list of tools and utilities for Microsoft SQL Server

Useful paid and free utilities, tools for Microsoft SQL Server - a complete list of 165 tools.

Github version in markdown format and a brief description of each utility in English here .

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

The main purpose of the tool, in curly brackets is the current number of utilities of this type:

[MS] : SSMS Analogs {12}
[B] : Work with backups {5}
[M] : Means of monitoring and warning {5}
[I] : Embedded SQL Server tools (for example, bcp) {13}
[T] : Testing Tools {3}
[G] : Test data generation {4}
[D] : Documentation Creation Tools {2}
[S] : Search utilities {2}
[DC] : Tools compared data {9}
[SC] : Tools compared database structure {13}
[J] : Job Management (Job) {2}
[IDX] : Managing Indexes {1}
[ST] : Working with statistics {3}
[DA] : Database Design {10}
[?] : Not yet classified {86}

Official page	Other databases	OS	Purpose	date of release	Developer	Free version	Price
SSMS	Not	Not	[MS]	2016-07-13	Microsoft	Yes	Not
bcp utility	Not	Not	[I]	2012-02-11	Microsoft	Yes	Not
RML Utilities for SQL Server	Not	Not	[T]	2014-12-12	Microsoft	Yes	Not
Graphview	Not	Not	[?]	2016-02-23	Microsoft	Yes	Not
Baseline Security Analyze	Not	Not	[?]	2015-01-09	Microsoft	Yes	Not
tablediff utility	Not	Not	[I]	-	Microsoft	Yes	Not
Microsoft Log Parser	Not	Not	[?]	-	Microsoft	Yes	Not
Diskspd	Not	Not	[T]	2015-12-14	Microsoft	Yes	Not
HammerDB	Not	Not	[T]	2015-05-04	Open source	Yes	Not
Exchange Server Error Code Look-up	Not	Not	[?]	2004-05-10	Microsoft	Yes	Not
LINQPad	Not	Not	[?]	2016-01-02	Joseph albahari	Yes	$ 45
SqlDynamite	Not	Not	[S]	2016-04-06	Anatoly sova	Yes	Not
SQL Server Data Tools	Not	Not	[MS]	2016-04-14	Microsoft	Yes	Not
Database Health Monitor	Not	Not	[M]	2016-03-20	Steve stedman	Yes	Not
SchemaDrift	Not	Not	[SC]	2016-02-28	Steve stedman	Yes	Not
Dbeaver	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[MS]	2016-06-06	Open source	Yes	Not
HeidiSQL	Oracle, MySQL, PostgreSQL, Other	Not	[MS]	2016-06-19	Open source	Yes	Not
SQLExecStats	Not	Not	[ST]	2016-02-08	Joe chang	Yes	Not
ExpressProfiler	Not	Not	[?]	2016-02-15	Chris Moore	Yes	Not
dta Utility	Not	Not	[I]	-	Microsoft	Yes	Not
osql utility	Not	Not	[I]	-	Microsoft	Yes	Not
sqldiag utility	Not	Not	[I]	-	Microsoft	Yes	Not
sqldumper utility	Not	Not	[I]	-	Microsoft	Yes	Not
SqlLocalDB Utility	Not	Not	[I]	-	Microsoft	Yes	Not
sqllogship utility	Not	Not	[I]	-	Microsoft	Yes	Not
sqlservr Application	Not	Not	[I]	-	Microsoft	Yes	Not
sqlps utility	Not	Not	[I]	-	Microsoft	Yes	Not
sqlmaint utility	Not	Not	[I]	-	Microsoft	Yes	Not
Ssms utility	Not	Not	[I]	-	Microsoft	Yes	Not
dtexec utility	Not	Not	[I]	-	Microsoft	Yes	Not
BPA 2005	Not	Not	[?]	2008-08-13	Microsoft	Yes	Not
BPA 2000	Not	Not	[?]	2010-04-26	Microsoft	Yes	Not
BPA 2008	Not	Not	[?]	2010-06-18	Microsoft	Yes	Not
BPA 2012	Not	Not	[?]	2012-06-04	Microsoft	Yes	Not
DLM Dashboard	Not	Not	[M]	2016-04-27	Red gate	Yes	Not
Red Gate SQL Compare	Not	Not	[DC]	2016-05-09	Red gate	Not	$ 495
Red Gate SQL Data Compare	Not	Not	[SC]	2016-05-09	Red gate	Not	$ 495
Red Gate SQL Prompt	Not	Not	[MS]	2016-04-28	Red gate	Not	$ 369
Red Gate SQL Monitor	Not	Not	[M]	2015-10-15	Red gate	Not	$ 1495
Red Gate SQL Backup Pro	Not	Not	[B]	2014-07-08	Red gate	Not	$ 995
Red Gate SQL Doc	Not	Not	[D]	2016-04-26	Red gate	Not	$ 369
Red Gate SQL Data Generator	Not	Not	[G]	2016-04-26	Red gate	Not	$ 369
Red Gate SQL Dependency Tracker	Not	Not	[?]	2016-04-26	Red gate	Not	$ 369
Red Gate SQL Multi Script	Not	Not	[?]	2016-04-15	Red gate	Not	$ 245
Red Gate SQL Index Manager	Not	Not	[IDX]	?	Red gate	Not	$ 149
Red Gate SQL Comparison SDK	Not	Not	[DC], [SC]	2016-02-22	Red gate	Not	$ 895
DLM Automation	Not	Not	[?]	?	Red gate	Not	?
ReadyRoll	Not	Not	[?]	2016-01-03	Red gate	Not	$ 345
SQL XEvent Profiler	Not	Not	[?]	2014-03-14	Idera	Yes	Not
SQL Check	Not	Not	[?]	2015-09-24	Idera	Yes	Not
SQL Fragmentation Analyzer	Not	Not	[?]	2012-11-16	Idera	Yes	Not
SQL Heat Map	Not	Not	[?]	2016-01-27	Idera	Yes	Not
SQL Hekaton Memory Check	Not	Not	[?]	2015-06-10	Idera	Yes	Not
SQL Page Viewer	Not	Not	[?]	2014-08-25	Idera	Yes	Not
SQL Update Statistics	Not	Not	[ST]	2015-12-14	Idera	Yes	Not
SQL Statistics Aggregator	Not	Not	[ST]	2015-05-18	Idera	Yes	Not
SQL Backup Status Reporter	Not	Not	[B]	2015-08-07	Idera	Yes	Not
SQL Integrity Check	Not	Not	[?]	2013-08-26	Idera	Yes	Not
SQL Job Manager	Not	Not	[J]	2012-03-19	Idera	Yes	Not
Azure SQL Database Backup	Not	Not	[?]	2012-10-02	Idera	Yes	Not
SQL Column Search	Not	Not	[S]	2015-11-17	Idera	Yes	Not
SQL Permissions Extractor	Not	Not	[?]	2015-08-07	Idera	Yes	Not
SQL BI Check	Not	Not	[?]	2016-04-13	Idera	Yes	Not
SQL Inventory Check	Not	Not	[?]	2016-03-24	Idera	Yes	Not
SQL Diagnostic Manager	Not	Not	[?]	?	Idera	Not	$ 1747
SQL Safe Backup	Not	Not	[B]	2016-09-08	Idera	Not	$ 907
SQL Compliance Manager	Not	Not	[?]	2015-09-08	Idera	Not	$ 2657
SQL Inventory Manager	Not	Not	[?]	2016-04-22	Idera	Not	$ 3195
SQL Virtual Database	Not	Not	[?]	2016-03-24	Idera	Not	$ 625
SQL Secure	Not	Not	[?]	2016-04-19	Idera	Not	$ 907
SQL Doctor	Not	Not	[?]	2015-12-17	Idera	Not	$ 625
SQL Admin Toolset	Not	Not	[?]	2016-01-13	Idera	Not	$ 395
SQL Defrag Manager	Not	Not	[?]	2016-03-10	Idera	Not	$ 1495
DBArtisan	Not	Not	[?]	?	Idera	Not	$ 3122
SQL BI Manager	Not	Not	[?]	2015-09-08	Idera	Not	$ 697
SQL Enterprise Job Manager	Not	Not	[J]	2015-09-08	Idera	Not	$ 697
DB Optimizer	Not	Not	[?]	?	Idera	Not	$ 1420
SQL Query Store Optimizer	Not	Not	[?]	2016-07-01	Idera	Yes	Not
Rapid sql	Oracle, MySQL, PostgreSQL, Other	Not	[MS]	?	Idera	Not	$ 710
SQL Comparison Toolset	Not	Not	[DC], [SC]	?	Idera	Not	$ 745
ER / Studio Data Architect	Oracle, MySQL, PostgreSQL, Other	Not	[DA]		Idera	Not	$ 1287
DB Change Manager	Oracle, MySQL, PostgreSQL, Other	Not	[SC]	?	Idera	Not	$ 1420
dbForge Schema Compare	Not	Not	[SC]	2015-12-22	Devart	Not	$ 149
dbForge Data Compare	Not	Not	[DC]	2015-11-30	Devart	Not	$ 149
dbForge Data Generator	Not	Not	[G]	2015-12-30	Devart	Not	$ 249
dbForge Query Builder	Not	Not	[?]	2015-06-03	Devart	Not	$ 100
dbForge Event Profiler	Not	Not	[?]	2015-04-08	Devart	Yes	Not
dbForge SQL Decryptor	Not	Not	[?]	2013-11-07	Devart	Yes	Not
dbForge Studio	Not	Not	[MS]	2015-12-18	Devart	Yes	$ 250
dbForge Fusion	Not	Not	[?]	2016-03-03	Devart	Not	$ 150
Minion Enterprise	Not	Not	[?]	?	Minionware	Not	$ 1500
SQL Server Compression Estimator	Not	Not	[?]	2011-06-02	Bob tavlor	Yes	Not
Cleartrace	Not	Not	[?]	2015-07-04	Bill graziano	Yes	Not
SQLSentry Fragmentation Manager	Not	Not	[?]	2016-03-08	SQLSentry	Not	$ 795
SQLSentry Plan Explorer	Not	Not	[?]	2016-01-28	SQLSentry	Yes	$ 295
SQLSentry Event Manager	Not	Not	[M]	2016-03-08	SQLSentry	Not	$ 995
SQLSentry Performance Advisor	Not	Not	[?]	2016-03-08	SQLSentry	Not	?
Dell security explorer	Not	Not	[?]	2015-06-25	Dell	Not	$ 850
Dell LiteSpeed for SQL Server	Not	Not	[?]	2015-07-31	Dell	Not	?
Dell Toad for SQL Server	Not	Not	[MS]	2015-05-12	Dell	Not	?
Dell spotlight	Not	Not	[?]	2016-03-10	Dell	Not	$ 2561
Dell foglight	Not	Not	[?]	2015-09-22	Dell	Not	?
Dell Discovery Wizard	Not	Not	[?]	2011-09-22	Dell	Yes	Not
Dell Enterprise Reporter	Not	Not	[?]	?	Dell	Not	$ 511
SQLSolutions SQL Deadlock Detector	Not	Not	[?]	2013-05-16	SQLSolutions	Not	$ 295
SQLSolutions SQL Heartbeat	Not	Not	[?]	2013-03-03	SQLSolutions	Not	$ 295
SQLSolutions SQL Trace Analyzer	Not	Not	[?]	2013-12-09	SQLSolutions	Not	$ 495
SQLSolutions SQL Ultimate Debugger	Not	Not	[?]	-	SQLSolutions	Not	$ 295
SQL Scripter	Not	Not	[?]	2013-02-24	Thomas Hinsenkamp	Not	€ 99
Simple Dynamic Scheduler	Not	Not	[?]	2016-05-02	Miljan radovic	Yes	Not
ApexSQL Audit	Not	Not	[?]	2016-04-08	ApexSQL	Not	$ 1699
ApexSQL Backup	Not	Not	[B]	2015-12-30	ApexSQL	Not	$ 499
ApexSQL Log	Not	Not	[?]	2015-11-23	ApexSQL	Not	$ 1999
ApexSQL Monitor	Not	Not	[M]	2015-12-29	ApexSQL	Not	$ 499
ApexSQL Recover	Not	Not	[?]	2015-01-21	ApexSQL	Not	$ 1999
ApexSQL Restore	Not	Not	[?]	2014-08-12	ApexSQL	Not	$ 399
ApexSQL Build	Not	Not	[?]	2015-12-22	ApexSQL	Not	$ 399
ApexSQL Clean	Not	Not	[?]	2015-09-04	ApexSQL	Not	$ 399
ApexSQL Data Diff	Not	Not	[DC]	2015-12-11	ApexSQL	Not	$ 399
ApexSQL Diff	Not	Not	[SC]	2016-03-23	ApexSQL	Not	$ 399
ApexSQL Doc	Not	Not	[D]	2015-04-19	ApexSQL	Not	$ 299
ApexSQL Generate	Not	Not	[G]	2016-03-15	ApexSQL	Not	$ 499
ApexSQL Script	Not	Not	[?]	2015-09-11	ApexSQL	Not	$ 249
ApexSQL Trigger	Not	Not	[?]	2015-09-04	ApexSQL	Not	$ 1999
DBBest T-SQL Analyzer	Not	Not	[?]	2015-03-13	DBBest	Not	$ 89
DBBest Database Compare Suite	Not	Not	[SC], [DC]	2015-09-04	DBBest	Not	$ 349
Advanced query tool	Not	Not	[?]	2015-03-18	Cardett associates	Not	$ 180
SqlDiffFramework	Not	Not	[SC]	2012-04-17	Michael Sorens	Yes	Not
Datagrip	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[MS]	2016-05-06	Jet brains	Not	$ 199
Pssdiag and Sqldiag Manager	Not	Not	[?]	2015-04-17	Jack li	Yes	Not
SQL Nexus Tool	Not	Not	[?]	2014-03-11	Jack li	Yes	Not
DBSophic Qure Profiler	Not	Not	[?]	?	DBSophic	Not	$ 300
DBSophic Qure Optimizer	Not	Not	[?]	?	DBSophic	Not	?
RestoreChecker	Not	Not	[?]	2015-01-15	SQLServerUtilities	Not	$ 99
SQLScripter	Not	Not	[?]	2009-08-24	SQLServerUtilities	Not	$ 99
SQLC	Not	Not	[DC], [SC]	2016-05-23	David Ingleton	Yes	Not
Database Performance Analyzer	Not	Not	[?]	?	Solarwinds	Not	$ 1995
SQL Enlight	Not	Not	[MS]	2016-04-25	Ubitsoft	Not	$ 295
Omnicompare	Not	Not	[SC]	2016-06-03	AireForge	Yes	Not
HexaTier	Not	Not	[?]	?	HexaTier	Not	?
SoftTree SQL Assistant	Not	Not	[?]	2016-03-18	Softtree	Not	$ 270
EMS SQL Management Studio	Not	Not	[MS]	2016-05-26	EMS	Not	$ 257
EMS SQL Backup	Not	Not	[B]	2016-04-13	EMS	Yes	$ 82
EMS SQL Administrator	Not	Not	[?]	2015-04-14	EMS	Yes	$ 135
EMS SQL Manager	Not	Not	[?]	2016-05-26	EMS	Yes	$ 135
EMS Data Export	Not	Not	[?]	2016-04-29	EMS	Not	$ 47
EMS Data Import	Not	Not	[?]	2016-04-14	EMS	Not	$ 47
EMS Data Pump	Not	Not	[?]	2016-11-03	EMS	Not	$ 47
EMS Data Generator	Not	Not	[G]	2010-07-10	EMS	Not	$ 47
EMS DB Comparer	Not	Not	[SC]	2015-07-24	EMS	Not	$ 47
EMS DB Extract	Not	Not	[?]	2008-10-16	EMS	Not	$ 47
EMS SQL Query	Not	Not	[?]	2012-03-29	EMS	Not	$ 47
EMS Data Comparer	Not	Not	[DC]	2012-11-16	EMS	Not	$ 47
Nitroaccelerator	Not	Not	[?]	2016-07-10	Nitrosphere	Not	$ 1265
ERwin Data Modeler	Oracle, MySQL, PostgreSQL, Other	Not	[DA]	2016-06-03	Erwin	Not	$ 810
Toad data modeler	Oracle, MySQL, PostgreSQL, Other	Not	[DA]	2016-06-16	Dell	Not	$ 562
SQL Power Architect	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[DA]	2016-02-11	SQLPower	Yes	$ 995
Dbwrench	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[DA]	2016-07-06	Nizana Systems	Not	$ 99
Navicat Data Modeler	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[DA]	2016-08-01	Premiumsoft	Not	$ 199
DeZign for Databases	Oracle, MySQL, PostgreSQL, Other	Not	[DA]	2016-04-25	Datanamic	Not	$ 259
ERDesigner NG	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[DA]	2013-04-10	Mirko sertic	Open source	Not
Vertabelo	Oracle, MySQL, PostgreSQL, Other	Online	[DA]	?	Vertabelo	Not	$ 948
dbDiffo	Oracle, MySQL, PostgreSQL, Other	Online	[DA]	?	Contenet Ltd	Yes	Not
SQL DXP	Oracle, MySQL	Not	[DC], [SC]	2016-06-20	SQL Delta	Not	$ 530
Aqua Data Studio	Oracle, MySQL, PostgreSQL, Other	Linux, Mac	[MS]	2016-07-06	Aquafold	Not	$ 499

Update 2016-09-02 : [DA] database design tools and supported operating systems added
Update 2016-08-04 : added utility classification and NitroAccelerator
Now you can search by type of utility here . For example, if we need all the alternatives for SSMS, then in the search field you just need to specify [MS] and press enter.
Update 2016-07-15 : SSMS and RML Utilities added
Update 2016-07-11 : SQLExecStats added, thanks to usarskyy
Update 2016-06-24 : HeidiSQL added, thanks @FractalizeR
Update 2016-06-23 : added EMS utility , thanks @vladimir_gorobets
Update 2016-06-21 : Added SoftTree SQL Assistant , thanks @vikaz

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

All Articles

Full list of tools and utilities for Microsoft SQL Server

More articles: