SQLShack

Free SQL Server tools

February 14, 2018 by
This collection of content will provide an overview of free Microsoft SQL Server tools, with product page links for each of the tools. If you noticed a tool we missed, please let us know in the comments below.

Adminer
ApexSQL CI/CD toolkit
ApexSQL Compare
ApexSQL Complete
ApexSQL Decrypt
ApexSQL Plan
ApexSQL Propagate
ApexSQL Refactor
ApexSQL Search
BI Developer Extensions
ClearTrace
Comparator
Database Experimentation Assistant
Database Health Monitor
Database Modeling Excel
Database Performance Analyzer
Data Migration Assistant
DBAchecks
DBAtools
DBComparer
DBeaver
dbDiffo
dbForge Event Profiler
dbForge Monitor
dbForge Search
dbForge SQL Decryptor
DbViewSharp
DLM Dashboard
DTSQL
ERDesigner NG
ExpressProfiler
Flyway
HammerDB
HeidiSQL
Is It SQL
MSKerberos Configuration Manager
LIQUIBASE
Manduka
Partition Management
Plan Explorer
Powershell Scripts
PSDatabaseClone
Pssdiag&Sqldiag Manager
Rapid Database Extractor
RML Utilities
SchemaCrawler
Simple Dynamic Scheduler
sp_Blitz®
sp_whoisactive
SQuirreL SQL Client
SQL Admin Studio
SQL Backup Status Reporter
SQL BI Check
SQLC
SQL Check
SQL Cop
SQL Column Search
SQL Converter
SQL Data Profiler
SqlDiffFramework
SQLDBSearch
SQLDBSize
SQLines Data
SQLite & SQL Server Compact Toolbox
SqlDbAid
SQL Dynamite
sqlectron
SQL ExecStats
SQL-FineBuild
SQL Fragmentation Analyzer
SQL Health Monitor
SQL Heat Map
SQL Hekaton Memory Check
SQL Hunting Dog
SQL Instance Check
SQL Instegrity Check
SQL Job Manager
SQL Migrator
SQL Nexus
SQL Operations Studio
SQL Page Viewer
SQL Permissions Extractor
SQLPRep
SQL Query Store Optimizer
SQL Search
SQL Server Migration Assistant for DB2
SQL Server Migration Assistant for MySQL
SQL Server Migration Assistant for Oracle
SQL Server Migration Assistant for SAP ASE
SQL Server Migration Assistant for Access
SQL Server 2005 Best Practices Analyzer
SQL Server 2008 Best Practices Analyzer
SQL Server 2012 Best Practices Analyzer
SQL Scripts Manager
SQL Server Backup
SQL Server Data Tools
SQL Server Integrity Check
SQL Server Index and Statistics Maintenance
SQL Server Management Studio (SSMS)
SQL Server Monitoring
SQL Server Storage manager
SQL Statistics Aggregator
SQL Update Statistics
SQL XEvent Profiler
SysKit Pulse
TSQLT
WhatsUp SQL Server Monitor
xSQL Database Searcher
YourSqlDba


Adminer

Product page: Adminer
Latest release: 14-Apr-2017
Supported versions: Unknown
Author: Jakub Vrana
Description: Adminer is a database management tool that allows you to manage databases, tables, columns, relations, indexes, users, permissions, and more from a web-based user interface. Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.

ApexSQL CI/CD toolkit

Product page: ApexSQL CI/CD toolkit
Latest release: 20-Dec-2017
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL CI/CD toolkit is a set of open source PowerShell cmdlets for automating work flow pipelines to integrate database changes, test and deliver to production. It supports integration with Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Hudson, Visual Studio Team Services, Team Foundation Server, and other CI/CD servers. It contains predefined Continuous Integration (CI) and Continuous Delivery (CD) PowerShell script templates for standalone use where all pipeline steps can be customized, reordered, added and removed.

ApexSQL Compare

Product page: ApexSQL Compare
Latest release: 26-Jan-2018
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Compare is a tool that can compare files, SQL Server objects, and folders. It can also be integrated as an add-in into SQL Server Management Studio and Visual Studio or it can be used directly from command line interface. It can perform two-way script comparison and create a merged file. Three comparison modes include Character, Line and Block comparison modes, along with the appropriate syntax highlighting.

ApexSQL Complete

Product page: ApexSQL Complete
Latest release: 25-Jan-2018
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in, that speeds up coding by automatically completing SQL code statements, filling in SQL code fragments and more.

ApexSQL Decrypt

