Useful free and paid Microsoft SQL Server utilities and tools - a complete list of 275 SQL Server Utilities updated on Jan 24, 2019.

Utility types (main purpose), in braces {} current counts:

: Backup solutions {6}

: Backup solutions {6} [BI] : Business Intelligence Solutions {4}

: Business Intelligence Solutions {4} [D] : Documentation solutions {7}

: Documentation solutions {7} [DA] : Database Architecture {13}

: Database Architecture {13} [DC] : Data compare {12}

: Data compare {12} [ETL] : Extract Download Load (ETL) Tools {1}

: Extract Download Load (ETL) Tools {1} : Internal SQL Server utilities (for example, bcp) {14}

: Internal SQL Server utilities (for example, bcp) {14} [IDX] : Index manager {2}

: Index manager {2} [G] : Data generation {4}

: Data generation {4} [J] : Job managers {3}

: Job managers {3} [M] : Monitoring and alerting Tools {16}

: Monitoring and alerting Tools {16} [MG] : Migration tool {26}

: Migration tool {26} [MS] : Management Studio (alternative for SSMS) {26}

: Management Studio (alternative for SSMS) {26} [REC] : Recovery tools {7}

: Recovery tools {7} : Search tools {3}

: Search tools {3} [SC] : Structure compare {18}

: Structure compare {18} [T] : Testing tools {5}

: Testing tools {5} [ST] : Statistics utilities {3}

: Statistics utilities {3} [?]: Not yet classified {114}

SSMS

Download page: SSMS

Release date: 2018-11-21

Support Version: 2005-2017/Azure

Author: Microsoft

Free version: Yes

Price: No

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features improved compatibility with previous versions of SQL Server, a stand-alone web installer, and toast notifications within SSMS when new releases become available.

bcp Utility

Download page: bcp Utility

Release date: 2012-02-11

Support Version: 2008/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The bcp utility bulk copies data between an instance of MicrosoftSQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. Except when used with the queryout option, the utility requires no knowledge of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.

sqlcmd Utility

Download page: sqlcmd Utility

Release date: 2016-08-23

Support Version: 2008-2017/Azure

Author: Microsoft

Free version: Yes

Price: No

The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

mssql-cli

Download page: mssql-cli

Release date: 2018-07-06

Support Version: 2008-2017/Azure

Author: Microsoft

Free version: Open Source

Price: No

Interactive command line query tool for SQL Server.

Auto-completion

Syntax highlighting

Query history

Configuration file support

Multi-line queries

Azure Data Studio

Download page: Azure Data Studio

Release date: 2018-12-19

Support Version: 2008-2017/Azure

Author: Microsoft

Free version: Yes

Price: No

Azure Data Studio (previously SQL Operations Studio) is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

Azure Data Studio List of Extensions

Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment

SQL Server Connection Management with Connection Dialog, Server Groups, and Registered Servers

Object Explorer supporting schema browsing and contextual command execution

T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition

Query Results Viewer with advanced data grid supporting large result sets, export to JSONCSVExcel, query plan and charting

Management Dashboard supporting customizable widgets with drill-through actionable insights

Visual Data Editor that enables direct row insertion, update and deletion into tables

Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can be executed or scripted

Task History window to view current task execution status, completion results with error messages and task T-SQL scripting

Scripting support to generate CREATE, SELECT and DROP statements for database objects

Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries

Modern light-weight shell with theming, user settings, full screen support, integrated terminal and numerous other features

RML Utilities for SQL Server

Download page: RML Utilities for SQL Server

Release date: 2014-12-12

Support Version: 2008/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:

Which application, database or login is using the most resources, and which queries are responsible for that

Whether there were any plan changes for a batch during the time when the trace was captured and how each of those plans performed

What queries are running slower in todays data compared to a previous set of data

GraphView

Download page: GraphView

Release date: 2016-02-23

Support Version: -

Author: Microsoft

Free version: Yes

Price: No

GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language.

Microsoft Baseline Security Analyze

Download page: Baseline Security Analyze

Release date: 2015-01-09

Support Version: -

Author: Microsoft

Free version: Yes

Price: No

Instruction: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/

The Microsoft Baseline Security Analyzer provides a streamlined method to identify missing security updates and common security misconfigurations. MBSA 2.3 release adds support for Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012. Windows 2000 will no longer be supported with this release.

tablediff Utility

Download page: tablediff Utility

Release date: -

Support Version: 2005-2016

Author: Microsoft

Free version: Yes

Price: No

Instruction: SQL Server tablediff utility by Robert Sheldon

The tablediff utility is used to compare the data in two tables for non-convergence, and is particularly useful for troubleshooting non-convergence in a replication topology. This utility can be used from the command prompt or in a batch file to perform the following tasks:

A row by row comparison between a source table in an instance of SQL Server acting as a replication Publisher and the destination table at one or more instances

Perform a fast comparison by only comparing row counts and schema.

Perform column-level comparisons.

Generate a Transact-SQL script to fix discrepancies at the destination server to bring the source and destination tables into convergence.

Log results to an output file or into a table in the destination database.

Microsoft Log Parser

Download page: Microsoft Log Parser

Release date: -

Support Version: -

Author: Microsoft

Free version: Yes

Price: No

Instruction: Microsoft Log Parser Utility: Swell ETL by Robert Sheldon

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files,

XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and Active Directory.

Log Parser Lizard GUI

Download page: Log Parser Lizard GUI

Release date: 2017-06-01

Support Version: 2008-2017

Author: Lizard Labs

Free version: Yes

Price: $59

Log Parser Lizard is a GUI for Microsoft Logparser, definitely the best one available on the market today. Log Parser is a very powerful and versatile query software tool that provides universal query access (using SQL) to text-based data, such as log files, XML files, and TSV/CSV text files, as well as key data sources on the Microsoft Windows operating system, such as the Windows Event Log, IIS log, the registry, the File System, the Active Directory services and much more.

Diskspd

Download page: Diskspd

Release date: 2015-12-14

Support Version: -

Author: Microsoft

Free version: Yes

DISKSPD is a storage load generator / performance test tool from the Windows/Windows Server and Cloud Server Infrastructure Engineering teams. Compilation is supported with Visual Studio and Visual Studio Express. Use the Visual Studio solution file inside the diskspd_vs2013 directory.

HammerDB

Download page: HammerDB

Release date: 2015-05-04

Support Version: -

Author: Open Source

Free version: Yes

Price: No

HammerDB is an open source database load testing and benchmarking tool for Oracle, SQL Server, DB2, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL, Redis and Trafodion SQL on Hadoop.

Microsoft Exchange Server Error Code Look-up

Download page: Exchange Server Error Code Look-up

Release date: 2004-05-10

Support Version: -

Author: Microsoft

Free version: Yes

Useful link: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/

Determine error values from decimal and hexadecimal error codes in Microsoft Windows operating systems.

LINQPad

Download page: LINQPad

Release date: 2016-02-01

Support Version: 2008/2012/2014/2016

Author: Joseph Albahari

Free version: Yes

Price: $45

Instantly test any C#/F#/VB snippet or program, Query databases in LINQ (or SQL) — SQL/CE/Azure, Oracle, SQLite & MySQL. Standard edition free, with no expiry. Enjoy rich output formatting, optional autocompletion and integrated debugging, Script and automate in your favorite .NET language, Super lightweight — single 15MB executable! SQL Server query execution plan visualizer for LINQPad http://bit.ly/QueryPlanVisualizer

SqlDynamite

Download page: SqlDynamite

Release date: 2016-04-06

Support Version: 2008/2012/2014/2016

Author: Anatoly Sova

Free version: Yes

Price: No

Easy text search in stored procedures, functions, tables, views and triggers. Supports MSSQL, Oracle, SAP, Firebird, Mysql, PostgreSQL, DB2, Informix, SQLite, Ingres, SQL Azure, Interbase.

SQL Server Data Tools

Download page: SQL Server Data Tools

Release date: 2018-04-10

Support Version: 2008-2017/Azure

Author: Microsoft

Free version: Yes

Price: No

SQL Server Data Tools (SSDT) is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

Database Health Monitor

Download page: Database Health Monitor

Release date: 2016-03-20

Support Version: 2008/2012/2014/2016

Author: Steve Stedman

Free version: Yes

Price: No

Database Health Monitor is a powerful performance monitoring and diagnostics solution that alerts administrators to server health, performance or availability problems within their SQL Server environment, all from a central console.

SchemaDrift

Download page: SchemaDrift

Release date: 2016-02-28

Support Version: 2008/2012/2014

Author: Steve Stedman

Free version: Yes

Price: No

SchemaDrift is a SQL Server database comparison tool that allows you to compare the schema, the tables, indexes, stored procedures, functions, and much more between SQL Server databases

DBeaver

Download page: DBeaver

Release date: 2018-09-24

Support Version: 2005-2017

Author: Open Source

Free version: Yes

Price: No

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB, Cassandra, etc

HeidiSQL

Download page: HeidiSQL

Release date: 2017-12-19

Support Version: 2005-2017

Author: Open Source

Free version: Yes

Price: No

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

SQLExecStats

Download page: SQLExecStats

Release date: 2016-02-08

Support Version: 2008/2008R2/2012/2014

Author: Joe Chang

Free version: Yes

Price: No

Automate collection of key DMVs for query tuning.

Collates query exec stats with execution plan details.