Product page: ApexSQL Decrypt
Latest release: 13-Dec-2017
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Decrypt is a SQL Server development tool that can decrypt SQL objects from multiple SQL databases, located on different SQL Servers. Before decryption, the original DDL script can be previewed in the Query window as the CREATE or ALTER script type. Decryption can be done directly on a database, or by creating one SQL script for all objects or one SQL script per object.

ApexSQL Plan

Product page: ApexSQL Plan
Latest release: 29-Jan-2018
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Plan is a SQL query analysis and optimization tool. It identifies performance issues and deadlocks, analyzes stored procedures, SQL Server query issues and query execution plans, and helps you understand query performance characteristics.

ApexSQL Propagate

Product page: ApexSQL Propagate
Latest release: 25-Sep-2017
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Propagate is a SQL Server development tool that can execute multiple SQL scripts on multiple SQL databases, located on any SQL Servers, with one-click. Before execution, it can parse SQL scripts to check if their execution will pass or fail. Execution results can be exported into Text or CSV files.

ApexSQL Refactor

Product page: ApexSQL Refactor
Latest release: 22-Jan-2018
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Refactor is a SQL Server Management Studio and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 6 refactors such as table partitioning, safe rename, wildcard expansion and more.

ApexSQL Search

Product page: ApexSQL Search
Latest release: 11-Dec-2017
Supported versions: 2005 – 2017
Author: ApexSQL
Description: ApexSQL Search is a SQL Server Management Studio and Visual Studio add-in for SQL object and data text search, extended property management, safe object rename and object dependency visualization.

BI Developer Extensions

Product page: BI Developer Extensions
Latest release: 15-Dec-2017
Supported versions: 2015 – 2017
Author: Darren Gosbell
Description: A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI).

ClearTrace

Product page: ClearTrace
Latest release: 10-Sep-2017
Supported versions: 2008 – 2016
Author: Bill Graziano
Description: Summarize SQL Server Query Performance. Enhance SQL Server Performance Tuning. Tool “normalizes” the SQL statements to eliminate transient differences in SQL statements.

Comparator

Product page: Comparator
Latest release: 8-Oct-2017
Supported versions: 2008 – 2016
Author: Alex Pumpet
Description: A simple program for compare table data from two sources – SQL databases, Excel, CSV or XML-files.

Database Experimentation Assistant

Product page: Database Experimentation Assistant
Latest release: 3-Jan-2018
Supported versions: 2005 – 2017
Author: Microsoft
Description: Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions to any new version of the SQL Server will be able to use these analysis metrics provided, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data, to help them build higher confidence, making it a successful upgrade experience.

Database Health Monitor

Product page: Database Health Monitor
Latest release: 28-Oct-2017
Supported versions: 2005 – 2016
Author: Steve Stedman
Description: 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.

Database Modeling Excel

Product page: Database Modeling Excel
Latest release: 30-Nov-2017
Supported versions: Unknown
Author: Yang Ning (Steven)
Description: Database Modeling Excel is an add-in that was developed to allow users to create database structures easily by using Microsoft Office Excel.

Database Performance Analyzer

Product page: Database Performance Analyzer
Latest release: 15-Feb-2018
Supported versions: 2008 – 2017
Author: SolarWinds Worldwide
Description: Reveal performance bottlenecks deep inside your SQL Server, Oracle, DB2 and SAP ASE instances.

Data Migration Assistant

Product page: Data Migration Assistant
Latest release: 3-Oct-2017
Supported versions: 2005 – 2017
Author: Microsoft
Description: 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. DMA replaces all previous versions of SQL Server Upgrade Advisor (SSUA).

DBAchecks

Product page: DBAchecks
Latest release: 22-Feb-2018
Supported versions: Unknown
Author: DBAtools
Description: DBAchecks is a new open source module that allows the SQL Server community to crowdsource our checklists and easily test our environments. DBAchecks is a framework created by and for SQL Server pros who need to validate their environments.

DBAtools

Product page: DBAtools
Latest release: 25-Jun-2018
Supported versions: 2000 – 2017
Author: DBAtools
Description: DBAtools is a free PowerShell module with over 350 SQL Server best practice, administration, development and migration commands included. Currently, other components of SQL Server such as SSIS, SSRS and SSAS are not supported, but they are part of the overall goal. The high number of commands may seem overwhelming, but think of it like learning SQL Server. Start with the basics like Logins, Jobs, or Backup/Restore and later on, you can move on to Extended Events.

DBComparer

Product page: DBComparer
Latest release: 6-Oct-2009
Supported versions: 2005 – 2008
Author: DBComparer
Description: DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures. It is an excellent tool for any project development team or DBA managing multiple copies of the same database on an SQL Server.

DBeaver

Product page: DBeaver
Latest release: 21-Jan-2018
Supported versions: 2005 – 2016
Author: Rider Soft LTD
Description: 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.

dbDiffo

Product page: dbDiffo
Latest release: 28-Jul-2017
Supported versions: Unknown
Author: Contenet Ltd.
Description: The free online database schema designer. With dbDiffo you can create change scripts with a simple click.

dbForge Event Profiler

Product page: dbForge Event Profiler
Latest release: 30-Aug-2017
Supported versions: 2008 – 2017
Author: Devart
Description: Monitor the activity of SQL Server Database Engine, Analysis services, and Integration Services, monitor and identify performance-related problems with front-end application, queries, T-SQL, transactions, and much more, perform query analysis of execution plans, monitor and identify SQL Server errors and warnings, audit user activity, analyze, group, and aggregate trace results, and save them to a file, create own custom traces and save them for future use.

dbForge Monitor

Product page: dbForge Monitor
Latest release: 30-Aug-2017
Supported versions: 2008 – 2016
Author: Devart
Description: dbForge Monitor allows you to track and analyze SQL Server performance. The tool includes a variety tools for SQL Server diagnostics, including a bunch of SQL performance metrics allowing to see the comprehensive and clear picture of all processes taking place on the server, detect most expensive queries, waiting tasks, and performance bottlenecks.

dbForge Search

Product page: dbForge Search
Latest release: 06-Dec-2017
Supported versions: 2005 – 2017
Author: Devart
Description: Allows you to search SQL objects, data, and text in your databases. With dbForge Search, you no longer need to look through the entire SSMS Object Explorer to find a required column name, or text in a stored procedure.

dbForge SQL Decryptor

Product page: dbForge SQL Decryptor
Latest release: 19-Sep-2017
Supported versions: 2000 – 2017
Author: Devart
Description: Decrypts encrypted stored-procedures, views, triggers, and functions. The tool provides you with the highly responsive UI, syntax highlighting, Unicode support, batch mode, decryption caching and much more.

DbViewSharp

Product page: DbViewSharp
Latest release: 8-Aug-2014
Supported versions: 2005 – 2014
Author: David Moore
Description: DbViewSharp is a very useful application that is designed to provide you with a means of exploring and managing SQL databases.

DLM Dashboard

Product page: DLM Dashboard
Latest release: 15-Jul-2016
Supported versions: 2005 – 2016
Author: Redgate
Description: 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. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production.

DTSQL

Product page: DTSQL
Latest release: 18-Aug-2017
Supported versions: Unknown
Author: DigerTech Inc
Description: DtSQL is a universal database tool for developers and database administrators to Query, Edit, Browse, and Manage database objects. It can access most databases and can be used on all major operating systems. DtSQL is a universal database tools which can create, alter, browse and search database objects, execute SQL scripts and edit tables. DtSQL can generate and execute the SQL to create the new schema. DtSQL has tools to edit, format and execute SQL scripts. Enable SQL variable bound prompt.

ERDesigner NG

Product page: ERDesigner NG
Latest release: 10-Apr-2013
Supported versions: Unknown
Author: Mirko Sertic
Description: The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. 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.

ExpressProfiler

Product page: ExpressProfiler
Latest release: 15-Feb-2016
Supported versions: 2005 – 2014
Author: Oleksii Kovalov
Description: ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project. Tracing of basic set of events (Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout, User error messages, Blocked Process report) and columns (Event Class, Text Data,Login, CPU, Reads, Writes, Duration, SPID, Start/End time, Database/Object/Application name) – both selectable,filters on most data columns, copy all/selected event rows to clipboard in form of XML, find in “Text data” column, export data in Excel’s clipboard format.

Flyway

Product page: Flyway
Latest release: 30-Jan-2018
Supported versions: 2014 – 2017
Author: Boxfuse GmbH
Description: Flyway is an open-source database migration tool. It strongly favors simplicity and convention over configuration. It is based around just 7 basic commands: Migrate, Clean, Info, Validate, Undo, Baseline and Repair. Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, etc.) is supported) or Java (for advanced data transformations or dealing with LOBs).

HammerDB

Product page: HammerDB
Latest release: 16-Jun-2017
Supported versions: Unknown
Author: Steve Shaw
Description: HammerDB is a database load testing and benchmarking tool. You use HammerDB to create a test schema, load it with data and simulate the workload of multiple virtual users against the database for both transactional and analytic scenarios. This workload can then be used to derive meaningful information about your environment such as hardware performance comparisons and software configurations.