Cross reference index usage by execution plan, what plans reference infrequently used indexes.

Saves XML plan for top queries.

Save information directly to Microsoft Excel 2003 file format and in binary.

ExpressProfiler

Download page: ExpressProfiler

Release date: 2016-02-15

Support Version: 2008/2008R2/2012/2014

Author: Chris Moore

Free version: Yes

Price: No

ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project.

Data Migration Assistant

Download page: Data Migration Assistant

Release date: 2017-03-15

Support Version: 2005/2008/2008R2/2012/2014/2016/Azure

Author: Microsoft

Free version: Yes

Price: No

Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server.

SQL Server Migration Assistant for Sybase

Download page: Migration Assistant for Sybase

Release date: 2017-02-17

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

Microsoft SQL Server Migration Assistant (SSMA) for Sybase is a tool to automate migration from MySQL database(s) to SQL Server and Azure SQL DB.

dta Utility

Download page: dta Utility

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

Capture performance and usage data about your Microsoft SQL Server 2005+ databases to inform insights and improve troubleshooting. Key real-time metrics provide an overview of your databases and detailed measurements about memory usage, connections, network I/O, and file I/O.

osql Utility

Download page: osql Utility

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The osql utility allows you to enter Transact-SQL statements, system procedures, and script files.

This utility uses ODBC to communicate with the server.

sqldiag Utility

Download page: sqldiag Utility

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The SQLdiag utility is a general purpose diagnostics collection utility that can be run as a console application or as a service.

You can use SQLdiag to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over time

or troubleshoot specific problems with your servers.

SQLdiag is intended to expedite and simplify diagnostic information gathering for Microsoft Customer Support Services.

sqldumper Utility

Download page: sqldumper Utility

Release date: -

Support Version: 2005/2008/2008R2/2012

Author: Microsoft

Free version: Yes

Price: No

You can use the Sqldumper.exe utility to generate a dump file on demand for any Microsoft Windows application.

For example, you can generate a dump file for debugging an application problem when a computer that is running SQL Server 2005,

Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012 is not responding to user requests.

A dump file can be a mini-dump file, a full dump file, or a filtered dump file.

SqlLocalDB Utility

Download page: SqlLocalDB Utility

Release date: -

Support Version: 2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

SqlLocalDB lets you create, delete, start, stop, and perform a number of other related tasks on an instance of SQL Server 2012 Express LocalDB,

an execution mode of SQL Server Express that’s targeted at developers. A LocalDB instance uses a minimal set of files to start the database engine.

sqllogship Utility

Download page: sqllogship Utility

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The sqllogship application performs a backup, copy, or restore operation and associated clean-up tasks for a log shipping configuration.

The operation is performed on a specific instance of Microsoft SQL Server for a specific database.

sqlservr Application

Download page: sqlservr Application

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The sqlservr application starts, stops, pauses, and continues an instance of Microsoft SQL Server from a command prompt.

sqlps Utility

Download page: sqlps Utility

Release date: -

Support Version: 2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The sqlps utility starts a Windows PowerShell 2.0 session with the SQL Server PowerShell provider and cmdlets loaded and registered. You can enter PowerShell commands or scripts that use the SQL Server PowerShell components to work with instances of SQL Server and their objects. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sqlps PowerShell module instead.

sqlmaint Utility

Download page: sqlmaint Utility

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The sqlmaint utility performs a specified set of maintenance operations on one or more databases. Use sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. All database maintenance activities generate a report that can be sent to a designated text file, HTML file, or e-mail account. sqlmaint executes database maintenance plans created with previous versions of SQL Server. To run SQL Server maintenance plans from the command prompt, use the dtexec Utility. This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use SQL Server maintenance plan feature instead.

Ssms Utility

Download page: Ssms Utility

Release date: -

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The Ssms utility opens SQL Server Management Studio. If specified, Ssms also establishes a connection to a server, and opens queries, scripts, files, projects, and solutions. You can specify files that contain queries, projects, or solutions. Files that contain queries are automatically connected to a server if connection information is provided and the file type is associated with that type of server. For instance, .sql files will open a SQL Query Editor window in SQL Server Management Studio, and .mdx files will open an MDX Query Editor window in SQL Server Management Studio. SQL Server Solutions and Projects will open in SQL Server Management Studio.

dtexec Utility

Download page: dtexec Utility

Release date: -

Support Version: 2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

The dtexec command prompt utility is used to configure and execute SQL Server Integration Services packages. The dtexec utility provides access to all the package configuration and execution features, such as parameters, connections, properties, variables, logging, and progress indicators. The dtexec utility lets you load packages from these sources: the Integration Services server, an .ispac project file, a Microsoft SQL Server database, the SSIS Package Store, and the file system.

SQL Server 2016 Report Builder

Download page: SQL Server 2016 Report Builder

Release date: 2016-09-16

Support Version: 2016

Author: Microsoft

Free version: Yes

Price: No

Report Builder provides a productive report-authoring environment for IT professionals and power users. The download provides a stand-alone installer for Report Builder.

Report Builder provides data visualizations that include charts, maps, sparklines, and data bars that can help produce new insights well beyond what can be achieved with standard tables and charts. Use Report Builder to create reports and shared datasets. Publish report parts, and then browse the Report Part Gallery to reuse existing report parts as building blocks for creating new reports quickly with a “grab and go” experience.

SQL Server 2005 Best Practices Analyzer

Download page: BPA 2005

Release date: 2008-08-13

Support Version: 2005

Author: Microsoft

Free version: Yes

Price: No

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.

SQL Server 2000 Best Practices Analyzer

Download page: BPA 2000

Release date: 2010-04-26

Support Version: 2000

Author: Microsoft

Free version: Yes

Price: No

SQL Server 2000 Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices on your servers.

SQL Server 2008 R2 Best Practices Analyzer

Download page: BPA 2008

Release date: 2010-06-18

Support Version: 2008/2008R2

Author: Microsoft

Free version: Yes

Price: No

The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:

Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server

Determines if the configurations are set according to the recommended best practices

Reports on all configurations, indicating settings that differ from recommendations

Indicates potential problems in the installed instance of SQL Server

Recommends solutions to potential problems

SQL Server 2012 Best Practices Analyzer

Download page: BPA 2012

Release date: 2012-04-06

Support Version: 2012

Author: Microsoft

Free version: Yes

Price: No

The Microsoft SQL Server 2012 BPA is a diagnostic tool that performs the following functions:

Gathers information about a Server and a Microsoft SQL Server 2012 instance installed on that Server

Determines if the configurations are set according to the recommended best practices

Reports on all configurations, indicating settings that differ from recommendations

Indicates potential problems in the installed instance of SQL Server

Recommends solutions to potential problems

DLM Dashboard

Download page: DLM Dashboard

Release date: 2016-04-27

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: Yes

Price: No

DLM Dashboard tracks your database schemas and alerts you when they change. DLM Dashboard monitors up to 50 of your databases, and sends you an email alert as soon as your databases start to drift, or change from their expected state. On the web dashboard, you can see exactly what changed, who made the changes, and when.

Red Gate SQL Compare

Download page: Red Gate SQL Compare

Release date: 2016-10-31

Support Version: 2005/2008/2012/2014/2016

Author: Red Gate

Free version: No

Price: $495

Compares and synchronizes SQL Server database schemas

Red Gate SQL Data Compare

Download page: Red Gate SQL Data Compare

Release date: 2016-05-09

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $495

SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents

Red Gate SQL Prompt

Download page: Red Gate SQL Prompt

Release date: 2016-04-28

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $369

Write, format and refactor SQL effortlessly

Red Gate SQL Monitor

Download page: Red Gate SQL Monitor

Release date: 2015-10-15

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $1495

Real-time SQL Server performance monitoring, with alerts and diagnostics

Red Gate SQL Backup Pro

Download page: Red Gate SQL Backup Pro

Release date: 2014-07-08

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $995

Compress, verify, and encrypt SQL Server backups

Red Gate SQL Doc

Download page: Red Gate SQL Doc

Release date: 2016-04-26

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $369

Document your databases automatically, create documents as HTML, PDF, Microsoft Word or Compiled HTML Help files

Red Gate SQL Data Generator

Download page: Red Gate SQL Data Generator

Release date: 2016-04-26

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $369

Generate realistic test data fast

Red Gate SQL Dependency Tracker

Download page: Red Gate SQL Dependency Tracker

Release date: 2016-04-26

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $369

Visualize complex databases simply

Red Gate SQL Multi Script

Download page: Red Gate SQL Dependency Tracker

Release date: 2016-04-15

Support Version: 2005/2008/2012/2014

Author: Red Gate

Free version: No

Price: $245

Deploy multiple scripts to multiple servers with just one click

Red Gate SQL Index Manager

Download page: Red Gate SQL Index Manager

Release date: ?

Support Version: 2008/2012/2014

Author: Red Gate

Free version: No

Price: $149

Analyze, manage, and fix database index fragmentation

Red Gate SQL Comparison SDK

Download page: Red Gate SQL Comparison SDK

Release date: 2016-02-22

Support Version: 2008/2012/2014

Author: Red Gate

Free version: No

Price: $895

Compare and synchronize automatically database schemas and data

Red Gate SQL Clone

Download page: Red Gate SQL Clone

Release date: 2017-02-27

Support Version: 2008-2017

Author: Red Gate

Free version: No

Price: $6955