HeidiSQL

Product page: HeidiSQL
Latest release: 19-Dec-2017
Supported versions: 2005 – 2016
Author: Ansgar Becker
Description: 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.

Is It SQL

Product page: Is It SQL
Latest release: 10-Sep-2017
Supported versions: 2005 – 2016
Author: Bill Graziano
Description: 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.

MSKerberos Configuration Manager

Product page: MSKerberos Configuration Manager
Latest release: 22-Nov-2017
Supported versions: 2008 – 2017
Author: Microsoft
Description: Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services, and SQL Server Analysis Services.

LIQUIBASE

Product page: LIQUIBASE
Latest release: 24-Oct-2016
Supported versions: Unknown
Author: Datical
Description: 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.

Manduka

Product page: Manduka
Latest release: 8-Mar-2017
Supported versions: Unknown
Author: Virtusa Corporation
Description: The Free Static code analyzer: PL-SQL & T-SQL, support for more than 50 violation rules, lightweight& fast, easy to install & use, xml reports.

Partition Management

Product page: Partition Management
Latest release: 28-Nov-2012
Supported versions: 2005 – 2012
Author: SQLCAT
Description: This tool uses the Sliding Window technique to remove data from one partition and place it into a staging table, and creates a staging table that’s used to load data into partitions.

Plan Explorer

Product page: Plan Explorer
Latest release: 27-Oct-2017
Supported versions: 2005 – 2017
Author: SentryOne
Description: Plan Explorer helps you quickly get to the root of the toughest SQL Server query problems. Plan Explorer’s scoring algorithms help you determine the best index to support a given query. Easily view recommended indexes, create and modify indexes, and detect and update old statistics.

Powershell Scripts

Product page: Powershell Scripts
Latest release: Unknown
Supported versions: 2008 – 2017
Author: Idera
Description: 102 sample PowerShell scripts to manage SQL Server objects, for Database Engine, and for Analysis, Integration and Reporting Services.

PSDatabaseClone

Product page: PSDatabaseClone
Latest release: 27-Jul-2018
Supported versions: Unknown
Author: Sander Stad
Description: PSDatabaseClone is a PowerShell module dedicated to the provisioning of databases using virtual disk technology. Provisioning databases from our production servers has been a pain since the dawn of the DBA. Nowadays we’re dealing with databases that are terabytes in size and some of even work with databases that stretch the imagination for the most of us. You want to have a tool that enables you to create an image of your database and clone your image to one or more servers in a matter of minutes.

Pssdiag&Sqldiag Manager

Product page: Pssdiag&Sqldiag Manager
Latest release: 6-Jan-2017
Supported versions: 2008 – 2016
Author: Jack Li
Description: Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems.

Rapid Database Extractor

Product page: Rapid Database Extractor
Latest release: Unknown
Supported versions: 2008 R2 – 2017
Author: Idera
Description: 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).

RML Utilities

Product page: RML Utilities
Latest release: 12-Dec-2014
Supported versions: 2005 – 2014
Author: Microsoft
Description: The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing.

SchemaCrawler

Product page: SchemaCrawler
Latest release: 10-Jan-2018
Supported versions: Unknown
Author: Sualeh Fatehi
Description: SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format.

Simple Dynamic Scheduler

Product page: Simple Dynamic Scheduler
Latest release: 23-May-2016
Supported versions: 2008 – 2014
Author: Miljan Radovic
Description: Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store all configurations and logic. Main characteristics of Simple Dynamic Scheduler are: simple, dynamic, light-weight, purely T-SQL, open source.

sp_Blitz®

Product page: sp_Blitz®
Latest release: 2-Jun-2016
Supported versions: 2005 – 2016
Author: Brent Ozar
Description: Fast, easy, free health check that flags common issues in seconds, and for each warning, gives you a link to a web page with more in-depth advice.

sp_whoisactive

Product page: sp_whoisactive®
Latest release: 10-Dec-2017
Supported versions: 2005 – 2017
Author: Adam Machanic
Description: sp_whoisactive is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server from 2005 through 2017

SQuirreL SQL Client

Product page: SQuirreL SQL Client
Latest release: 29-Aug-2017
Supported versions: Unknown
Author: Colin Bell, Gerd Wagner
Description: SQuirreL SQL Client is a JAVA-based database administration tool for JDBC compliant databases. It allows you to view the database structure and issue SQL commands. It provides an editor that offers code completion and syntax highlighting for standard SQL. It supports databases such as Firebird, IBM DB2, InterBase, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostreSQL, and Sybase.

SQL Admin Studio

Product page: SQL Admin Studio
Latest release: Unknown
Supported versions: 2005 – 2014
Author: Simego Ltd
Description: SQL Tools is a Fast and Lightweight (FREE) SQL Manager for Microsoft SQL Server. Features: execute SQL Scripts, view and edit data, create tables and views, compare and sync data between SQL Databases, compare and Sync Schema between SQL Databases.

SQL Backup Status Reporter

Product page: SQL Backup Status Reporter
Latest release: Unknown
Supported versions: 2008 R2 – 2017
Author: Idera
Description: 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 BI Check

Product page: SQL BI Check
Latest release: Unknown
Supported versions: 2005 – 2017
Author: Idera
Description: 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.

SQLC

Product page: SQLC
Latest release: Beta release
Supported versions: 2012 – 2016
Author: SQLC
Description: SQLC is a software tool for comparing two SQL Server databases. With SQLC you can compare database objects (schema comparison) as well as compare the data in tables (data comparison).

SQL Check

Product page: SQL Check
Latest release: Unknown
Supported versions: 2008 R2 – 2017
Author: Idera
Description: Check out what happens in batches, compilations, recompilations, and transactions throughout the SQL Server environment without experiencing any surprises and know where to direct your attention to prevent potential issues. Monitor some of the most important metrics in SQL Server including wait stats, reads, writes, session details, and cache hits. Quickly and easily get up and running within minutes using the installation wizard to guide you through the install process.

SQL Cop

Product page: SQL Cop
Latest release: 23-Aug-2010
Supported versions: 2000 – 2008 R2
Author: LessThanDot LLC
Description: The purpose of SQL Cop is to highlight potential problems in your SQL Server database. SQL Cop detects many different issues.

SQL Column Search

Product page: SQL Column Search
Latest release: Unknown
Supported versions: 2005 – 2017
Author: Idera
Description: Find potentially sensitive data; search an entire instance or a specific table; export results to CSV format for easy analysis and reporting.

SQL Converter

Product page: SQL Converter
Latest release: 15-Dec-2015
Supported versions: Unknown
Author: Alaa Ben Fatma
Description: SQL Converter is the utility, allowing one to extract information from source servers selectively and save it to a variety of formats.

SQL Data Profiler

Product page: SQL Data Profiler
Latest release: 23-Oct-2017
Supported versions: 2008 – 2017
Author: Idera
Description: Profile data in SQL Server tables. Analyze subsets of data types at a time. Adjust profiling thresholds to customize the analysis. Display summary of data in selected table and its columns. Receive recommendations based on data per column. View summary of value distribution per column. Export results to plain text file format.

SqlDiffFramework

Product page: SqlDiffFramework
Latest release: 28-May-2017
Supported versions: Unknown
Author: Michael Sorens
Description: Unique in database comparison, SqlDiffFramework compares live data or saved snapshots from any combination of SQL Server, Oracle, MySql, or ODBC data sources (Access, Excel, CSV files, etc.).

SQLDBSearch

Product page: SQLDBSearch
Latest release: Unknown
Supported versions: 2000 – 2014
Author: Mohamed Bouarroudj
Description: SQLDBSearch is a free SQL Server tool that lets you easily and quickly searches for database objects or SQL statements across your databases.

SQLDBSize

Product page: SQLDBSize
Latest release: Unknown
Supported versions: 2000 – 2014
Author: Mohamed Bouarroudj
Description: SQLDBSize is a free SQL Server tool that allows you to display graphically the size used or reserved by tables, indexes, databases, transaction logs and physical files.

SQLines Data

Product page: SQLines Data
Latest release: 4-Jan-2018
Supported versions: 2005 – 2016
Author: SQLines
Description: SQLines Data is an open source, scalable, parallel high performance data transfer and schema conversion tool that you can use for database migrations and ETL processes.

SQLite & SQL Server Compact Toolbox

Product page: SQLite & SQL Server Compact Toolbox
Latest release: 11-Nov-2017
Supported versions: Unknown
Author: Erik Ejlskov Jensen
Description: Create, manage, develop and maintain embedded database solutions.

SqlDbAid

Product page: SqlDbAid
Latest release: 10-Feb-2018
Supported versions: 2005 – 2017
Author: Miken
Description: SqlDbAid is an intuitive standalone application that will enable you to easily script database items and data.

SQL Dynamite