SQL Clone is a database provisioning tool that lets you create full copies of SQL Server databases and backups in seconds, using around 40MB of disk space per clone.

Instead of spending hours provisioning copies of your database for development, testing, or diagnostics, SQL Clone creates one data image of a SQL Server database or backup, which you use as the source for clones.

Clones work just like normal databases. You can connect to them and edit them using any program. SQL Clone's web app provides an easy central place to create and manage clones.

With SQL Clone, your team can work locally on up-to-date, isolated copies of the database to speed up development, accurately test code, and fix issues faster.

Red Gate SQL Provision

Download page: Red Gate SQL Provision

Release date: 2018-02-26

Support Version: 2008-2017

Author: Red Gate

Free version: No

Price: $2955

Create, protect, and manage SQL Server database copies for compliant DevOps

Red Gate SQL Data Masker

Download page: Red Gate SQL Data Masker

Release date: 2018-02-26

Support Version: 2008-2017

Author: Red Gate

Free version: No

Price: $2355

Replace sensitive data with realistic, anonymized, test data

Multiple methods to sanitize sensitive information

Use templates to remain consistent with existing data formats

Replacement data sets included, such as Names, Zip Codes, Emails

Populate test data as well as sanitize existing information

Simple, repeatable, fast, and easy to use

Supports SQL Server and Oracle databases

DLM Automation

Download page: DLM Automation

Release date: ?

Support Version: 2008/2012/2014

Author: Red Gate

Free version: No

Price: ?

Automate your database changes with continuous integration and automated deployment

ReadyRoll

Download page: ReadyRoll

Release date: 2016-03-01

Support Version: 2012/2014

Author: Red Gate

Free version: No

Price: $345

It generates numerically ordered SQL migration scripts that sit inside your project and take your schema from one version to the next. You can add them to version control, use them to build and release, and automate database and application deployments, all in one process.

Rapid Database Extractor

Download page: Rapid Database Extractor

Release date: 2016-11-03

Support Version: 2008/2012/2014/2016/Azure

Author: Idera

Free version: Yes

Price: No

Manage SQL Server and Oracle data sources

Manipulate database objects

Interactively edit SQL code

Selectively execute SQL queries to retrieve data

Export data to common file formats

Connect to cloud and run in cloud (provisional)

SQL XEvent Profiler

Download page: SQL XEvent Profiler

Release date: 2014-03-14

Support Version: 2012/2014

Author: Idera

Free version: Yes

Price: No

Idera’s SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL events

and see whats happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology — making it more efficient than SQL Trace.

SQL Check

Download page: SQL Check

Release date: 2015-09-24

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Check out what happens in batches, compilations, recompilations, and transactions throughout the SQL Server environment

Monitor some of the most important metrics in SQL Server including wait stats, reads, writes, session details, and cache hits

See SQL operations as they occur for the latest information; consider it a heart rate monitor for your SQL Server environment

Install easily without agents

SQL Fragmentation Analyzer

Download page: SQL Fragmentation Analyzer

Release date: 2012-11-16

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Analyze fragmentation by one table or an entire database

Identify databases in need of defragmentation

Set fragmentation thresholds: normal, warning, critical

SQL Heat Map

Download page: SQL Heat Map

Release date: 2016-01-27

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Get one visual view of storage in all tables of a database

See storage allocation, utilization, and type of data

Quickly locate tables and indexes that need more allocated storage

SQL Hekaton Memory Check

Download page: SQL Hekaton Memory Check

Release date: 2015-06-10

Support Version: 2014

Author: Idera

Free version: Yes

Price: No

Monitor the impact of memory optimized tables on server memory

Identify high memory utilizing tables

Assess server memory capacity

Simulate moving to In-Memory OLTP

SQL Page Viewer

Download page: SQL Page Viewer

Release date: 2014-08-25

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Displays page level data summary and detail information

Has elegant GUI design for fast access in 1 click

Can select any SQL server and database table

Can navigate to any page data quickly in a tree view

Can launch directly within SSMS for optimal usability

SQL Update Statistics

Download page: SQL Update Statistics

Release date: 2015-12-14

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Launch directly within SSMS for optimal usability

Identify out-of-date SQL Server table and index statistics

View and change database statistics options

Create graphical histograms for each column’s statistics

SQL Statistics Aggregator

Download page: SQL Statistics Aggregator

Release date: 2015-05-18

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Aggregate IO statistics to identify problem tables

Correlate disk activity with query plan nodes

Compare runs of a query over time

Export and import results for easy collaboration

SQL Backup Status Reporter

Download page: SQL Backup Status Reporter

Release date: 2015-08-07

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: Yes

Price: No

Quickly identify databases which have not had backups

View backup history including the backup date and type

Have simplified grid view for easy sorting and navigation

Identify full and differential backups for many databases

SQL Integrity Check

Download page: SQL Integrity Check

Release date: 2013-08-26

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: Yes

Price: No

Easily run a CHECKDB for any database on-demand

View integrity check results to identify corruption

Routinely verifies when last check was performed

Receive alerts when databases are due for checks

Do not need to write and maintain scripts

SQL Job Manager

Download page: SQL Job Manager

Release date: 2012-03-19

Support Version: ?

Author: Idera

Free version: Yes

Price: No

Have management console to easily view past and current jobs

Can identify and correct job contention

Can drag and drop jobs across servers to level workloads

Can "at a glance" view to see failed or runaway jobs

Have customizable calendar view

Azure SQL Database Backup

Download page: Azure SQL Database Backup

Release date: 2012-10-02

Support Version: ?

Author: Idera

Free version: Yes

Price: No

Save time and storage space with up to 95% compression

Backup on-premise or to Azure BLOB storage

Central data storage to prevent data loss

View historical backup and restore operations

Restore with transaction consistency to and from the cloud

SQL Column Search

Download page: SQL Column Search

Release date: 2015-11-17

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: Yes

Price: No

Find potentially sensitive data

Search an entire instance or a specific table

Export results to CSV format for easy analysis and reporting

SQL Permissions Extractor

Download page: SQL Permissions Extractor

Release date: 2015-08-07

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: Yes

Price: No

Generate T-SQL scripts for copying of user permissions

Edit, save, and execute permissions scripts

Include object level permissions for selected databases

Copy, extract, modify and apply changes in four steps

SQL BI Check

Download page: SQL BI Check

Release date: 2016-04-13

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: Yes

Price: No

Real-time performance monitoring for SQL Server Analysis Services (SSAS)

See physical server metrics for CPU, disk, and storage

View analysis metrics for SSAS processing, memory, and cache

Get up and running in minutes, no agents required

SQL Inventory Check

Download page: SQL Inventory Check

Release date: 2016-03-24

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: Yes

Price: No

Discover unknown and forgotten instances posing security and performance risks

Track SQL Servers to manage license and support costs

Stay on top of important SQL Server updates and patches

SQL Diagnostic Manager

Download page: SQL Diagnostic Manager

Release date: ?

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $1747

Performance monitoring for physical and virtual environments

Query plan monitoring to see the causes of blocks and deadlocks

Integrated SQL Doctor expert recommendations

Easy integration with Microsoft SCOM

Predictive alerting with settings to avoid false alerts

Web-based dashboard with at-a-glance views of top issues and alert

SQL Safe Backup

Download page: SQL Safe Backup

Release date: 2016-03-24

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $907

Backup faster than native SQL and save space with dynamic compression

Reduce failures due to network problems

Automate full, differential, and transaction log backups

Integrated cloud backup support for Amazon S3

Instant Restore provides immediate access to backup data

Web-based dashboard provides at-a-glance views of top issues and alerts

SQL Compliance Manager

Download page: SQL Compliance Manager

Release date: 2015-09-08

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $2657

Audit Sensitive Data - see who did what, when, where, and how

Track and Detect - monitor and alert on suspicious activity

Satisfy Audits - for PCI, HIPAA, FERPA and SOX requirements

Generate Reports - 25 built-in reports to validate SQL Server audit trails

Minimize Overhead - light data collection agent minimizes server imp

SQL Inventory Manager

Download page: SQL Inventory Manager

Release date: 2016-04-22

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $3195

View your SQL Server inventory - know what you have where & who owns it

Auto-discover any new servers installed, to better manage server sprawl

Get alerts when a server goes down, or space is running low

Set tags to better organize servers and databases across the enterprise

Quickly deploy and access from anywhere via web-based and agentless UI

SQL Virtual Database

Download page: SQL Virtual Database

Release date: 2016-03-24

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $625

Immediate access - get data from backup files instantly

Acts like a real database - Use 3rd party and native tools

OLR replacement - better solution to object level recovery

Multiple Uses - reporting, data extraction, analysis, etc.

Read/Write support - inserts, updates, DBCC commands

SQL Secure

Download page: SQL Secure

Release date: 2016-04-19

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $907

Identify existing vulnerabilities in your SQL Servers

Harden security policies across SQL Servers

Rank security levels with the security report card

Analyze and report user permissions across SQL Servers

Customizable templates for PCI, HIPAA and more

SQL Doctor

Download page: SQL Doctor

Release date: 2015-12-17

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $625

New and enhanced Expert Recommendations to help improve performance

Dashboard exposes performance metrics in real-time

"Quick Findings" instantly locates SQL performance issues

Executable scripts are generated to optimize performance

Stored history of analysis recommendations for trending

SQL Admin Toolset

Download page: SQL Admin Toolset

Release date: 2016-01-13

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $325