Product page: SQL Dynamite
Latest release: 5-Oct-2017
Supported versions: 2000 – 2016
Author: Anatoly Sova
Description: 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.

sqlectron

Product page: sqlectron
Latest release: 4-Jan-2018
Supported versions: Unknown
Author: Unknown
Description: Manage PostgreSQL, MySQL and Microsoft SQL Server databases and write and execute queries with the help of this SQL editor that is focused on simplicity.

SQL ExecStats

Product page: SQL ExecStats
Latest release: 11-Feb-2015
Supported versions: 2005 – 2014
Author: Joe Chang
Description: ExecStats started out with a focus on execution plan analysis with cross-referencing index usage to the SQL. Formerly separate programs for performance monitoring and server system architecture discovery via WMI have now been integrated into ExecStats.

SQL-FineBuild

Product page: SQL-FineBuild
Latest release: 28-Oct-2017
Supported versions: 2005 – 2017
Author: Edward Vassie
Description: SQL FineBuild provides 1-click install and best-practice configuration on Windows of SQL Server 2017 down to SQL Server 2005.

SQL Fragmentation Analyzer

Product page: SQL Fragmentation Analyzer
Latest release: Unknown
Supported versions: 2008 R2 – 2017
Author: Idera
Description: Analyze fragmentation by one table or an entire database. Identify databases in need of defragmentation. Set fragmentation thresholds: normal, warning, critical. Connect to cloud and run in cloud (provisional).

SQL Health Monitor

Product page: SQL Health Monitor
Latest release: 27-Dec-2010
Supported versions: 2005 – 2014
Author: ManageEngine
Description: Monitor CPU, memory and disk space utilization of the SQL Servers Get complete details about SQL Server sessions, buffer, memory, locks and latches, auto discover SQL Servers in the network, view general server performance and utilization details with color coded alerts. The tool connects with MS SQL servers and generates easy to visualize desktop reports and graphs. Using the tool, Administrator can monitor up to 2 MS SQL server simultaneously.

SQL Heat Map

Product page: SQL Heat Map
Latest release: Unknown
Supported versions: 2005 – 2017
Author: Idera
Description: The intuitive heat map design provides an easy-to-understand picture of the relative sizes of the tables across each database in your SQL Server instance, so you can rapidly identify the largest capacity consumers. See one visual view of storage utilization in all tables of a database and drill down into each table and index for details.

SQL Hekaton Memory Check

Product page: SQL Hekaton Memory Check
Latest release: Unknown
Supported versions: 2014 – 2017
Author: Idera
Description: 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 Hunting Dog

Product page: SQL Hunting Dog
Latest release: 16-Aug-2015
Supported versions: 2008 – 2014
Author: Alex Maslyukov, Maxim Novikov
Description: SQL Hunting Dog works as an Add in and gives you quick search and smooth navigation. Main features: quickly find tables, stored procedure, functions and views, completely removes the pain of clunky Object Explorer, switch between different servers and databases, perform common operation (select data, modify table, design table, etc.) with ease.

SQL Instance Check

Product page: SQL Instance Check
Latest release: 16-May-2016
Supported versions: 2005 – 2016
Author: Idera
Description: Discover what versions of SQL Server you have by scanning your entire network. Several different scan methods and protocols are available to provide you a complete picture. Scan one IP at a time by IP address, IP range, local subnet, server or computer name, or a stealth probe search. The stealth probe identifies servers registered to the Network Browser Service or the Active Directory.

SQL Integrity Check

Product page: SQL Integrity Check
Latest release: Unknown
Supported versions: 2000 – 2017
Author: Idera
Description: Register databases and SQL Integrity Check will, on a regular basis, verify when the last known successful integrity check was performed. This helps identify any possible corruption early on so you can take action quickly instead of finding out a fix is needed after the corruption has grown even larger in scope.

SQL Job Manager

Product page: SQL Job Manager
Latest release: 19-May-2012
Supported versions: Unknown
Author: Idera
Description: Management console to easily view past and current jobs. Identify and correct job contention. Drag and drop jobs across servers to level workloads. “At a glance” view to see failed or runaway jobs. Customizable calendar view. Connect to cloud and run in cloud (provisional).

SQL Migrator

Product page: SQL Migrator
Latest release: 2016
Supported versions: 2005 – 2016
Author: Datamate Technology
Description: Automatically upgrade objects within a SQL Server Instance from lower to higher versions or just refresh Objects between the same Versions.

SQL Nexus

Product page: SQL Nexus
Latest release: 26-Jul-2017
Supported versions: 2008 – 2016
Author: Jack Li
Description: 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.

SQL Operations Studio

Product page: SQL Operations Studio
Latest release: 17-Jan-2018
Supported versions: 2008 – 2017
Author: Microsoft
Description: SQL Operations Studio (preview) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse, wherever they’re running.

SQL Page Viewer

Product page: SQL Page Viewer
Latest release: Unknown
Supported versions: 2005- 2017
Author: Idera
Description: Displays page level data summary and detail information. Elegant GUI design for fast access in 1 click. Select any SQL server and database table. Navigate to any page data quickly in a tree view. Launch directly within SSMS for optimal usability.

SQL Permissions Extractor

Product page: SQL Permissions Extractor
Latest release: Unknown
Supported versions: 2008 R2 – 2017
Author: Idera
Description: Generate T-SQL scripts for copying of user permissions. Edit, save, and execute permissions scripts. Include object level permissions for selected databases. Four steps to copy, extract, modify and apply changes. Connect to cloud and run in cloud (provisional).

SQLPRep

Product page: SQLPRep
Latest release: 23-Oct-2016
Supported versions: Unknown
Author: Consequential Solutions
Description: SQLPRep 2015 aka SQL Performance Report is software product that takes any TSQL and produces a concise, readable, highlighted performance report allowing you to greatly reduce your time spent in developing, debugging, optimizing, testing and reviewing TSQL. It includes a comprehensive data results comparison feature to identify data changes between your original version and the optimized version of your TSQL.

SQL Query Store Optimizer

Product page: SQL Query Store Optimizer
Latest release: 1-Jul-2016
Supported versions: 2016
Author: Idera
Description: 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.

SQL Search

Product page: SQL Search
Latest release: 7-Dec-2017
Supported versions: 2005 – 2017
Author: Redgate
Description: SQL Search is a free add-in for SQL Server Management Studio (SSMS) and Visual Studio (VS) that lets you search for SQL in your databases. You can find fragments of SQL in stored procedures, views, jobs and more,quickly navigate to objects anywhere on a server,find all references to an object.

SQL Server Migration Assistant for DB2

Product page: SQL Server Migration Assistant for DB2
Latest release: 25-Sep-2017
Supported versions: 2012 – 2017
Author: Microsoft
Description: SQL Server Migration Assistant (SSMA) for DB2 is a tool to automate migration from IBM DB2 database(s) to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion and data migration.

SQL Server Migration Assistant for MySQL

Product page: SQL Server Migration Assistant for MySQL
Latest release: 25-Sep-2017
Supported versions: 2008 – 2017
Author: Microsoft
Description: Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database(s) to SQL Server and Azure SQL DB.

SQL Server Migration Assistant for Oracle

Product page: SQL Server Migration Assistant for Oracle
Latest release: 25-Sep-2017
Supported versions: 2008 – 2017
Author: Microsoft
Description: Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database(s) to SQL Server, Azure SQL DB and Azure SQL Data Warehouse.

SQL Server Migration Assistant for SAP ASE

Product page: SQL Server Migration Assistant for SAP ASE
Latest release: 25-Sep-2017
Supported versions: 2008 – 2017
Author: Microsoft
Description: Microsoft SQL Server Migration Assistant (SSMA) for SAP ASE is a tool to automate migration from SAP ASE database(s) to SQL Server and Azure SQL DB.

SQL Server Migration Assistant for Access

Product page: SQL Server Migration Assistant for Access
Latest release: 25-Sep-2017
Supported versions: 2012 – 2017
Author: Microsoft
Description: Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server and Azure SQL DB.

SQL Server 2005 Best Practices Analyzer

Product page: SQL Server 2005 Best Practices Analyzer
Latest release: 13-Aug-2008
Supported versions: 2005
Author: Microsoft
Description: 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 2008 R2 Best Practices Analyzer

Product page: SQL Server 2008 R2 Best Practices Analyzer
Latest release: 18-Jun-2010
Supported versions: 2008 – 2008 R2
Author: Microsoft
Description: 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

Product page: SQL Server 2012 Best Practices Analyzer
Latest release: 6-Apr-2012
Supported versions: 2012
Author: Microsoft
Description: 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.

SQL Scripts Manager

Product page: SQL Scripts Manager
Latest release: 9-Feb-2017
Supported versions: 2000 – 2017
Author: Redgate
Description: SQL Scripts Manager is a free tool that brings together must-have scripts to enable you to automate common troubleshooting, diagnostic, and maintenance tasks. SQL Scripts Manager gives you quick, easy access to SQL, IronPython, and SMO scripting.