24 essential desktop tools for your everyday SQL Server needs

Run every day diagnostics across multiple SQL servers

Complete administrative tasks in minutes, not hours

Perform analysis on your SQL data

SQL Defrag Manager

Download page: SQL Defrag Manager

Release date: 2016-03-10

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $1495

Automate identification of index fragmentation "hot spots"

Schedule index defragmentation jobs

Avoid database contention with system resource pre-checks

Reduce page splits with index fill factor settings control

Centrally manage, report and notify instantly

DBArtisan

Download page: DBArtisan

Release date: ?

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $3122

Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI

Proactively manage space, data and performance with built-in analytics

Easily find and fix performance issues using intelligent diagnostics

Move schema and table data across different platforms with ease

Protect data security with view, grant and revoke of permissions

SQL BI Manager

Download page: SQL BI Manager

Release date: 2015-09-08

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $697

Monitor SSAS, SSRS, & SSIS health with agentless monitoring

View active sessions, workload, and report generation performance

Identify issues with access to data including cube size and resource utilization

Set up alerts with configurable thresholds

Log in from anywhere for at-a-glance views of top issues and alerts

SQL Enterprise Job Manager

Download page: SQL Enterprise Job Manager

Release date: 2015-09-08

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $697

Monitor SQL Server agent jobs across the enterprise

Easily view job status and details with familiar calendar layout

Chain jobs together and build automated workflows

Configure and manage jobs that run over multiple instances

Set alerts to be notified of potential issues

Web-based architecture simplifies deployment

DB Optimizer

Download page: DB Optimizer

Release date: ?

Support Version: 2005/2008/2008R2/2012

Author: Idera

Free version: No

Price: $1420

Streamline tuning of SQL code on major DBMSs from one interface

Tune SQL like a pro with automated performance optimization suggestions

Tackle complex SQL queries with visual SQL tuning diagrams

Pinpoint problem SQL with database profiling of wait-time analysis

Load test alternative SQL queries in simulated production environment

SQL Query Store Optimizer

Download page: SQL Query Store Optimizer

Release date: 2016-07-01

Support Version: 2016

Author: Idera

Free version: Yes

Price: No

Improve SQL Server 2016 Query Store performance

See all Query Store properties in single summary table

Execute predefined actions that modify Query Store properties and contents

Edit all modifiable Query Store properties in single overview panel

Get up and running in minutes with no agents

Rapid SQL

Download page: Rapid SQL

Release date: ?

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: No

Price: $710

Create high-performing SQL code on major DBMSs from one interface

Easily build complex SQL statements with visual query builder

Quickly construct, analyze and execute SQL code with code analyst

Simplify debugging SQL code, functions, and stored procedures

Collaborate effectively across development teams with version control

SQL Comparison Toolset

Download page: SQL Comparison Toolset

Release date: ?

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: No

Price: $745

Compare and synchronize SQL Server data and schema objects

Easy navigation of user interface improves efficiency

Automate comparison and synchronization operations

Customize schema compare and synchronization sessions

Generate ready-to-use database synchronization scripts

ER/Studio Data Architect

Download page: ER/Studio Data Architect

Release date: ?

Support Version: 2005/2008/2008R2/2012/2014

Author: Idera

Free version: No

Price: $1287

Create effective models to build a business-driven data architecture

Document and enhance existing databases to reduce redundancy

Implement naming standards to improve data consistency and quality

Effectively share and communicate models across the enterprise

Map data sources and trace origins to enhance data lineage

DB Change Manager

Download page: DB Change Manager

Release date: ?

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Idera

Free version: No

Price: $1420

Quickly roll out and reconcile database changes

Reveal, track, and report on database changes

Comply with database audit and reporting requirements

Protect data privacy within the database environment

Track changes from multiple major database platforms

Uptime Infrastructure Monitor

Download page: Uptime Infrastructure Monitor

Release date: ?

Support Version: ?

Author: Idera

Free version: No

Price: ?

Monitor servers, VMs, network devices, and applications from a unified dashboard

Use historic data to plan for future server capacity needs

Track service-level performance trends for SLA compliance and reporting

Monitor virtually anything via a multitude of pre-built plug-ins or custom scripts

Streamline incident management with native ServiceNow integration

dbForge Schema Compare

Download page: dbForge Schema Compare

Release date: 2017-09-15

Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016/2017

Author: Devart

Free version: No

Price: $150

dbForge Schema Compare for SQL Server is a reliable tool that will save you time and effort when you need to compare databases on SQL Server. The relentlessly tested compare tool allows working with live SQL Server databases, database snapshots, and backups. You can compare your SQL Server databases, analyze differences and synchronize your schemas using generated SQL script in a well-designed user interface quickly and without errors.

dbForge Data Compare

Download page: dbForge Schema Compare

Release date: 2017-08-30

Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $149

dbForge Data Compare for SQL Server is a powerful, fast and easy to use SQL comparison tool, capable of using native SQL Server backups as metadata source. With dbForge Data Compare you can tune your SQL database comparison, quickly analyze differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard with additional options.

dbForge Data Generator

Download page: dbForge Data Generator

Release date: 2017-09-15

Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $249

dbForge Data Generator for SQL Server is a powerful GUI tool for fast generation of meaningful test data. The tool includes 190+ predefined generators with sensible configuration options, that allow emulating column-intelligent real-world data. dbForge Data Generator for SQL Server can save your time and effort by populating SQL Server tables with millions of rows of test data that looks just like real data.

dbForge Query Builder

Download page: dbForge Query Builder

Release date: 2017-08-30

Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $99

dbForge Query Builder for SQL Server allows users to build complex SQL queries via an intuitive visual query building interface easily and without manual code writing. This SQL query designer will be useful to those, who often create queries to databases. Visual features to create queries, usage of graphical SQL query creator to interactively build queries, would be most appreciated by users who have no experience in writing queries manually. But even experienced users can save a lot of time on routine work.

dbForge Event Profiler

Download page: dbForge Event Profiler

Release date: 2017-08-30

Support Version: 2008/2012/2014/2016

Author: Devart

Free version: Yes

Price: No

dbForge Event Profiler for SQL Server is a FREE tool that allows you to capture and analyze SQL Server events. The events and data columns are stored in a physical trace file for later examination. You can use this information to identify and troubleshoot many SQL Server-related problems.

dbForge SQL Decryptor

Download page: dbForge SQL Decryptor

Release date: 2017-04-20

Support Version: 2000/2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: Yes

Price: No

Decrypt SQL Server Procedures, Functions, Triggers, and Views

dbForge Studio

Download page: dbForge Studio

Release date: 2017-08-03

Support Version: 2005/2008/2008R2/2012/2014/2016/2017/Amazon RDS/SQL Azure

Author: Devart

Free version: Yes

Price: $249

Code completion — to create whole SQL statement in a few keystrokes

SQL formatting — to follow common coding style (standard)

SQL snippets — to save time storing and reusing repeated code fragments

Quick object information — to show hints with info on database objects

Code navigation — quick jump by F12 to variable declaration, object editor, etc.

dbForge Fusion

Download page: dbForge Fusion

Release date: 2016-12-27

Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014

Author: Devart

Free version: No

Price: $149

dbForge Fusion for SQL Server is a powerful Visual Fusion plugin designed to simplify SQL database development and enhance data management capabilities. When you integrate dbForge Fusion for SQL Server into Microsoft Visual Fusion, all database development and administration tasks become available from your IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different way.

dbForge Documenter

Download page: dbForge Documenter

Release date: 2017-08-30

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $149

dbForge Documenter for SQL Server is a big time saver when it comes to documentation of SQL Server databases. This tool automatically generates documentation of an entire SQL Server database in a few clicks. The tool includes a wide range of options to customize the generated documentation to meet your specific requirements.

dbForge Developer Bundle

Download page: dbForge Developer Bundle

Release date: 2017-08-30

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $849

Developer Bundle for SQL Server is a tool pack that extends SSMS with many essential features aimed not only boost developers' productivity but also reduce expenses while performing routine tasks.

Increase productivity, when creating complex queries and code writing with SQL Complete, Search, Documenter and Query Builder.

Save your time while comparing and synchronizing data and schema with Source Control, Data Compare, and Schema Compare.

Simplify the testing process drastically and generate intensional test data with Data Generator and Unit Test.

Monitor SQL Server performance and troubleshoot database issues using Index Manager, Monitor, as well as Event Profiler.

dbForge Compare Bundle for SQL Server

Download page: dbForge Compare Bundle for SQL Server

Release date: 2017-08-30

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $299

One solution to handle SQL data and schema diffs.

A variety of supported schema objects.

Convenient comparison wizards will help you to tune data and schema comparisons up to your needs..

Compare databases with different structures.

Manage comparison results by applying filtering, grouping, exclude or include the needed objects to continue working with them, etc.

Handy Synchronization wizards will help you to: create accurate synchronization scripts, migrate any schema differences, dependency check to script objects in the correct order for updates, resolve synchronization issues automatically, view warnings on controversial points prior to synchronization.

Command-line interface.

Devart Excel Add-in for SQL Server

Download page: Devart Excel Add-in for SQL Server

Release date: 2017-09-13

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: Devart

Free version: No

Price: $100

Devart Excel Add-ins allow you to work with database and cloud data in Microsoft Excel as with usual Excel spreadsheets.

Minion Enterprise

Download page: Minion Enterprise

Release date: ?

Support Version: 2008/2008R2/2012

Author: MinionWare

Free version: No

Price: $1500

Minion Enterprise was designed by database administrators (DBAs) specifically to address the issues that waste the most time and cause the most problems. Minion shrinks dozens of those one-at-a-time tasks down to a central process. And, it does this without the usual overhead of monitoring software. When you install Minion Enterprise, it automatically begins gathering data from instances across your enterprise. That single repository of data allows you to centrally audit, alert, report, and investigate your entire environment. Even better, it opens up a new world of central management: audit SQL and AD security, clone user permissions across servers, standardize and enforce SQL Server settings, automate error log searches, and so very much more.

SQL Server Compression Estimator

Download page: SQL Server Compression Estimator

Release date: 2011-06-02

Support Version: 2008/2008R2/2012

Author: Bob Tavlor

Free version: Yes

Price: No

SQL Server Compression Estimator (SSCE) will allow you to estimate the best compression for your objects. It will estimate both ROW and PAGE compression, and will optionally report the Index Maintenance Ratio (a ratio that indicates how often an index is updated versus how often it is used to satisfy queries). You can then use that information to perhaps choose a less aggresive compression algorithm for heavily updated indexes.

ClearTrace

Download page: ClearTrace

Release date: 2016-07-07

Support Version: 2008/2012/2014/2016

Author: Bill Graziano

Free version: Yes

Price: No

ClearTrace imports SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000 trace and Profiler files into SQL Server and displays summary performance information.

Dell Security Explorer

Download page: Dell Security Explorer

Release date: 2015-06-25

Support Version: 2008/2012/2014

Author: Dell

Free version: No

Price: $850

This single toolset maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage large numbers of databases. It also makes it easy to manage change, resolve issues quickly and promote the highest levels of code quality, performance and maintainability.

Dell LiteSpeed for SQL Server

Download page: Dell Security Explorer

Release date: 2015-07-31

Support Version: 2008/2012/2014

Author: Dell

Free version: No

Price: ?

Dramatically reduce backup and restore times and minimize storage costs while increasing the reliability of SQL Server data protection operations across the entire enterprise. Easily manage and monitor SQL Server protection while delivering a wide array of recovery capabilities. With LiteSpeed, a complete workbench of SQL Server recovery tools are at your fingertips so you can get data back online — fast.

Dell Toad for SQL Server

Download page: Dell Toad for SQL Server

Release date: 2015-05-12

Support Version: 2008/2008R2/2012/2014

Author: Dell

Free version: No

Price: ?

Use a single console to manage access controls, permissions and security across Microsoft platforms that span multiple servers. Security Explorer provides an array of security enhancements, including the ability to identify who has rights to resources across the entire organization. You can also grant, revoke, clone, modify and overwrite permissions quickly and from a central location. Unlike native tools, Security Explorer provides the ability to back up and restore permissions only, ensuring the integrity of data. Security Explorer provides on-the-fly reports to help meet auditing requirements.

Dell Spotlight

Download page: Dell Spotlight

Release date: 2016-03-10

Support Version: 2008/2008R2/2012/2014

Author: Dell

Free version: No

Price: $2561

When you can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure is not just possible, but easy. Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock. With intuitive overviews of enterprise health and performance, automated alerts and actions, an integrated Xpert tuning module and mobile device support, Spotlight on SQL Server Enterprise makes it easier than ever to obtain the data you need to ensure the health of your SQL Server databases.

Dell Foglight

Download page: Dell Foglight

Release date: 2015-09-22

Support Version: 2008/2008R2/2012/2014

Author: Dell

Free version: No

Price: ?

Ensure optimal database performance with comprehensive database, storage and virtualization monitoring and advanced workload analytics. Foglight for Databases enables you to consolidate and standardize database performance management across your diverse multi-platform environments – even when you use native or third-party tools — to promote collaboration, improve service levels and reduce costs. Get a wealth of information at a fraction of the impact of conventional collection methods.

Dell Discovery Wizard

Download page: Dell Foglight

Release date: 2011-09-22

Support Version: 2008/2008R2/2012/2014

Author: Dell

Free version: Yes

Price: No

Take inventory of your network databases, including data amounts

Choose the databases you want to consolidate

Review database history, including installation and creation dates

Find the SQL Server versions and service packs currently deployed

Identify names of servers, instances and operating systems

Learn the identity of your end users

Dell Enterprise Reporter

Download page: Dell Enterprise Reporter

Release date: ?

Support Version: 2008/2008R2/2012/2014

Author: Dell

Free version: No

Price: $511

Dell Enterprise Reporter for SQL Server provides ad-hoc reporting for visibility database security configuration, including users and logins, roles and database permissions

SQL Scripter

Download page: SQL Scripter

Release date: 2013-02-24

Support Version: ?

Author: Thomas Hinsenkamp

Free version: No

Price: €99

SQL Scripter is a powerful tool for Microsoft SQL Server database administrators and developers to generate data scripts in a readable and executable T-SQL format.

Simple Dynamic Scheduler

Download page: Simple Dynamic Scheduler

Release date: 2016-05-02

Support Version: 2008/2012/2014

Author: Miljan Radovic

Free version: Yes

Price: No

Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store all configurations and logic.

Simple - Easy to manage (once you finish reading this page)

Dynamic - Not static

Purely T-SQL - says it all

Open source - Adoptable code to suit your business needs

Light-weight - Provides only decision machanism (Run or Hold) without actually executing anything

ApexSQL Audit

Download page: ApexSQL Audit

Release date: 2017-07-11

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $1699

Audit all SQL database and security activities

Meet compliance requirements e.g. HIPAA, PCI

Out-of-the-box and custom Win and Web reporting

Securely store audit data in a tamper-evident repository

Fully customize all auditing, alerts, and reporting

Who, what, where, and when type auditing

Deploy on SQL Server Failover Clusters

Easily manage auditing on multiple servers

ApexSQL Backup

Download page: ApexSQL Backup

Release date: 2017-10-12

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $499

Manage SQL backups across multiple servers

Configure SQL backup plans with advanced scheduling

Increase productivity with backup templates

Automatic SQL backup naming using variables

Restore to a point in time directly from timeline

Schedule and execute index maintenance tasks

Log shipping to multiple destinations

Cleanup SQL backup and restore history

ApexSQL Defrag

Download page: ApexSQL Defrag

Release date: 2017-06-29

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $499

Index fragmentation analysis

Index defragmentation

Custom policies: Use custom policies to automate database index maintenance

Set thresholds for reorganizing and rebuilding jobs

ApexSQL Log

Download page: ApexSQL Log

Release date: 2017-05-24

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $1999

Audit data, schema, and permission changes

Gain full visibility into your transaction logs

Rollback or replay any database transaction

Forensically investigate who changed what and when

Implement before and after auditing

View a complete history of row changes

Reverse inadvertent or malicious database transactions

Avoid performance overhead and data storage

ApexSQL Monitor

Download page: ApexSQL Monitor

Release date: 2017-10-05

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $499

Monitor multiple SQL Server instances

View system performance metrics

Identify performance issues and deadlocks

Use comprehensive dashboard for viewing metrics

Analyze query waits

Review query execution plans

Calculate baselines and thresholds

Visualize data with logarithmic scaling

ApexSQL Plan

Download page: ApexSQL Plan

Release date: 2018-04-05

Support Version: 2008-2017

Author: ApexSQL

Free version: Yes

Price: No

Analyze and optimize SQL query execution plans

Identify query performance issues and deadlocks

Understand query performance characteristics

Analyze query waits & review query execution plans

Customize graphical query execution plan view

See the actual relative cost of each plan operator

Analyze query live performance statistics

Compare estimated and actual query execution plans

ApexSQL Propagate

Download page: ApexSQL Propagate

Release date: 2017-09-25

Support Version: 2008-2017

Author: ApexSQL

Free version: Yes

Price: No

Execute scripts on saved list of servers/databases

Parse SQL scripts prior to execution

Create SQL scripts directly in the application

Manage lists of SQL scripts and SQL databases

Set order of SQL scripts execution

Export execution results into TXT or CSV file

Preview exaction results by databases or by scripts

Edit SQL scripts in a built-in IDE prior to execution

ApexSQL Build

Download page: ApexSQL Build

Release date: 2017-05-15

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $399

Create executable installation packages

Deploy databases directly from SQL source control

Consolidate multiple SQL scripts

Build databases from scripts, source control, etc

Ensure error free deployments

Preview the script impact by action or SQL object

ApexSQL Clean

Download page: ApexSQL Clean

Release date: 2017-09-28

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $399

View and analyze SQL and client code dependencies

Perform impact analysis on potential changes

Remove unwanted objects risk free

Map dependencies down to the column level

Analyze external databases for dependencies

View object dependencies graphically

Design the appearance of the dependency diagram

Create and export reports from object dependencies

ApexSQL Data Diff

Download page: ApexSQL Data Diff

Release date: 2017-10-03

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $599

Compare data in live DBs, backups and SC projects

Perform row level recovery without restoring

Community, Standard, and Professional editions

Compare huge databases quickly and without errors

Automate and schedule data migrations

Initiate database compares directly from SSMS

Export results to HTML, CSV and Excel

Create executable installation packages

Integrate with all popular SC systems e.g. Git, SVN

Deploy data changes directly from a source control label

ApexSQL Decrypt

Download page: ApexSQL Decrypt