SQL Server Backup

Product page: SQL Server Backup
Latest release: 7-Oct-2016
Supported versions: 2005 – 2017
Author: Ola Hallengren
Description: Database Backup is the SQL Server Maintenance Solution’s stored procedure for backing up databases. This script creates all the objects and jobs needed.

SQL Server Data Tools

Product page: SQL Server Data Tools
Latest release: 19-Apr-2017
Supported versions: 2008 – 2017
Author: Microsoft
Description: SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and redactor databases. You can work with a database project, or directly with a connected database instance on or off-premise.

SQL Server Integrity Check

Product page: SQL Server Integrity Check
Latest release: 7-Oct-2016
Supported versions: 2005 – 2017
Author: Ola Hallengren
Description: Database Integrity Check is the SQL Server Maintenance Solution’s stored procedure for checking the integrity of databases.

SQL Server Index and Statistics Maintenance

Product page: SQL Server Index and Statistics Maintenance
Latest release: 7-Oct-2016
Supported versions: 2005 – 2017
Author: Ola Hallengren
Description: Index Optimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics.

SQL Server Management Studio (SSMS)

Product page: SQL Server Management Studio (SSMS)
Latest release: 7-Dec-2017
Supported versions: 2008 – 2017
Author: Microsoft
Description: SSMS is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. Use SQL Server Management Studio (SSMS) to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud.

SQL Server Monitoring

Product page: SQL Server Monitoring
Latest release: 11-Feb-2016
Supported versions: 2005 – 2016
Author: Spiceworks
Description: With Spiceworks SQL Server Monitoring, you can monitor SQL Server size, connection, speed & more. Spiceworks automatically collects all of the information important to the health of your SQL server databases – including things like memory usage and user connections over time.

SQL Server Storage manager

Product page: SQL Server Storage manager
Latest release: 19-Jun-2012
Supported versions: 2000 – 2008 R2
Author: Lepide Software
Description: Lepide SQL Server storage manager is a free utility to analyze performance and structure of your SQL Servers, providing complete visibility of storage space and performance. It enables IT teams to quickly identify potential issues before they occur. Effectively track, manage and plan disk space utilization across your SQL servers.

SQL Statistics Aggregator

Product page: SQL Statistics Aggregator
Latest release: Unknown
Supported versions: 2005- 2017
Author: Idera
Description: 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 Update Statistics

Product page: SQL Update Statistics
Latest release: Unknown
Supported versions: 2008 R2 – 2017
Author: Idera
Description: 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 XEvent Profiler

Product page: SQL XEvent Profiler
Latest release: Unknown
Supported versions: 2012 – 2017
Author: Idera
Description: View sessions running on servers and the SQL statements they are executing. Group, sort and export events to find what you need and share with others. Simple, clean design provides quick start and run in 2 clicks. Easily connect to both local and remote SQL Servers. Connect to cloud and run in cloud (provisional).

SysKit Pulse

Product page: SysKit Pulse
Latest release: 6-Sep-2017
Supported versions: Unknown
Author: SysKit Ltd.
Description: Automatically discover or manually add servers and server groups to the dashboard. Get information on online/offline server status, performance warnings, and server roles.

TSQLT

Product page: TSQLT
Latest release: 31-Jan-2016
Supported versions: 2005 – 2016
Author: sqlity.net
Description: tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt allows you to implement unit tests in T-SQL. This is important as you do not have to switch between various tools to create your code and your unit tests.

WhatsUp SQL Server Monitor

Product page: WhatsUp SQL Server Monitor
Latest release: Unknown
Supported versions: Unknown
Author: Ipswitch
Description: The WhatsUp SQL Server Monitor is a free tool that shows off Ipswitch monitoring technology you can use to catch problems before they begin to affect users.

xSQL Database Searcher

Product page: xSQL Database Searcher
Latest release: 9-May-2017
Supported versions: 2005 – 2016
Author: xSQL Software
Description: Database Searcher is a free tool that allows you to search the schema of SQL Server databases. Supports simple and complex search expressions, Exports search results to xml or csv files.

YourSqlDba

Product page: YourSqlDba
Latest release: 18-Dec-2017
Supported versions: Unknown
Author: Maurice Pelchat
Description: YourSqlDb is just a very big T-SQL script that helps a lot in automating database maintenance.

The page was last updated on 14-Feb-2018
 

Consider these free tools for SQL Server that improve database developer productivity

 

SQLShack

SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members
SQLShack

Latest posts by SQLShack (see all)

Lists

About SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members

9,793 Views