Release date: 2017-08-16

Support Version: 2008-2017

Author: ApexSQL

Free version: Yes

Price: No

Decrypt SQL procedures, functions, triggers and views

Initiate decryption directly from SSMS

Decrypt objects with a single click

Filter encrypted objects

View original DDL script

Export encrypted objects into a SQL script

Decrypt databases from multiple servers

Decrypt wizard with built-in IDE

ApexSQL Diff

Download page: ApexSQL Diff

Release date: 2017-10-26

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $599

Compare live DBs, backups, scripts and SC projects

Deploy a database directly from source control

Integrate with all popular SC systems e.g. Git, SVN

Automate and schedule database synchronizations

Initiate database compares directly from SSMS

Report results to HTML, XML and Excel

Create executable .NET packages

ApexSQL Doc

Download page: ApexSQL Doc

Release date: 2017-09-06

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $699

Document SQL Server databases and SSIS packages

Generate documentation in CHM, HTML, Word and PDF

Automate and schedule the documenting process

Display graphical relationship diagrams

Document SSAS Multidimensional and Tabular models

Document SSIS Control flow and Data flow diagrams

Fully customize the documentation output

Include Data model diagrams

ApexSQL Generate

Download page: ApexSQL Generate

Release date: 2017-07-13

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $499

Generate SQL test data for specified tables

Export test data to SQL, XML, CSV, JSON, Excel

Generate millions of rows quickly

Customize test data plan with detailed options

Support a full range of SQL data types

Choose from multiple generators (Random List etc)

Retain data consistency with foreign key support

Emulate real-world test data

ApexSQL Script

Download page: ApexSQL Script

Release date: 2017-05-08

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $399

Script both SQL database objects and data

Create executable .NET packages

Script objects directly to Source Control

Automate SQL database scripting and migrations

Integrate with popular source control systems

Script an entire server down to individual columns

Save customized scripting profiles as projects

Easily decrypt some/all encrypted database objects

ApexSQL Trigger

Download page: ApexSQL Trigger

Release date: 2017-06-01

Support Version: 2008/2012/2014/2016

Author: ApexSQL

Free version: No

Price: $1299

Track data / DML changes in SQL Server databases

Integrate royalty free auditing into your apps

Translate data into information with lookups

Create reports and exports from audited data

Customize trigger templates with a built-in IDE

Add additional data to audit trail with watches

Track schema / DDL changes in audited database

Audit who, what, and when for all changes

ApexSQL Trigger Viewer

Download page: ApexSQL Trigger Viewer

Release date: 2017-06-01

Support Version: 2008-2017

Author: ApexSQL

Free version: Yes

Price: No

Read-only auditing reports for end users

ApexSQL Snapshot Utility

Download page: ApexSQL Snapshot Utility

Release date: 2016-01-12

Support Version: 2008/2012/2014/2016

Author: ApexSQL

Free version: Yes

Price: No

Utility to create a lightweight 'snapshot' of a database schema, that can be used by ApexSQL Diff as a datasource

ApexSQL Model

Download page: ApexSQL Model

Release date: 2018-10-10

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $399

Create database model diagrams and synchronize changes with existing databases.

Forward and reverse engineer

Customize the appearance of models

Create new or modify existing object groups

Navigate through model history

Export database models as imagesCustomize print output

ApexSQL Analyze

Download page: ApexSQL Analyze

Release date: 2017-12-13

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $299

Database dependency analysis

View and analyze SQL dependencies

Customize the appearance of dependency diagrams

Map dependencies down to the column level

Visualize object dependencies graphically

Export diagrams as image files

Perform impact analysis on potential object deletions

ApexSQL BI Monitor

Download page: ApexSQL BI Monitor

Release date: 2018-09-18

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $499

Monitor SSAS, SSIS and SSRS performance

Add custom performance counters

Track system performanceUse baselines to customize alert thresholds

View real-time and historical data

Set up various alert actions for each counter

Generate built-in and custom reportsTrack user activity

ApexSQL VM Monitor

Download page: ApexSQL VM Monitor

Release date: 2018-05-09

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $999

Virtualization performance monitoring

Monitor multiple hypervisors - Hyper-V and ESXi

View system performance metrics of monitored hosts

Monitor virtual machines performance

Monitor performance of host devices

Use comprehensive dashboards for viewing metrics

Calculate baselines and thresholds

View top 5 loaded virtual machines for specific hosts

Create and export comprehensive performance reports

ApexSQL VM Job

Download page: ApexSQL Job

Release date: 2018-03-29

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $499

Manage SQL Server Agent jobs across multiple servers

Get a detailed job history overview

Manage SQL Server services on managed servers

Export job details to PDF, HTML, XML or CSV format

Manage SQL Server schedulesControl the status of SQL Server Agent services

Define and manage SQL Server alertsMonitor SQL Server Agent logs

ApexSQL Enforce

Download page: ApexSQL Enforce

Release date: 2018-07-19

Support Version: 2008-2017

Author: ApexSQL

Free version: No

Price: $299

Review databases and individual SQL scripts

Import and export rulesProcess unattended via the CLI

Seamlessly integrate into your CI/CD processLeverage a library of 100+ pre-written rules

Create custom rules with a built in IDE

Write custom rules in C# or VB.NETCreate HTML reports and XML exports

Integrate with SSMS and Visual Studio

Generate SQL to fix violations

DBBest T-SQL Analyzer

Download page: DBBest T-SQL Analyzer

Release date: 2015-03-13

Support Version: 2008/2012/2014

Author: DBBest

Free version: No

Price: $89

T-SQL Analyzer is a code analyzing tool for finding problematic spots in your Transact-SQL code in SQL Server. The tool analyzes stored procedures and user-defined functions in your SQL Server database against a predefined set of best practice rules.

DBBest Database Compare Suite

Download page: DBBest Database Compare Suite

Release date: 2015-09-04

Support Version: 2008/2012/2014/2016

Author: DBBest

Free version: No

Price: $349

Comparing two production databases for migrating or upgrading

Advanced Query Tool

Download page: Advanced Query Tool

Release date: 2015-03-18

Support Version: 2008/2012/2014/2016

Author: DBBest

Free version: No

Price: $180

AQT provides a simple and easy-to-use interface to your many different databases: Oracle, DB2 for LUW, DB2 for z/OS, DB2 for iSeries, Sybase ASE, SQL Server, Informix, MySQL, MS Access, SQLite, Other.

SqlDiffFramework

Download page: SqlDiffFramework

Release date: 2012-04-17

Support Version: 2008/2012/2014/2016

Author: Michael Sorens

Free version: Yes

Price: No

SqlDiffFramework compares two data sources and highlights both row and column differences for just the columns you want.

Compare the same data over time (either current data vs. prior data or two snapshots of prior data)

Compare the same data on two different servers

Compare data from different systems (e.g. SQL Server vs. Oracle)

Verify two systems have synchronized data

DataGrip

Download page: DataGrip

Release date: 2018-02-21

Support Version: 2008-2017

Author: Jet Brains

Free version: No

Price: $89

Exploring your databases

Intelligent coding assistance

Executing queries

Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features

Pssdiag and Sqldiag Manager

Download page: Pssdiag and Sqldiag Manager

Release date: 2015-04-17

Support Version: 2012/2014

Author: Jack Li

Free version: Yes

Price: No

PSSDIAG is a diagnostics utility used to collect profiler trace, perfmon data for SQL Server. PSSDAIG was created to troubleshoot SQL Server 7.0 and 2000 issues. It was evolved and shipped with SQL Server 2005 and beyond. But the shipped product only has a data collector engine called sqldiag.exe. Microsoft Product support continues to maintain a configuration tool that allows engineers to dynamically configure on what to collect.

SQL Nexus Tool

Download page: SQL Nexus Tool

Release date: 2016-11-20

Support Version: 2008/2012/2014/2016

Author: Jack Li

Free version: Yes

Price: No

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag and Sqldiag Manager. It can dramatically reduce the amount of time you spend manually analyzing data

Fast, easy data loading: You can quickly and easily load SQL Trace files;

Visualize loaded data via reports

Executing queries

Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features

DBSophic Qure Profiler

Download page: DBSophic Qure Profiler

Release date: ?

Support Version: 2008/2012

Author: DBSophic

Free version: No

Price: $300

SQL server trace analysis tool

View SQL activity in real-time

Group, sort and export batches

Real time index recommendations

Compare SQL traces

No limitations on the number of SQL servers, databases, processors etc.

DBSophic Qure Optimizer

Download page: DBSophic Qure Optimizer

Release date: ?

Support Version: 2008/2012

Author: DBSophic

Free version: No

Price: ?

The workload tuning solution that automatically optimizes millions of queries in one go

RestoreChecker

Download page: RestoreChecker

Release date: 2015-01-15

Support Version: ?

Author: SQLServerUtilities

Free version: No

Price: $99

RestoreChecker is a utility that restores SQL Server backup files in order to verify that the backup files can be successfully restored and in addition perform data integrity checks on the backups restored while offloading the intensive IO activity from your production servers.

SQLScripter

Download page: SQLScripter

Release date: 2009-08-24

Support Version: ?

Author: SQLServerUtilities

Free version: No

Price: $99

SQLScripter is a powerful command line utility that scripts SQL Server objects. The utility is designed to automate the process of schema generation.

SQLC

Download page: SQLC

Release date: 2017-11-19

Support Version: ?

Author: David Ingleton

Free version: Yes

Price: No

SQLC is a software tool for comparing two SQL Server databases. With SQLC you can perform Object comparison (Database schema) as well as Data comparison (Table data)

Database Performance Analyzer

Download page: Database Performance Analyzer

Release date: ?

Support Version: 2008-2017/Azure/Amazon

Author: SolarWinds

Free version: No

Price: $1995

Monitor across your entire environment: physical servers, virtualized, and in the Cloud

Database Performance Analyzer for MSSQL

Download page: Database Performance Analyzer for MSSQL

Release date: ?

Support Version: 2008-2017/Azure/Amazon

Author: SolarWinds

Free version: No

Price: $1995

Optimize and tune SQL Server deployed anywhere - physical, virtual, or cloud based. Includes Azure SQL database, Azure virtual machines, and Amazon RDS.

SQL Enlight

Download page: SQL Enlight

Release date: 2016-04-25

Support Version: 2005/2008/2008R2/2012/2014

Author: UbitSoft

Free version: No

Price: $295

Advanced static analysis

T-SQL code formatting

Statements history

Validate T-SQL code for syntax errors

Script Summary

Refactoring

Continuous integration support

Aireforge Studio

Download page: Aireforge Studio

Release date: 2017-06-21

Support Version: 2008/2012/2014/2016/Azure

Author: AireForge

Free version: Yes

Price: $299

Aireforge Studio contains a growing suite of tools that help administrators to stabilize, optimize & secure multiple database instances with ease. Be it, keeping two instances in sync for recovery purposes or synchronizing the settings of over 200 replication subscribers; our tools will help.

HexaTier

Download page: HexaTier

Release date: ?

Support Version: ?

Author: HexaTier

Free version: No

Price: ?

Providing an all-in-one solution to protect your data from internal and external attacks with four key elements, including: Database Security, Discovery of Sensitive Data. Dynamic Data Masking, and Database Activity Monitoring to comply with regulatory requirements.

SoftTree SQL Assistant

Download page: SoftTree SQL Assistant

Release date: 2017-12-17

Support Version: 2005/2008/2008R2/2012/2014/2016/2017

Author: SoftTree

Free version: No

Price: $215

Triples SQL developer productivity

Improves code quality and accuracy

Provides unmatched intelligent SQL code intellisense features

Provides interactive SQL reference and SQL code assistance systems

Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...

Download page: DB Audit and Security 360

Release date: 2015-02-07

Support Version: 2005/2008/2008R2/2012/2014/2016

Author: SoftTree

Free version: No

Price: $499

DB Audit and Security 360 is a professional all-in-one database security and auditing solution for Oracle, Sybase, DB2, MySQL and Microsoft SQL Server. DB Audit and Security 360 enables database and system administrators, security administrators, auditors and operators to track and analyze any database activity including database security, access and usage, data creation, change or deletion. What makes this solution really unique is its built-in support for multiple auditing methods giving you the flexibility to choose the best fit for your database security requirements.

EMS SQL Management Studio

Download page: EMS SQL Management Studio

Release date: 2016-05-26

Support Version: 2000/2005/2008/2008R2/2012/2014

Author: EMS

Free version: No

Price: $257

EMS SQL Management Studio for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on all critical MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for SQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for MSSQL Server in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential SQL Server tools to make you more productive than ever before!

EMS SQL Backup

Download page: EMS SQL Backup

Release date: 2016-04-13

Support Version: 2000/2005/2008/2008R2/2012/2014

Author: EMS

Free version: Yes

Price: $82

EMS SQL Backup for SQL Server is an effective tool for automating backup, restore and log shipping tasks on all SQL Servers in your company. In addition, SQL Backup allows you to update statistics, perform re-indexing, truncate database, check database integrity and perform many other tasks that can be united into policies and deployed to SQL Servers in a few clicks. SQL Backup monitors the maintenance task execution, quickly investigates and resolves issues.

EMS SQL Administrator

Download page: EMS SQL Administrator

Release date: 2015-04-14

Support Version: 2000/2005/2008/2008R2/2012/2014

Author: EMS

Free version: Yes

Price: $135

EMS SQL Administrator for SQL Server is a toolset for efficient SQL Server administration. It provides a complete and easy-to-use set of tools for administering SQL Server. SQL Administrator is designed specifically for database administrators and allows you to perform administrative tasks in the fastest, easiest and most efficient way.

EMS SQL Manager

Download page: EMS SQL Manager

Release date: 2016-05-26

Support Version: 2000/2005/2008/2008R2/2012/2014

Author: EMS

Free version: Yes

Price: $135

EMS SQL Manager for SQL Server is a high performance graphical tool for Microsoft SQL Server database development and administration. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage SQL server users and their privileges, build SQL queries visually, work with metadata, export and import SQL Server database data and much more.

EMS Data Export

Download page: EMS Data Export

Release date: 2016-04-29

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS Data Export for SQL Server is a powerful tool to export SQL Server database data quickly to any of 20 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for SQL Server has a friendly wizard, which allows you to set various options of SQL Server export process visually and a command-line utility to automate your SQL Server export jobs using the configuration file.

EMS Data Import

Download page: EMS Data Import

Release date: 2016-04-14

Support Version: -

Author: EMS

Free version: No Price: $47

EMS Data Import for SQL Server is a powerful tool to import data to SQL Server tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several SQL Server tables or views at once, save all SQL Server import parameters set on current wizard session, use special batch insert mode to import SQL Server data at the maximum possible speed and much more.

EMS Data Pump

Download page: EMS Data Pump

Release date: 2016-11-03

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS Data Pump for SQL Server is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MySQL or any other database with ADO support) to SQL Server databases. Database conversion and migration become as easy as possible with Data Pump for SQL Server!

EMS Data Generator

Download page: EMS Data Generator

Release date: 2010-07-10

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS Data Generator for SQL Server is an impressive tool for generating test data to SQL Server database tables. The utility can help you to simulate the database production environment and allows you to populate several SQL Server database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more. It has plenty of powerful functionalities to generate SQL Server test data in a simple and direct way.

EMS DB Comparer

Download page: EMS DB Comparer

Release date: 2015-07-24

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS DB Comparer for SQL Server is an excellent tool for comparing SQL Server database schemas and discovering differences in their structures. You can view all the differences in compared database objects and execute an automatically generated script to synchronize structure of SQL Server databases and eliminate these differences. Define comparison parameters and many other features make your work with our tool for SQL Server database synchronization easy and fast.

EMS DB Extract

Download page: EMS DB Extract

Release date: 2008-10-16

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS DB Extract for SQL Server is an impressive and easy-to-use tool for creating SQL Server database backups in a form of SQL scripts. This database script utility allows you to save metadata of all SQL Server database objects as well as SQL Server table data as database snapshots. Flexible customization of the extract process enables you to select objects and data tables for SQL Server database dump and tune many other extract options.

EMS SQL Query

Download page: EMS SQL Query

Release date: 2012-03-29

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS SQL Query for SQL Server is a useful tool that lets you quickly and simply build SQL queries to SQL Server databases. Visual SQL Server query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to SQL Server databases, select tables and fields for a query to SQL Server, set the selection criteria and many more.

EMS Data Comparer

Download page: EMS Data Comparer

Release date: 2012-11-16

Support Version: -

Author: EMS

Free version: No

Price: $47

EMS Data Comparer for SQL Server is a powerful and easy-to-use tool for SQL Server data comparison and synchronization. Using this utility you can view all the differences in compared SQL Server tables and execute an automatically generated script to eliminate these differences. Data Comparer for SQL Server provides a wide range of configuration parameters for fast and effective data comparison and synchronization of SQL Server databases.

NitroAccelerator

Download page: NitroAccelerator

Release date: 2016-07-10

Support Version: 2008/2012/2014/2016

Author: Nitrosphere

Free version: No

Price: $1265

Accelerates and Secures SQL Server network traffic resulting in orders of magnitude performance improvement while securing the data across the network.

ERwin Data Modeler

Download page: ERwin Data Modeler

Release date: 2016-06-03

Support Version: 2008/2012/2014/2016

Author: ERwin

Free version: No

Price: $810

ERwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment

Toad Data Modeler

Download page: Toad Data Modeler

Release date: 2016-06-16

Support Version: 2008/2012/2014

Author: Dell

Free version: No

Price: $562

Easily create high-quality data models. Toad Data Modeler enables you to rapidly deploy accurate changes to data structures across more than 20 different platforms. It allows you to construct logical and physical data models, compare and synchronize models, quickly generate complex SQL/DDL, create and modify scripts, as well as reverse and forward engineer both databases and data warehouse systems

SQL Power Architect

Download page: SQL Power Architect

Release date: 2016-02-11

Support Version: 2008/2012/2014

Author: SQLPower

Free version: Yes

Price: $995

The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.

DbWrench

Download page: DbWrench

Release date: 2016-07-06

Support Version: 2008/2012/2014

Author: Nizana Systems

Free version: No

Price: $99

makes creating and modifying databases quicker and easier

streamlines many common database tasks

supports many operating systems and databases in a single license

Navicat Data Modeler

Download page: Navicat Data Modeler

Release date: 2016-08-01

Support Version: 2008/2012/2014/2016

Author: PremiumSoft

Free version: No

Price: $199

Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.

DeZign for Databases

Download page: DeZign for Databases

Release date: 2016-04-25

Support Version: 2008/2012/2014

Author: Datanamic

Free version: No

Price: $259

DeZign for Databases is an intuitive database design and modeling tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular SQL and desktop database.

ERDesigner NG

Download page: ERDesigner NG

Release date: 2013-04-10

Support Version: 2008/2012/2014

Author: Mirko Sertic

Free version: Open Source

Price: No

The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation.

Vertabelo

Download page: Vertabelo

Release date: ?

Support Version: 2012

Author: Vertabelo

Free version: No

Price: $948

Design your database online but very expensive

dbDiffo

Download page: dbDiffo

Release date: ?

Support Version: ?

Author: Contenet Ltd

Free version: Yes

Price: No

dbDiffo - The free online database schema designer

SQL DXP

Download page: SQL DXP

Release date: 2016-06-20

Support Version: 2008/2012/2014/Azure

Author: SQL Delte

Free version: No

Price: $530

SQL DXP compares databases on different server platforms and can generate scripts to make the source database generally the same as the target database regardless of platform.

Aqua Data Studio

Download page: Aqua Data Studio

Release date: 2016-07-06

Support Version: 2008/2012/2014

Author: AquaFold

Free version: No

Price: $499

Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually analyze data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports all major database vendors, works on all major operating systems and is localized to 9 languages.

RazorSQL

Download page: RazorSQL

Release date: 2016-09-29

Support Version: 2008/2012/2014/2016

Author: Richardson Software

Free version: No

Price: $100

The MS SQL Server database query tool features provided by RazorSQL include a custom MS SQL Server database browser tailored to SQL Server, a Transact-SQL SQL editor with Transact SQL and SQL Server specific features and syntax highlighting, custom SQL Server visual tools, and SQL Server specific database administration tools.

SQL Pretty Printer

Download page: SQL Pretty Printer

Release date: 2016-02-19

Support Version: 2008/2012/2014/2016

Author: Gudu Software

Free version: No

Price: $50

SQL Pretty Printer Desktop Version allows you to format your SQL wherever you are regardless of your Internet connection. It generates various output formats, including text, colorful html (Used in web, blog, wiki, forums) and RTF. Batch mode enables you to clean up SQL in multifiles under a nested directory. While sitting in the tray, you can format SQL in any editor like Microsoft Query Analyzer, UltraEditor or notepad with just one hotkey.

Database .NET

Download page: Database .NET

Release date: 2018-08-20

Support Version: 2008-2017

Author: fish's dotNET

Free version: Non-commercial

Price: $69

Database .NET is an innovative, powerful and intuitive multiple database management tool. You can browse/grant objects, design tables, edit rows, run queries, generate scripts, analyze/monitor SQL and import/export/migrate/sync data with a consistent interface.

dbMigration .NET

Download page: dbMigration .NET

Release date: 2018-08-20

Support Version: 2008-2017

Author: fish's dotNET

Free version: Non-commercial

Price: $49

dbMigration .NET is a simple, easy and intuitive multiple database migration and sync tool. With it you can easily migrate schema and data between different databases without complicated procedures.

Is It SQL

Download page: Is It SQL

Release date: 2017-04-06

Support Version: 2005/2008/2012/2014/2016

Author: Bill Graziano

Free version: Non-commercial

Price: No

Supports SQL Server 2005 through SQL Server 2016

Monitor CPU usage for SQL Server and non-SQL Server tasks

Capture batch requests per second

Monitor Disk I/onsite

Monitor waits

Show actively running queries

Capture basic demographic information including version, start time, database sizes, etc.

Can run with no installation or it can be run as a service

Database Experimentation Assistant Technical Preview 2

Download page: Database Experimentation Assistant

Release date: 2017-03-24

Support Version: 2005/2008/2012/2014/2016

Author: Microsoft

Free version: Yes

Price: No

Database Experimentation Assistant is the new A/B testing solution for SQL Server upgrades, enables customers to gather performance insights for upgrades by conducting experiments across two SQL Server versions using production workloads enabling customers to conduct experiments on database workloads across two versions of SQL Server.

Data Platform Studio

Download page: Data Platform Studio

Release date: ?

Support Version: SQL Server, SQL Azure

Author: Red Gate Software

Free version: Yes

Price: ?

Simplify the process of migrating data from your on-premise SQL Server to Azure SQL Data Warehouse with the Data Platform Studio importer. Automatically, and in far less time than it takes to handle migrations manually, it:

Makes schema compatibility fixes to prepare your Azure SQL Data Warehouse for your database

Compresses your data so it uploads to Azure efficiently

Utilizes the MPP power of Azure SQL Data Warehouse to ingest the data quickly

Flyway

Download page: Data Platform Studio

Release date: 2018-01-30

Support Version: Oracle, SQL Server, SQL Azure, MySQL, Other

Author: boxfuse

Free version: Open Source

Price: $950

Flyway is an open-source database migration tool. It strongly favors simplicity and convention over configuration. It is based around just 6 basic commands: Migrate, Clean, Info, Validate, Baseline and Repair. Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, ...) is supported) or Java (for advanced data transformations or dealing with LOBs). It has a Command-line client. If you are on the JVM, we recommend using the Java API (also works on Android) for migrating the database on application startup. Alternatively, you can also use the Maven plugin, Gradle plugin, SBT plugin or the Ant tasks.

Liquibase

Download page: Liquibase

Release date: 2018-04-11

Support Version: Oracle, PostgreSQL, MySQL, Other

Author: Liquibase

Free version: Open Source

Price: No

Liquibase is an open source database-independent library for tracking, managing and applying database schema changes. It was started in 2006 to allow easier tracking of database changes, especially in an agile software development environment.

All changes to the database are stored in text files (XML, YAML, JSON or SQL) and identified by a combination of an "id" and "author" tag as well as the name of the file itself. A list of all applied changes is stored in each database which is consulted on all database updates to determine what new changes need to be applied. As a result, there is no database version number but this approach allows it to work in environments with multiple developers and code branches. Liquibase automatically creates DatabaseChangeLog Table and DatabaseChangeLogLock Table when you first execute a changeLog File.

My Batis

Download page: My Batis

Release date: 2018-03-20

Support Version: Oracle, PostgreSQL, MySQL, Other

Author: My Batis

Free version: Open Source

Price: No

MyBatis Schema Migration System (or MyBatis Migrations for short) seeks to:

Work with any database, new or existing

Leverage the source control system (e.g. Subversion)

Enable concurrent developers or teams to work independently

Allow conflicts very visible and easily manageable

Allow for forward and backward migration (evolve, devolve respectively)

Make the current status of the database easily accessible and comprehensible

Enable migrations despite access privileges or bureaucracy

Work with any methodology

Encourages good, consistent practices

SentryOne Plan Explorer

Download page: SentryOne Plan Explorer

Release date: 2017-05-25

Support Version: 2008-2017

Author: SentryOne

Free version: Yes

Price: No

Index Analysis: Discover a new, easy way to gauge the impact of potential index changes.

Statistics Analysis with Histogram

Query Performance Profiling and Playback

Actual Plan Recosting

Plan Diagram

Management Studio Add-In

Tuning History and Comments

Multiple Documents

SQL Sentry

Download page: SQL Sentry

Release date: 2016-12-07

Support Version: ?

Author: SentryOne

Free version: No

Price: ?

Get the most complete coverage for SQL Server and Windows. Simplify performance tuning by visualizing where problems exist for faster resolution. Streamline your defragmentation process and query tuning all in one place. We have combined all the great SQL Sentry tools into a single unified solution to help you monitor and optimize the Microsoft data platform. Everything you need for: SQL Server and Windows Performance Monitoring, Event Management, Index Defragmentation and Query Plan Analysis, with Desktop, Web, and Mobile UIs.

dbMonitor

Download page: dbMonitor

Release date: 2012-11-01

Support Version: ?

Author: Devart

Free version: Yes

Price: No

To extend monitoring capabilities of our data access products there is an additional tool called dbMonitor. It is easy-to-use tool to provide visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.

DBmaestro TeamWork

Download page: DBmaestro TeamWork

Release date: ?

Support Version: ?

Author: DBmaestro

Free version: No

Price: ?

DBmaestro is bringing the agility of Automation and DevOps, with an innovative solution for evolutionary database development, safe build automation, and failsafe continuous delivery in any environment.

Database Release Automation

Database Merge and Build Automation

Database Enforced Source Control

Database Enhanced Security and Regulatory Compliance

xSQL Schema Compare

Download page: xSQL Schema Compare

Release date: 2017-03-01

Support Version: 2005/2008/2012/2014/2016, Azure

Author: xSQL Software

Free version: Yes

Price: $399

Compare the schemas of two SQL Server databases, review differences, generate synchronization script and execute it.

xSQL Data Compare

Download page: xSQL Data Compare

Release date: 2017-06-26

Support Version: 2005/2008/2012/2014/2016, Azure

Author: xSQL Software

Free version: Yes

Price: $399

Data Compare for SQL Server is a tool for comparing and synchronizing the data in two SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data etc.

xSQL Script Executor

Download page: xSQL Script Executor

Release date: 2015-02-25

Support Version: 2000 and higher

Author: xSQL Software

Free version: Yes

Price: $249

Script Executor is a professional grade database tool that allows you to deploy multiple Sql scripts on one or more target servers with a click of a button. Scripts can be deployed directly from the GUI, from the command line or they can be wrapped into an execut