Database administration tool extensions for windows - Доктор Windows

Приветствую всех посетителей сайта Info-Comp.ru! Сегодня мы рассмотрим 7 популярных расширений для Azure Data Studio, которые очень полезны, и их часто используют разработчики.

Заметка! Обзор Azure Data Studio. Что это за инструмент и для чего он нужен.

Содержание

Schema Visualization
Database Administration Tool Extensions for Windows
Admin Pack for SQL Server
SQL Server Schema Compare
Расширение для работы с PostgreSQL
Query History
Simple Data Scripter

Schema Visualization

Schema Visualization – это расширение для визуального представления схемы базы данных. Иными словами, это своего рода инструмент для создания ER-диаграмм на основе имеющихся данных.

Как Вы знаете, в SQL Server Management Studio есть инструмент для работы с диаграммами баз данных, и он очень функциональный, позволяет создавать объекты базы данных, вносить изменения и т.д.

Schema Visualization – это более простое решение, предназначенное только для того, чтобы понять, как выглядит схема базы данных.

Если Вы используете Azure Data Studio на Windows и ранее пользовались средой SQL Server Management Studio, то Вам обязательно понравится расширение «Database Administration Tool Extensions for Windows», так как оно добавляет две очень полезные возможности, которые есть в SSMS.

Окно для вывода свойств объектов

Если по объекту щелкнуть правой кнопкой мыши, например, по базе данных, таблице или хранимой процедуре, то у Вас появится меню для вызова свойств этого объекта, точно такое же, как в SQL Server Management Studio.

Мастер создания скриптов

В SQL Server Management Studio есть очень полезный функционал, который позволяет сгенерировать скрипт создания объектов базы данных, чтобы, например, использовать этот скрипт на другом экземпляре SQL Server для создания точно таких же объектов, так вот, это расширение добавляет такой функционал в Azure Data Studio.

Заметка! Установка Azure Data Studio на Windows 10.

Admin Pack for SQL Server

Azure Data Studio в первую очередь, конечно же, предназначена для написания SQL кода, однако иногда возникает необходимость выполнять задачи, которые связаны с администрированием баз данных. В таких случаях на помощь придет расширение «Admin Pack for SQL Server», которое объединяет в себе 4 других популярных расширения, связанных с администрированием базы данных, в частности:

SQL Server Agent – просмотр и управление заданиями, которые настроены на SQL сервере;
SQL Server Profiler – просмотр и управление сессиями, просмотр событий, связанных с T-SQL;
SQL Server Import – мастер для импорта данных из файлов csv и txt;
SQL Server Dacpac – мастер для развертывания и извлечения файлов dacpac.

SQL Server Schema Compare

SQL Server Schema Compare – это расширение для сравнения схем баз данных.

Заметка! Как установить Azure Data Studio на Linux Ubuntu.

Расширение для работы с PostgreSQL

Если наряду с Microsoft SQL Server Вы работаете еще и с другими СУБД, например, с PostgreSQL, то Вам достаточно установить расширение «PostgreSQL», которое позволяет подключаться и работать с PostgreSQL с помощью Azure Data Studio.

Заметка! Как подключиться к PostgreSQL с помощью Azure Data Studio.

Query History

Данное расширение добавляет вкладку «Query History» на панель выходных данных, на которой сохраняется история выполнения SQL запросов.

Simple Data Scripter

Это расширение позволяет быстро сгенерировать скрипт создания данных, сформированных на основе определенного SQL запроса.

Заметка! Если Вас интересует язык SQL, то рекомендую почитать книгу «SQL код» – это самоучитель по языку SQL для начинающих программистов. В ней очень подробно рассмотрены основные конструкции языка.

Database Administration Tool Extensions for Windows

Расширение для работы с PostgreSQL

Admin Pack for SQL Server

SQL Server Schema Compare

Примечание! Если в данном материале отсутствует расширение, которым Вы активно пользуетесь и оно очень полезно, то обязательно напишите его название в комментариях, чтобы другие посетители узнали о нем и смогли попробовать.

Другие интересные ТОПы, опросы и рейтинги:

Рейтинг популярности антивирусов для домашних компьютеров
Рейтинг популярности систем управления базами данных (СУБД)
ТОП 7 популярных языков программирования
Рейтинг популярности дистрибутивов Linux для домашних компьютеров
ТОП 5 популярных CMS для блога

На сегодня это все, надеюсь, материал был Вам интересен, пока!

Источник

Azure Data Studio Extensions

If you are having problems accessing the Extensions Manager on Azure Data Studio, you can download the extension you need below.

List of Extensions

First Party Extensions

Name	Download Link	Repository Link	Description
Admin Pack for SQL Server	VSIX	Microsoft/azuredatastudio	A collection of popular database administration extensions to help manage SQL Server
Database Administration Tool Extensions for Windows	VSIX	Microsoft/azuredatastudio	Adds Windows-specific functionality to Azure Data Studio, including launching a set of SQL Server Management Studio (SSMS) experiences directly from Azure Data Studio
SQL Server Agent	VSIX	Microsoft/azuredatastudio	Helps manage and troubleshoot SQL Server Agent jobs and configuration (early preview)
Azure Arc	VSIX	Microsoft/azuredatastudio	Users can deploy data controllers, Postgres, Managed Instance for Arc, connect to data controllers, access data service dashboards and work with Azure Arc Jupyter Books.
ASDE-Deployment	VSIX	Microsoft/azuredatastudio	Users gets a notebook-based experience to deploy Azure SQL Edge.
Azure CLI	VSIX	Microsoft/azuredatastudio	Users gain access to experimental and pre-release commands along with the ability to write your own CLI interfaces.
Azure Monitor Logs	VSIX	Microsoft/azuredatastudio	Enables users to connect to Azure Monitor Logs, browse Log Analytics workspaces and write KQL queries and notebooks in Azure Data Studio.
Central Management Servers	VSIX	Microsoft/azuredatastudio	Allows users to organize and store lists of instances as one or more groups, where actions taken using a CMS group act on all servers in the server group (early preview)
SQL Server Dacpac	VSIX	Microsoft/azuredatastudio	Provides an easy-to-use wizarding experience to deploy and extract .dacpac files and import and export .dacpac files
SQL Server Schema Compare	VSIX	Microsoft/azuredatastudio	Provides an easy to use experience to compare .dacpac files and databases and apply the changes from source to target.
Data Virtualization	VSIX	Microsoft/azuredatastudio	Support for Data Virtualization in SQL Server, including Create External Data wizards.
SQL Server Import	VSIX	Microsoft/azuredatastudio	Streamlines the data import process by providing a wizard that simplifies copying flat files (.csv, .txt, .json) into a SQL Server table
IntelliCode	VSIX	Microsoft/azuredatastudio	IntelliCode enhances software development using artificial intelligence. IntelliCode delivers context-aware code completions and guides developers to adhere to the patterns and styles of their team.
Kusto (KQL)	VSIX	Microsoft/azuredatastudio	Enables users to connect to Azure Data Explorer clusters and databases and write KQL queries and notebooks in Azure Data Studio.
Language Packs	Deutsche Español Français Italiano 한국어 Português Русский 中文(简体字) 中文(傳統) 日本	Microsoft/azuredatastudio	Enables users to connect Language packs enable users to use the majority of ADS and supported first party extensions in their preferred language.
Machine Learning	VSIX	Microsoft/azuredatastudio	Manage Python and R packages with SQL Server machine learning services with Azure Data Studio.Use ONNX model to make predictions in Azure SQL Edge, view ONNX models in an Azure SQL Edge database, Import ONNX models from a file or Azure Machine Learning into Azure SQL Edge database. Create a notebook to run experiments.
Managed Instance Dashboard	VSIX	JocaPC/AzureDataStudio-Managed-Instance	Reports information about the performance and health of the Azure SQL Database Managed Instance
PostgreSQL	VSIX	Microsoft/azuredatastudio-postgresql	Enables users to connect, query, and manage Postgres databases with Azure Data Studio
PowerShell	VSIX	PowerShell/vscode-powershell	Provides rich PowerShell language support for Azure Data Studio
SQL Server Profiler	VSIX	Microsoft/azuredatastudio	Provides a simple SQL Server tracing solution similar to SSMS Profiler, allowing users to create and manage traces and analyze and replay trace results
Query History	VSIX	Microsoft/azuredatastudio	Adds a Query History panel for viewing and running past executed queries.
SandDance for Azure Data Studio	VSIX	Microsoft/SandDance	Provides interactive visualizations that help users explore, understand, and present their data
Server Reports	VSIX	Microsoft/azuredatastudio	Provides useful information about the server’s performance, such as: DB Space Usage, DB Buffer Usage, CPU Utilization, Backup Growth Trend, and Wait counts
SQL Server Assessment	VSIX	Microsoft/azuredatastudio	Provides a mechanism to evaluate the configuration of SQL Server for best practices.
SQL Database Projects	VSIX	Microsoft/azuredatastudio	The SQL Database Projects extension brings project-based database development to Azure Data Studio. In this preview release, SQL projects can be created and published from Azure Data Studio.
Azure SQL Migration	VSIX	Microsoft/azuredatastudio	Enables users to save and close at any step in the migration wizard and resume at a later point. Users can now retry a failed / cancelled / succeeded migration where all previously entered details will be pre-populated. Linux Users can now migrate from a source Linux based SQL Server SMB file share that is mounted as a disk within the Linux OS.
Azure SQL Data Warehouse Insights	VSIX	Microsoft/sql-data-warehouse-samples	Provides a dashboard that reports Data Warehouse insights, which can be helpful in scenarios involving managing and tuning data warehouses to ensure they are optimized for consistent performance
WhoIsActive	VSIX	Microsoft/azuredatastudio	Displays insights from sp_whoisactive, a useful tool for activity monitoring and troubleshooting, as graphs and tasks inside an Azure Data Studio dashboard
.NET 6 Runtime	VSIX	—	Provides .NET runtime binaries for use by other extensions
Extension for Oracle	VSIX	—	Azure Data Studio extension for Oracle
Database Schema Conversion Toolkit (Oracle to Microsoft SQL)	VSIX	—	Azure Data Studio extension to convert Oracle Database objects to Microsoft SQL Server or Azure SQL database objects
Database Migration Assessment for Oracle	VSIX	—	Provides a mechanism to evaluate the configuration of Oracle Database for migration to Azure
Azure Cosmos DB API for MongoDB	VSIX	Azure/azure-cosmosdb-ads-extension	This extension provides support for Azure Cosmos DB API for MongoDB and MongoDB databases.
MySQL	VSIX	Microsoft/azuredatastudio-mysql	MySQL extension for Azure Data Studio.

Third Party Extensions

Name	Download Link	Repository Link	Description
AlwaysOn Insights	Github	Matticusau/sqlops-alwayson-insights	Provides insights into AlwaysOn Availability components to assist Database Administrators in managing their environment
Atom One Dark Theme	Github	michael-wolfenden/sqlops-theme-onedark	An Azure Data Studio theme based on Atom’s One Dark theme
Combine Scripts	Github	BateleurIO/sqlops-combine-scripts	Allows users to generate and execute a single combined script from several files
First Responder Kit	Github	dzsquared/sqlops-firstresponderkit	Provides access to free health-check scripts from the First Responder Kit and presents introductory execution suggestions
HCQ (High Color Queries)	Github	dzsquared/high-color-queries	A pair of Dark and Light Themes for TSQL in Azure Data Studio
Idera SQL DM Performance Insights	Download page	N/A	Allows users to see high level common performance issues in multi-server dashboard widgets
MongoDB Atlas for Azure Data Studio	VSIX	mongodb-js/vscode	Connect to MongoDB and Atlas directly from your Azure Data Studio environment, navigate your databases and collections, inspect your schema and use playgrounds to prototype queries and aggregations.
MSSQL Db Insights	Github	Matticusau/sqlops-mssql-db-insights	Provides insights into MSSQL Database in more detail than the built-in default widgets
MSSQL Instance Insights	Github	Matticusau/sqlops-mssql-instance-insights	Provides insights into MSSQL Instance in more detail than the built-in default widgets
New Database	Github	kevcunnane/azuredatastudio-newdatabase	Adds 1-click database creation functionality from the Databases folder in Object Explorer or from the command palette
Palenight Theme	Github	joserocha/azdatastudio-material-palenight-theme	An Azure Data Studio theme based on the vscode version of ‘Palenight Theme’
Paste The Plan	Github	dzsquared/sqlops-pastetheplan	Enables users to send XML execution plans to Paste the Plan
Poor SQL Formatter	Github	wsr-publishing/azure-poor-formatter	Uses the Poor Man’s T-SQL Formatter to format T-SQL inside Azure Data Studio
Qpi	Github	qpi — extension	Enables User to monitor performance and troubleshoot performance issues using Query Performance Insights T-SQL library. This works with Azure SQL Managed Instance and the latest version of SQL Server.
Redgate SQL Search	Download page	N/A	Allows users to quickly search for SQL across multiple databases
SentryOne Plan Explorer	Download page	N/A	Provides rich graphical execution plans for queries against SQL Server, simplifying query analysis and tuning
sp_executesql to SQL	Github	PejmanNik/sqlops-spexecutesql-to-sql	Converts sp_executesql to sql, which can be helpful in debugging SQL queries executed by your application
SSMS Keymap	Github	kevcunnane/ssmskeymap	Ports popular SSMS keyboard shortcuts to Azure Data Studio
SQL 4 CDS	Github	MarkMpn/Sql4Cds	Query and modify data in Microsoft Dataverse / Dynamics 365 Sales / CRM instances using standard SQL query syntax

Download Steps

Download the appropriate VSIX package from the tables above.
Open Azure Data Studio, click File, then click Install Extension from VSIX Package. Select the downloaded VSIX package for the extension you would like.

Источник

There are many SQL management tools available in the market, and therefore it is challenging to select the best tool for your SQL project management. The following is a curated list of best SQL tools with key features, and download links. The list contains both open-source (FREE) and commercial (Paid) SQL software.

Name	Platform	Free Trial	Link
ManageEngine	iOS, Android, Windows, Mac, and Linux	Lifetime Free Basic plan	Learn More
SolarWinds Database Performance Analyzer	Linux, and Windows	14 Days Free Trial	Learn More
DbSchema	Windows, Linux, and Mac	Lifetime Free Basic plan	Learn More
DBVisualizer	Windows, Linux, iOS, and Mac	Lifetime Free Basic plan	Learn More
Devart	Windows, Android, iOS, and Mac	30 Days Free Trial	Learn More

1) ManageEngine

ManageEngine Applications Manager is a powerful SQL database monitoring system that supports all versions of Microsoft SQL databases.

#1 Top Pick

ManageEngine Applications Manager

5.0

Integrations: OpManager, AlarmsOne, Analytics Plus, etc.

Data Import From: CSV, Excel, and JSON

Supported Databases: RDBMS, NoSQL, MS SQL, etc.

Create Customized Reports: Yes

Free Trial: Lifetime Free Basic Plan

Visit ManageEngine

Features:

Real-time monitoring of SQL server’s KPIs, queries with granular data.
Exhaustive details on queries that increase latency and load on server.
Code-level diagnostics for queries that are invoked in web applications.
Intelligent fault management helps you pinpoint root cause of faults to reduce MTTR.
Automatic corrective actions can be performed.
Notifications can be sent via email and SMS, and push notifications to mobile devices.
Advanced analytical and capacity planning reports to aid in decisions regarding resource usage.
Seamlessly integrates with OpManager, AlarmsOne, Analytics Plus, Service Desk Plus, ServiceNow, and Slack
Supports multiple languages like English, German, French, Spanish, Chinese, Korean, Hungarian, Japanese, and more
Easily import data from CSV, Excel, and JSON
Offers Cassandra DB, Couchbase, MongoDB, Redis, Memcached, and Oracle NoSQL NoSQL databases
Supports popular databases like RDBMS, NoSQL, MS SQL, Hadoop, PostgreSQL, and more
Offers Customized reports, Application Discovery and Dependency Mapping, Business Service Management, Fault Management and Alerts, Application Analytics, and more
It provides customer support via Chat, Email, Contact Form, and Phone
Supported Platforms: iOS, Android, Windows, Mac, and Linux
Price: Request a Quote from Sales
Free Trial: Lifetime Free Basic plan

Visit ManageEngine >>

Lifetime Free Basic plan

2) Database Performance Analyzer

SolarWinds Database Performance Analyzer is performance monitoring and analysis tool for database admin. It also finds the reason of bottlenecks and reduces the overall cost of database operations.

Database Performance Analyzer

4.9

Integrations: Orion, Jira, Zapier, Intune, MS Teams, etc.

Data Import From: Excel, PDF, and CSV

Supported Databases: PostgreSQL, Oracle, Azure SQL, etc.

Create Customized Reports: Yes

Free Trial: 14 Days Free Trial

Visit Database Analyzer

Features:

Monitor capacity constraints, queries, and server health performance
Expert database and SQL query tuning advisors
Quickly find the cause of complex problems
Identify database problems in real-time
Cross-vendor database support from a single interface
Low overhead on monitored databases
Blocking and Deadlock analysis
Analyze every factor that impacts SQL Server execution
Monitors database in hybrid environments, on-premises, virtualized, and in the cloud
Helps proactively tune queries so applications can respond faster
Seamlessly integrates with Orion, Jira, Zapier, Intune, MS Teams, and Zendesk
Supports multiple languages like English, Deutsch, Portuguese, Chinese, Korean, Spanish, Japanese, French, and more
Easily import data from Excel, PDF, and CSV
Offers MongoDB, DynamoDB, and Couchbase NoSQL databases
Supports popular databases like PostgreSQL, Oracle, Azure SQL, Microsoft SQL Server, MariaDB, Db2, MySQL, Amazon Aurora, and more
Offers Database Anomaly Detection, SQL Query Analyzer, SQL Database Monitor, SQL Server Audit Log, SQL Server Performance Tuning, Customized reports, and more
It provides customer support via Chat, Email, Contact Form, and Phone
Supported Platforms: Linux, and Windows
Price: Request a Quote from Sales
Free Trial: 14 Days Free Trial

Visit Database Analyzer >>

14 Days Free Trial

3) DbSchema

DbSchema is a visual database designer & manager for any SQL, NoSQL, or Cloud database. The tool enables you to visually design & interact with the database schema, design the schema in a team and deploy it on multiple databases, generate HTML5 diagram documentation, visually explore the data and build queries, and so much more.

DbSchema

4.8

Integrations: NuoDb, Azure, and TimescaleDB

Data Import From: CSV, XML, XLS, and XLSX

Supported Databases: SQL, NoSQL, Apache Ignite, etc.

Create Customized Reports: Yes

Free Trial: Lifetime Free Basic plan

Visit DbSchema

Features:

Design schema in the team and deploy on multiple databases
Compare different versions of the schema, generate migration scripts
HTML5 Documentation , Interactive Diagrams, Relational Data Explorer & Visual Query Builder
Schema Synchronization, Random Data Generator, Data Loader, Database Reports
SQL Editor with autocompletion
Seamlessly integrates with NuoDB, Azure, and TimescaleDB
Supports English language
Easily import data from CSV, XML, XLS, and XLSX
Offers Cassandra, Redshift, SQL Server, MariaDB, MongoDB, Azure, Informix, and SQLite NoSQL databases
Supports popular databases like SQL, NoSQL, Apache Ignite, Apache Drill, Azure, Aurora MySQL, Aurora PostgreSQL, Cassandra, Cockroach, and more
Offers Logical Design, Connect to Database and Reverse Engineer the Schema, Interactive Diagrams, HTML5 Documentation, Schema Synchronization, Relational Data Editor, Customized reports, and more
It provides customer support via Email, and Ticket
Supported Platforms: Windows, Linux, and Mac
Price: Plans start at $98 a month.
Free Trial: Lifetime Free Basic plan

Visit DbSchema >>

Lifetime Free Basic plan

4) DBVisualizer

DBVisualizer is a universal database testing tool for developers, analysts and database administrators/users. It provides features to write SQL to query and visualize your data. Design and development features to manage your databases, tables, relations, indexes, triggers, users and etc. DbVisualizer has been downloaded over 6 million times and is being used in over 145 countries.

DbVisualizer

4.7

Integrations: Exasol, MImer, NuoDB, VERTICA, etc.

Data Import From: CSV, HTML, SQL, XML, XLS (Excel), and JSON

Supported Databases: Oracle, MySQL, PostgreSQL, Microsoft SQL Server, etc.

Create Customized Reports: Yes

Free Trial: Lifetime Free Basic plan

Visit DbVisualizer

Features:

Free evaluation of Pro version
Cross-platform
Query optimization with an explain plan feature
Visual query builder using drag and drop
Flexible SQL scripts execution with parameter support
SQL formatting
Command-line interface for headless execution
Seamlessly integrates with Exasol, MImer, NuoDB, VERTICA, and yworks
Supports multiple languages like English, Thai, Korean, Japanese, Chinese, and more
Easily import data from CSV, HTML, SQL, XML, XLS (Excel), and JSON
Offers MongoDB NoSQL database
Supports popular databases like Oracle, MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MongoDB, Cassandra, Google BigQuery, Microsoft Access, Oracle Cloud, and more
Offers Customized reports, Simple SQL coding, Visual query builder, Queries built for repeat use, Access your databases, Explore and visualize, Optimize databases, Inline data editing, and more
It provides customer support via Email, Contact Form, and Phone
Supported Platforms: Windows, Linux, iOS, and Mac
Price: Plans start at $197 a year. 10% Discount on 2nd Year
Free Trial: Lifetime Free Basic plan

Visit DBVisualizer >>

Lifetime Free Basic plan

5) Devart

Devart offers dbForge Studio is a set of tools for management, development, and administration of MySQL and MariaDB databases. This one of the best SQL management tools helps you to create and execute queries, develop and debug routines, and automate database object management.

Devart

4.6

Integrations: Azure, and Jira

Data Import From: CSV, XML, JSON, MS Excel, and Text

Supported Databases: SQL Server, MySQL, Oracle, PostgreSQL, etc.

Create Customized Reports: Yes

Free Trial: 30 Days Free Trial

Visit Devart

Features:

Manage data and schema changes in your MySQL and MariaDB databases
It helps you to analyze database structure differences and easily transfer changes to your MySQL Server.
Fixing issues with index fragmentation
It offers a comprehensive selection of generators that yield massive volumes.
Rebuild tables when complex changes are introduced.
MySQL management tool that generates documentation for your entire MySQL
Seamlessly integrates with Azure, and Jira
Supports multiple languages like English, German, French, Spanish, Portuguese, Italian, and more
Easily import data from CSV, XML, JSON, MS Excel, and Text
Offers MongoDB, and CouchDB NoSQL databases
Supports popular databases like SQL Server, MySQL, Oracle, PostgreSQL, and more
Offers Database Design, Implementation, Testing, Data Loading, Analysis, Maintenance, Source Control, Customized reports, Index Manager, SQL Server Reporting, Database Administration, and more
It provides customer support via Chat, and Email
Supported Platforms: Windows, Android, iOS, and Mac
Price: Request a Quote from Sales
Free Trial: 30 Days Free Trial

Visit Devart >>

30 Days Free Trial

6) SQL Sentry

SQL Sentry is database performance monitoring for the Data Platform, with fast root cause analysis and visibility across the Microsoft data estate. It helps you to manger scheduled events and identifies resource contention in an Outlook-style calendar

Features:

At-a-glance view of database environment health
Proactive alerting and response system
It allows you to find and fix high-impact queries
Storage forecasting powered by predictive analytics
It helps you to identify contributing problems in the OS and virtual environment.
Seamlessly integrates with Dropbox, Google Analytics, Jira, Harvest, Okta, Slack, vmware, Zapier, and Zendesk
Supports multiple languages like English, Dutch, Russian, German, Spanish, French, Portuguese, Norwegian, Italian, and more
Easily import data from Excel, PDF, and CSV
Offers MongoDB NoSQL database
Supports popular databases like SQL Server, Azure SQL, Hyper-V, Amazon RDS and EC2, Azure SQL Database Managed Instance, and more
Offers Actionable performance metrics, Storage forecasting, At-a-glance view of database environment health, Proactive alerting and response system, Customized reports, and more
It provides customer support via Chat, Email, and Phone
Supported Platforms: Windows, Android, Linux, iOS, and Mac
Price: Request a Quote from Sales
Free Trial: 14 Days Free Trial

Visit SQL Sentry >>

14 Days Free Trial

7) Paessler PRTG MySQL Monitoring

Paessler PRTG MySQL Monitoring is a tool that enables you to get all-important SQL queries at a glance. It helps you to optimize the performance of project.

Features:

Provides prompt notification.
Helps you to reduce downtime of your database.
It can measure the time needed to establish a connection and executing a query.
You can get customized reports of database performance in emails.
Provides less downtime of your MySQL database.
You can create your own alerts without any hassle.
Seamlessly integrates with PRTG
Supports multiple languages like English, German, French, Spanish, and more
Easily import data from XML, CSV, and JSON
Offers MongoDB NoSQL database
Supports popular databases like Oracle SQL, Microsoft SQL, MySQL, PostgreSQL, and more
Offers Built-in alarm, Large market share, Ease of use, Extensive monitoring, Simple administration, High speed, Customized reports, and more
It provides customer support via Email, Contact Form, and Phone
Supported Platforms: Windows, Linux, and Mac
Price: Plans start at $1,799.00 Per License Server
Free Trial: 30 Days Free Trial

Visit PRTG MySQL >>

30 Days Free Trial

SysTools

SysTools offers SQL Password Recovery software that helps you remove the reset SQL File password to open a password-protected database. It is an intelligent way to unlock SQL Server SA and user passwords. You can download the full version and reset the SQL password of the desired login account.

Features:

SysTools is a powerful command-line utility that can reset both individual user and SA passwords from the master.MDF file.
It helps you to recover passwords for SQL Server MDF files.
Provide facility to recover Multilingual Password of MDF Files successfully
It helps you recover and reset SQL passwords of any length or type.
Seamlessly integrates with Zapier, Outlook, Gmail, Salesforce, and Leadformly
Supports multiple languages like English, Danish, Portuguese, France, Italian, Norwegian, and more
Easily import data from Excel, and CSV
Offers MongoDB NoSQL database
Supports popular databases like MYSQL, Oracle, Microsoft SQL Server, PostgreSQL, DB2, and more
Offers Recover SQL Database File Password, Recovery Variety of passwords, Reset Selective ID & Passwords, SQL Server SA Password Recovery, Customized reports, and more
It provides customer support via Chat, Email, Contact Form, and Phone
Supported Platforms: Windows
Price: Plans start at $69 a month.
Free Trial: Lifetime Free Basic plan

Visit SysTools >>

Lifetime Free Basic plan

9) EMS SQL Manager

EMS SQL Manager allows users to create and edit SQL Server database objects and create, modify, execute and save SQL queries.

Features:

Full support of PostgreSQL
Visual and text tools for query building
Rapid database management and navigation
Advanced tool for data manipulation
Effective security management
Impressive data export and import capabilities
Powerful visual database designer
Easy-to-use wizards performing PostgreSQL maintenance tasks
Access to PostgreSQL Server through HTTP protocol
Database change management
Seamlessly integrates with Dropbox
Supports multiple languages like English, Russian, Deutsch, French, and more
Easily import data from MS Excel, MS Access, DBF, XML, ODF, TXT, and CSV
Supports popular databases like PostgreSQL, MySQL, SQL Server, Oracle, Interbase, DB2 Server, and more
Offers Customized reports, Database Maintenance, Database Management, Database Migration, Database Analysis, Customizable toolbars, and Localizable program interface
It provides customer support via Chat
Supported Platforms: Windows, and Linux
Price: Request a Quote from Sales
Free Trial: 30 Days Free Trial

Visit EMS SQL >>

30 Days Free Trial

10) Adminer

Adminer is a SQL management client tool for managing databases, tables, relations, indexes, users. It is one of the best SQL tools which has support for all the popular database management systems like MySQL, PostgreSQL, SQLite, MS SQL, Oracle, and MongoDB.

Adminer

Features:

Connect with database server with username and password
Option for selecting existing database or create a new one
Allows modification of the name, type, collation, comment and default values of columns
Add and drop tables and columns. Supports all data types, blobs through file transfer
Display users and rights and change them. Display variables with links to documentation
Manage events and table partitions
Extensive customization options
Supports multiple languages like English, Arabic, Chinese, Czech, Dutch, Estonian, French, German, Hungarian, Italian, Japanese, and more
Easily import data from Excel, and CSV
Offers MongoDB NoSQL database
Supports popular databases like MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, and more
Offers Customized reports, Forums support, Single database per one instance, display checkbox, and more
It provides customer support via Email, and Phone
Supported Platforms: Windows, and Linux
Price: Free Download

Download link: https://www.adminer.org/en/editor/

11) SQuirrel SQL:

It is a JAVA-based database administration tool. This JDBC compliant SQL management tool allows users to view the database structure and issue SQL commands. It also supports databases such as Firebird, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, Sybase, etc.

Features:

Quickly view and edit data in any JDBC-compliant database
Allows to view the database’s metadata
Work with multiple databases on local and remote machines
This SQL tool uses a single interface to work with various database engines
Seamlessly integrates with Microsoft SQL Server, and Vertica
Supports multiple languages like English, French, and more
Easily import data from Excel, and CSV
Supports popular databases like MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, instantDB, and more
Offers Saved Sessions, Improved Object Tree search, Optional query connection pool, Java 18 compatibility, and more
It provides customer support via Email
Supported Platforms: Windows, Linux, and Mac
Price: Free Download

Download link: http://squirrel-sql.sourceforge.net/

12) SQLite Database Browser:

SQLite Database Browser is an open source SQL tool that allows users to create, design and edits SQLite database files. It is one of the best SQL programs which lets users show a log of all the SQL commands that have been issued by them and by the application itself.

Features:

Create and delete indexes
Browse, edit, add and delete records
It Import and export databases from SQL dump files
Examine a log of all SQL commands issued by the application
Seamlessly integrates with Slack
Supports multiple languages like English, Japanese, Korean, and more
Easily import data from Text, Excel, and CSV
Offers Plot simple graphs, Examine a logs, search records
It provides customer support via Email
Supported Platforms: Windows, Linux, and Mac
Price: Free Open Source Tool

Download link: http://sqlitebrowser.org/

13) DBeaver:

DBeaver is an open source database tool for developers and database administrators. It offers supports for JDBC compliant databases such as MySQL, Oracle, IBM DB2, SQL Server, Firebird, SQLite, and Sybase.

DBeaver

Feature:

This SQL software allows to browse and change database metadata, tables, keys and indexes and column.
It’s SQL editor includes auto-formatting, auto-completion, and hyperlinks
This free SQL query tool allows searching database objects like tables, columns, constraints, and procedures
Seamlessly integrates with Git
Supports multiple languages like Chinese, Russian, Italian, and more
Easily import data from CSV, XML, and JSON
Offers MongoDB, Cassandra, InfluxDB, Redis, Amazon DynamoDB, and Amazon Document DB NoSQL databases
Supports popular databases like Athena, Apache Hive, Babelfish, Cache, Clickhouse, CrateDB, CUBRID, DB2, DuckDB, Data Virtuality, DBF, Denodo 8, Dremio, EDB, and more
Offers Customized reports, Visual SQL query builder, Task scheduler, Analytical charts generation, Mock data generator, Advanced schema compare, Advanced SQL execution, and more
It provides customer support via Email
Supported Platforms: Windows, Linux, and Mac
Price: Free Open Source Tool

Download link: http://dbeaver.jkiss.org/download/

14) HeidiSQL:

HeidiSQL is another reliable SQL management tool. It is designed using the popular MySQL server, Microsoft SQL databases, and PostgreSQL. It allows users to browse and edit data, create and edit tables, views, triggers and scheduled events.

Features:

This database IDE allows to connect to multiple servers in one window
Create and modify tables, views, stored routines and scheduled events.
Export from one server database into another server
This SQL application helps you to manage user privileges
Browse and edit table data using a comfortable grid
Monitor and kill client-processes
Repair and Optimize tables in a batch manner
Seamlessly integrates with MindsDB
Supports multiple languages like English, Russian, Latvian, and more
Easily import data from CSV, HTML, XML, SQL, and LaTeX
Offers MariaDB, and SQLite NoSQL databases
Supports popular databases like MariaDB, MySQL, MS SQL, PostgreSQL, SQLite, Interbase, Firebird, and more
Offers Connect to multiple servers in one window, Connect to servers via command line, Connect via SSH tunnel, or pass SSL settings, Generate nice SQL-exports, and more
It provides customer support via Phone
Supported Platforms: Windows, Android, iOS, and Mac
Price: Free Open Source Tool

Download link: https://www.heidisql.com/download.php

15) ApexSQL Monitor:

ApexSQL Monitor is a web-based SQL management application. It is one of the best SQL software that provides support for monitoring multiple SQL Server instances.

Features:

View system performance metrics
Identify deadlocks and performance issues
Use comprehensive dashboard for viewing metrics
Analyze query waits and review query execution plans
Calculate baselines and thresholds
Seamlessly integrates with Bamboo server, VSTS, Microsoft SQL Server, and more
Supports multiple languages like English, French, German, and more
Easily import data from CSV, Excel, Word, XML, and JSON
Offers MongoDB NoSQL database
Supports popular databases like MySQL, and MariaDB
Offers Customized reports, Auditing and compliance, Database backup, Disaster recovery, Forensic auditing, Index defragmentation, Inventory management, Object level restore, and more
It provides customer support via Phone
Supported Platforms: Windows, Linux, Android, iOS, and Mac
Free Trial: 14 Days Free Trial
Price: Request a Quote from Sales

Download Link: https://www.apexsql.com/Download.aspx?download=Monitor

16) Toad:

Toad is another SQL Server DBMS tool. It is one of the best IDE for SQL that maximizes productivity using extensive automation, intuitive workflows, and built-in expertise. This SQL management tool resolve issues, manage change and promote the highest levels of code quality.

Toad

Features:

Access key data quickly for in-place analysis and single-click export to an Excel instance
It can easily identify differences by comparing and syncing servers, data, and schemas.
Roll back transactions directly from the transaction log without need to restore from a backup
Get powerful query tuning capabilities
Execute scripts and T-SQL snippets for numerous instances and servers
Enable performance tuning with automated SQL scan and optimization
Get free performance health checks benchmarked from the community
Perform application performance tuning with automated query rewrites and optimization
Automate repetitive processes like data and schema comparisons
Seamlessly integrates with Bamboo, VCS, TFS, Git
Supports multiple languages like English, Japanese, Chinese, and more
Easily import data from CSV, JSON, and Excel
Offers MongoDB, and AngularJS NoSQL databases
Supports popular databases like Oracle, SQL Server, IBM DB2, MySQL, NoSQL, Postgres, SAP, and more
Offers Customized reports, Sensitive Data Protection, Code Analysis, Team Coding, Schema Browser, Quick Describe window, Administration, Data Modeling, Performance Testing, and more
It provides customer support via Email
Supported Platforms: Windows, LInux, Android, iOS, and Mac
Free Trial: 30 Days Free Trial
Price: Request a Quote from Sales

Download link: https://www.toadworld.com/downloads

Best FREE SQL IDE / Database Management Software

Name	Platform	Link
ManageEngine	iOS, Android, Windows, Mac, and Linux	Learn More
SolarWinds Database Performance Analyzer	Linux, and Windows	Learn More
DbSchema	Windows, Linux, and Mac	Learn More
DBVisualizer	Windows, Linux, iOS, and Mac	Learn More
Devart	Windows, Android, iOS, and Mac	Learn More
SQL Sentry	Windows, Android, Linux, iOS, and Mac	Learn More
Paessler PRTG MySQL Monitoring	Windows, Linux, and Mac	Learn More
SysTools	Windows	Learn More
EMS SQL Manager	Windows, and Linux	Learn More

FAQs

❓ What are Database Management Tools?

Database Management Tools or SQL Management Tools are software applications that help users to manage SQL server infrastructure. These SQL server tools allow users to configure, manage, monitor, and administer SQL servers and databases.

💻 Which are the best SQL Server Tools?

✅ How to choose the best Database Management Tool?

You should consider the following factors while choosing the best Database management software:

Support for both structured and unstructured data types
Security features
Integration with other software
Scalability
Performance
User Interface and Navigation
Support for multiple OS and Frameworks
Server Administration and Server reporting
Customization features

Источник

Storing reference and transaction information in a database makes it easier for all of your business functions to share data and get faster access to it. Find out about the options available to your enterprise when you seek new database management software and tools.

@VPN_News UPDATED: January 25, 2023

Databases are widely used by businesses to store reference data and track transactions. Websites need databases and Enterprise Resource Planning (ERP) systems need them.

The Database Management System (DBMS) is the software that formats data for storage in databases and gives access to it through data retrieval methods. It is difficult to get an overview of your data through command line SQL. A graphical user interface gives you a much better way of checking the status of your database and managing it properly with better visibility.

If you are starting to look around for software to meet your business needs, you are going to encounter a lot of options that have a database system as their base. Sophisticated interfaces to new database tools make it easier for anyone in the business to create and run a database – you no longer need a specialist database technician or Database Administrator.

Here is our list of the best database management software:

SolarWinds Database Performance Analyzer EDITOR’S CHOICE A live monitor plus a query optimizer that is also able to produce recommendations on how to tune a database for better response times. This tool uses threshold alerting for database status monitoring and AI techniques for tuning recommendations. Download the 14-day free trial.
Datadog Database Monitoring (FREE TRIAL) Leading database management system that features database and query optimization systems. This cloud-based system is great for root cause analysis of database issues with alerting systems that you can set for leaving your database unattended. Start a 14-day free trial.
Aquafold Aqua Data Studio (FREE TRIAL) This package is a database design and creation tool for databases, both relational and NoSQL. It includes a query builder and an optimizer that helps you improve both database structures and queries. Available for Windows, Linux, and macOS.
Site24x7 SQL Server Monitoring (FREE TRIAL) A monitoring system for networks, servers, applications, and websites that includes database monitoring. This is a cloud-based service.
ManageEngine Applications Manager (FREE TRIAL) This monitoring tool tracks the system usage of DBMSs, their internal performance issues, database structures, SQL performance, and the interaction of the database with other applications. Installs on Windows Server and Linux.
SolarWinds SQL Sentry (FREE TRIAL) A monitoring system for SQL Server that can supervise instances on cloud platforms, on virtualizations, and on Linux as well as Windows. Installs on Windows Server.
Navicat for MySQL A database administration interface that can manage instances in many different locations and organize distributed and replicated databases. Other Navicat versions specialize in Postgres, Oracle, and SQL Server databases.
RazorSQL A useful front end for a range of DBMSs that provides a common query and data management language that gets interpreted into specific RDBMS SQL flavors.
Microsoft SQL Server Management Studio A free tool from Microsoft that makes the administration of SQL Server database easier.
MySQL Workbench A free tool produced by Oracle to help manage and tune MySQL databases.
TeamDesk and online database creator and is aimed at small enterprises that probably don’t have a DBA on staff.
TablePlus A unifying front end for disparate RDBMSs that makes the administration of many different databases a lot easier.
Sequel Pro A free tool that runs on Mac OS and will manage MySQL databases, including those hosted remotely.
phpMyAdmin A free tool to manage MySQL and MariaDB databases for Windows and Linux.
SQLyog A data management tool for MySQL databases on Windows that is useful for organizing replications and backups.
Knack A proprietary RDBMS that is delivered on the SaaS model from the cloud. The database management system interface includes all of the tools needed to monitor, tune, and backup instances.

The Best Database Management Software & Tools

Here we will look at different database front ends that will help you manage your data effectively. The list here contains a range of SQL management tools that are suitable for individuals up to large organizations with dedicated DBAs.

Our methodology for selecting a database management tool

We reviewed the database management software market and analyzed tools based on the following criteria:

An easy-to-use interface
Full control through to the underlying DBMS
Query optimization features
Performance tracking with alerts
Examination of underlying resource usage by the DBMS
Secure interface, preferably with multiple user accounts with adjustable permission levels for technician access
Free assessment period either through a demo, a money-back guarantee, or a free trial period
Valuable tools at a fair price

1. SolarWinds Database Performance Analyzer EDITOR’S CHOICE

The SolarWinds Database Performance Analyzer will monitor databases in real time and also identify adjustments that could be made to database objects and queries to make better use of resources and reduce performance issues.

Key Features:

Live database monitor
Database tuning
Query optimizer
Status alerts

Why do we recommend it?

The SolarWinds Database Performance Analyzer is a live monitoring tool for databases and it runs on-premises. The system includes an alerting mechanism that draws the DBA’s attention to performance issues, such as resource locks or long-running queries. Watching the usage of the database enables the monitor to identify the reasons why some queries run too long.

The database performance monitoring part of the tool is very similar to the typical behavior of a network performance monitor. A network performance monitor tracks a list of attributes and sets thresholds of acceptable status levels. The Database Performance Analyzer applies this strategy to databases.

The benefit of threshold-based monitoring is that the DBA doesn’t have to sit watching the live performance graphs on the screen. Instead, admin staff can assume that everything is OK with the database until otherwise notified. If a status passes a threshold, the Database Performance Monitor raises an alert. That should draw the attention of technical staff back to the tool in order to find out what performance limits are being approached, what caused the problem, and how to head off disaster.

Threshold levels are placed well within the database’s capabilities, so this is not a last-minute warning. The alerts give the DBA enough time to adjust resources and keep the database running smoothly. SolarWinds deployed machine learning techniques inside the coding of the Database Performance Analyzer so the tool adjusts thresholds over time, as it processes more live performance tracking data. This means that the tool will customize itself to the specific needs of the organization rather than being a standard tool applied in all implementations.

The query analysis section of the Database Analyzer will produce recommendations on more efficient query structures. It can also work out how indexes, views, and other database objects can be adjusted to improve query response times. This section of the Database Performance Analyzer also deploys machine learning.

Who is it recommended for?

The Database Performance Analyzer is primarily a DBA tool. The greatest value that the tool provides comes from its alerting system because that enables DBAs to pay attention to other tasks while the software watches normal activity. The query optimizer tool is also a useful system to identify code that needs to be reworked, although it probably wouldn’t be suitable for developers to have direct access to the analyzer – they would only need to see the output of an analysis of a query. The software runs on Windows Server and Linux.

Pros:

Highly intuitive DB management system tailored for medium to large size database implementations
Monitors in real-time, offering a number of alert and notification options that can integrate into popular helpdesk solutions
Threshold monitoring helps keep teams proactive, and fix issues before they impact performance
Dashboards are highly customizable, and be tailored to individuals or teams
Built-in query analysis helps DBAs build more efficient queries
Leverages machines learning to identify performance bottlenecks

Cons:

Could benefit from a longer 30-day trial period

The SolarWinds Database Performance Analyzer installs on Windows Server. It is able to monitor remote and cloud databases just as easily as onsite instances. SolarWinds offers a 14-day free trial of the Database Performance Analyzer.

EDITOR’S CHOICE

The SolarWinds Database Performance Analyzer is our top pick database management tool because it supports all of a DBA’s activities. The tool will monitor the live statuses of multiple databases simultaneously and only alert staff to potential problems when a threshold is tripped. This frees up DBAs for more important tasks. One of those other activities is performance tuning, which this tool also supports. The SolarWinds software process recommendations for adjustments to database objects as well as identifying inefficient queries.

Download: Start 14-day FREE Trial

Official Website: solarwinds.com/database-performance-analyzer

OS: Windows Server 2012 R2 or later, Windows 10 (eval only), & Linux

2. Datadog Database Monitoring (FREE TRIAL)

Datadog Database Monitoring provides monitoring services for all of the services and applications that support your user-facing software and that includes databases. This package is able to link together the interdependencies between services, creating a stack view that reaches all the way down to the server resources that underpin them.

This monitoring tool is able to track:

On-premises databases
Cloud database services
Big-data and NoSQL systems

The system is able to provide an overview of all of your databases on all sites and cloud platforms. This gives you an overview of all performance regardless of database management system brand or the location of those databases.

Key Features:

Consolidated performance reporting
Drill down paths
Dependency mapping
Resource shortage predictions

Why do we recommend it?

Datadog Database Monitoring is a similar service to the SolarWinds tool except that it is a SaaS package. The Datadog system includes simultaneous automated monitoring for multiple database instances, which can all be of different DBMSs. This provides alerts if performance is impaired. The tool also examines database instance interaction with server resources and identifies the root cause of performance issues.

The combination of monitors for all types of infrastructure means that Datadog is able to show you database performance in context. Your database is dependent on other systems and performance problems might not be caused by their internal processes but by underlying resource shortages or access locks.

The highest plan of Datadog Database Monitoring includes a machine learning process that is able to work out what services access which resources and spot when demand is likely to use up full capacity. With this dependency resource requirement, you can head off performance problems before they get bad enough to be noticed by users.

After quickly ruling out external factors as the cause of database performance problems, Datadog also provides database query and database structure optimization tools. Adding or removing indexes could be the answer to your problems and Datadog’s database analysis system quickly shows you how.

While examining the activities of the database to fulfill the demands of specific requests, you can simultaneously look beneath the DBMS to identify which server resources each query impacts.

Once you are confident that the database is finely tuned, you can leave Datadog to perform ongoing monitoring unattended. A system of thresholds within the monitor will notify you if a performance statistic is bringing in numbers that exceed your requirements for satisfactory operations. Alerts can be forwarded as notifications by email or through apps such as PagerDuty, Jira, Slack, and Webhooks.

Datadog Database Monitoring includes database and query optimization systems as well as monitoring services. This cloud-based platform will give you an overview of all of your databases and then let you examine the performance of each database. The system watches all infrastructure that relates to your databases, making root cause analysis quicker when things go wrong. The Infrastructure system includes an alerting mechanism that lets you leave the package to watch over your databases unattended.

Who is it recommended for?

Like the SolarWinds tool, this system is for use by DBAs. The query analyzer utility in Datadog is not as detailed as that available in the SolarWinds system. It will identify queries that perform badly but won’t provide detailed explanations as to why. So, this tool isn’t for use by code developers.

Pros:

System-wide database performance overviews
Monitors across sites and platforms
Automated monitoring with alerts and notifications
Database and query optimization analyzer
Checks on resources supporting databases
Identifies a stack of application interdependencies

Cons:

The free trial period is only two weeks

Datadog Database Monitoring is a subscription service and there are three editions available. The first of these is Free and it is limited to monitoring five hosts. The two paid plans are Pro and Enterprise, with the higher of these two including machine learning. You can get a 14-day free trial of Datadog Database Monitoring.

Datadog Database Monitoring
Start 14-day FREE Trial

3. Aquafold Aqua Data Studio (FREE TRIAL)

The Aqua Data Studio from Aquafold is a handy tool for those who collaboratively create and manage databases and the applications that access data. The tool can be used to assess existing databases or to create new instances from scratch. Databases are usually designed with applications in mind and so the Aqua Data Studio supports the simultaneous development of queries and database structures.

Key Features:

Database creation workspace
Database visualization
Database creation operation
Query builder

Why do we recommend it?

Aquafold Aqua Data Studio is a completely different tool to the two preceding systems. This package is intended for use by developers. It does have a database instance import system that also enables ERDs to be adjusted and then applied to the instance in the form of object creation and alteration scripts. However, these are secondary functions to the main aim of the tool, which is to support the creation of efficient queries.

Aqua Data Studio can be used to develop and analyze databases on-premises and on the cloud. The system offers an SSH Terminal to facilitate access to remote servers to access the database management system and access database objects.

The DBMSs that Aqua Data Studio can interact with are Oracle, DB2 LUW, DB2 z/OS, MariaDB, Microsoft SQL Server, MySQL, PostGreSQL, Redshift, Greenplum, ParAccel, Teradata Aster, Netezza, Hive, Spark, Impala, and Sybase.

You can use the system to administer databases as well as create them. Ongoing performance analysis lets DBAs check on the response times of databases and adjust resources accordingly. The development tools in the package include an interactive query builder that helps those with little knowledge of SQL create data access queries to feed into their new applications. The service also supports SQL to insert, update, and delete records, keeping an eye on the performance of indexes.

Who is it recommended for?

This system should be used by developers and development project managers. It isn’t meant for ongoing performance monitoring or management of databases by DBAs. You would get the best use out of this tool if a new requirement necessitates the creation of new objects as well as new applications, so you would end up creating new database structures simultaneously with the construction of queries to input and extract data. This is an on-premises software package for Windows, Linux, and macOS.

Pros:

Links together query performance with database structures
Creates schemas of databases to promote discussion
Allows access to the same database design to multiple users
Import or export database structures
Guided query creation

Cons:

A SaaS version would be nice to have

Aquafold Aqua Data Studio runs on Windows, macOS, and Linux. You can access a 14-day free trial to assess the package.

Aquafold Aqua Data Studio
Start 14-day FREE Trial

4. Site24x7 SQL Server Monitoring (FREE TRIAL)

Site24x7 is a cloud-based monitoring platform that offers a number of packages to businesses. Site24x7 Infrastructure is a system that supervises networks, servers, and applications and it includes a database monitoring service.

Key Features:

Database transaction monitoring
System resource monitoring
Encrypted connection for data uploads
Application stack mapping

Why do we recommend it?

Site24x7 SQL Server Monitoring is a SaaS package and it is very similar to the Datadog tool. Site24x7 isn’t only able to monitor SQL Server. The database performance monitor can be adjusted by integrations to give it the capability to monitor many other DBMSs. This tool is a DBA service that includes alerts for performance issues, such as resource locks or long-running queries.

This monitoring system is able to track the performance of It SQL Server, MySQL, Oracle, PostgreSQL, DB2, MongoDB, VoltDB, Cassandra, CouchDB, and ClickHouse DBMSs databases. Site24x7 Infrastructure also searches running processes to identify connections between applications. This enables it to draw up an application stack, which maps the interdependencies of applications, including databases. The application stack is then a key resource if interfaces or applications show performance issues. It supports root cause traces to check whether the real problem is really with another part of the system. It also identifies the resources of the supporting host that are used by the database and watches their capacity.

The database monitor records total temporary tables, space used by temporary tables, temporary tables on disk, and temporary table removal. It logs read and write activities, slow queries, aborted clients, threads, and open files. The system also tracks database connection usage, aborted connections, and the maximum number of used connections.

Site24x7 Infrastructure database monitoring includes an alerting mechanism that is based on performance and resource availability thresholds. This generates an alert whenever a problem arises. The alerts can be forwarded to technicians by SMS, email, voice call, or instant messaging post.

Who is it recommended for?

The big difference between Site24x7 and Datadog is that the Site24x7 system is packaged along with network, server, application, and Web system monitors, whereas Datadog offers compartmentalized mobiles that you can choose to fit together. Site24x7 is a full stack monitoring tool of which the database monitoring system forms a part. All of the elements in the Site24x7 include performance alerts, so if there is a problem with the network, that will raise an alert as well as an application alert and a database alert. This gives you an instant root cause analysis. This makes the Site24x7 database monitor a good tool for system administrators as well as DBAs.

Pros:

Flexible cloud-based monitoring option
Offers a host of out-of-box monitoring options and dashboard templates
Allows administrators to view dependencies within the application stack, good for building SLAs and optimizing uptime
Offers root cause analysis enhances by AI to fix technical issues faster

Cons:

Site24x7 is a feature-rich platform with option that extended beyond databases management, may require time to learn all options and features

You can access a 30-day free trial of the service.

Site24x7
Start 30-day FREE Trial

5. ManageEngine Applications Manager (FREE TRIAL)

ManageEngine Applications Manager is able to monitor software and services running on-premises and also those based in the cloud. This system can monitor relational database management systems, including Oracle, SQL Server, MySQL, Informix, DB2, Sybase, PostgreSQL, Cassandra, MongoDB, and SAP databases. It can also monitor No SQL systems, in-memory databases, and big data systems.

Key Features:

On-premises and cloud application monitoring
Resource usage tracking
Application dependency mapping
Live performance monitoring

Why do we recommend it?

ManageEngine Applications Manager is an on-premises package and it is similar to the Site24x7 option because it is much wider than just a database analyzer. It extends to server resource monitoring but it doesn’t go as far as the Site24x7 system because it doesn’t include network monitoring. The useful feature of the ManageEngine system is that it maps dependencies between applications. This is very important for databases because they are backend systems and so they can be the cause of performance problems that initially appear in user-facing systems.

The Applications Manager tracks all interactions between calling applications and the database. This enables it to spot exactly where performance issues arise – the problem might not necessarily be with the database.

As well as tracking the DBMS activity, the monitor logs the interactions of the database instance with the supporting resources of the host. It checks on disk I/O, cache activity, memory and CPU activity, and system errors. Within the database, the service logs user account access, execution errors, resource locks, and database object usage. The SQL analysis that the tool provides enables DBAs to adjust database objects, such as indexes and views, that can improve SQL performance.

One of the big features of the Applications Manager is its ability to automatically identify all of the applications on a system and how they link together. It creates an application dependency map from its discovery and that live record of connections helps in quickly identifying the root cause of performance problems.

Who is it recommended for?

The ManageEngine system provides very detailed analysis of database activity and includes performance alerts. So, even though it is only part of a very wide applications monitoring system, it is sufficiently focused on database activities to be useful to DBAs in day-to-day instance management. The wider package would be used by systems administrators. This on-premises software package can run on Windows Server and Linux.

Pros:

Offers on-premise and cloud deployment options, giving companies more choices for install
Can highlight interdependencies between applications to map out how performance issues can impact businesses operations
Offers log monitoring to track metrics like memory usage, disk IO, and cache status, providing a holistic view into your database health
Can automatically detect databases, server hardware, and devices in real-time

Cons:

Can take time to full explore all features and options available

ManageEngine Applications Manager installs on Windows Server or Linux. It is available in three editions: Free, Professional, and Enterprise. You can get a 30-day free trial to put it through its paces risk-free.

ManageEngine Applications Manager
Download 30-day FREE Trial

6. SolarWinds SQL Sentry (FREE TRIAL)

SentryOne SQL Sentry, now part of SolarWinds, is offered as a service on Azure but the on-premises version is much more flexible. The installed version runs on Windows Server but it can monitor database instances that are resident on other hosts by connecting across the network.

The system can monitor SQL Server running on Linux, on Azure or Amazon platforms, and on Hyper-V or VMWare virtualizations.

Key Features:

Monitor SQL Server on-premises and on cloud platforms
Resource availability monitoring
Watches multiple instances
Graphics-rich interface

Why do we recommend it?

SQL Sentry is very similar to SolarWinds Database Performance Analyzer. The tool has been bought out by SolarWinds, so now the company has two very similar products. Both tools specifically monitor SQL Server, so it is difficult to choose between them.

The main monitoring screen of SQL Sentry is crowded with graphs that show live performance data, covering a range of metrics. This allows a single database administrator to watch over many databases at a glance.

As well as tracking live events, the SQL Sentry provides a Performance Analysis dashboard. This shows demand and performance over time. It enables DBAs to estimate trend demand growth and also spots peaks and troughs in database activity.

The system offers a “sample mode,” which allows you to pick a specific time and examine all aspects of interaction between server resources and database events.

The long-term view is called “history mode” and lets you see each metric over a timeline that you can adjust. The history mode also provides you with recommendations on where problems have occurred with database performance and what solution could prevent that issue from arising again.

Who is it recommended for?

This is a DBA tool that will produce tips on improving performance for specific queries. Like the other SolarWinds database analyzer, this system can help with adjustment to code rather than supporting the development of new code. Anyone looking for an automated database instance monitoring tool should consider SQL Sentry and the SolarWinds Database Performance Analyzer.

Pros:

A choice between on-premises and cloud deployment
Offers an option to sample all metrics at a point in the past
Includes alerts and warnings for live performance issues
Traces both host resource availability and usage and database activity simultaneously
Shows multiple live performance graphs

Cons:

Focuses on SQL Server and isn’t able to monitor other DBMSs

SolarWinds SQL Sentry installs on Windows and Windows Server or it can be accessed as a service on Azure. You can assess SQL Sentry on a 14-day free trial.

SentryOne SQL Sentry
Start 14-day FREE Trial

7. Navicat for MySQL

Navicat for MySQL is a paid SQL management tool that runs on Windows, Linux, and Mac OS. It can connect to the ideal solution for MySQL and MariaDB databases. Another tool by Navicat can connect to PostgreSQL and Navicat Premium will manage a wide range of RDBMSs, including MySQL, MariaDB, PostgreSQL, Oracle, and SQL Server, and administration and development.

Key Features:

Plug-and-play data migration
Excellent visualization tool
Built-in Intelligent Database Designer
Supports SSH Tunneling and SSL for secure connections

Why do we recommend it?

Navicat for MySQL provides support for the development and management of MySQL and MariaDB systems both on premises and on cloud platforms. The tool provides a live view on database objects and allows them to be altered. This is a useful tool for the development of SQL queries and the programs that include them because the developer can identify the tables and joins needed for each query and use a visual query builder.

The Navicat for MySQL tool can also connect to cloud-based relational databases, such as Google Cloud, Oracle Cloud, Amazon RDS, and Microsoft Azure. This tool supports the creation of database objects as well as the management of data in those tables.

A navigation panel to the left of the GUI window lists the different object types that you can access with the tool. Whichever you select, a list of all of those objects appears in the main screen. Click on an entry to drill down and get details of that object and (in the case of tables) the data it contains. The utility also includes a database design screen to help you create or replan a database.

The interface allows you to connect to two instances simultaneously and contains functions to enable objects to be synchronized between the two. This is a great help for replicating databases and restoring them.

Who is it recommended for?

This Navicat system is intended for use by DBAs and code developers. It works best on an existing database, so it isn’t suitable for designing a database from scratch. A DBA utility in the package allows for comparison between schemas, which assists with coordinating the rollout of objects from development to test instances and from test to production.

Pros:

Sleek and easy-to-use interface
Includes a visual SQL builder
Offers code completion for faster implementations
Supports scheduled reporting, no need to set a reminder every month

Cons:

Documentation could use improvements, steeper learning curve than some other tools
Query building interface could be more intuitive

You can get a 14-day free trial of Navicat for MySQL.

8. RazorSQL

RazorSQL is an extensive suite of SQL management tools that will help you run a relational database that is accessed with SQL. The suite is able to communicate with a long list of RDBMSs, including Oracle, MySQL, SQL Server, PostgreSQL, Informix, and Ingres.

Key Features:

Unifies management access to multiple DBMSs
Standardized SQL
Query interpreter
SQL editor

Why do we recommend it?

RazorSQL acts as a GUI frontend for any database instance. It provides a view of all of the objects in an instance and provides administration functions that enable objects to be added or altered and it will also assist with migrating or replicating an instance structure. Other admin tools include a bulk data loader. Developers can use this tool to refer to tables and indexes and use an editor to build SQL-based programs and scripts.

The interoperability of the tool is particularly useful if you have to deal with several database types on your site. The SQL command set is not exactly the same for all RDBMSs, so you can waste time entering the wrong command format when you switch from one system to another. RazorSQL presents a GUI interface, which it then interprets into commands that get executed in the database. However, if you want to write your own scripts, the utility includes an SQL Editor, which will highlight syntax errors.

The package includes just about all of the functions that you will need in order to administer a database., including backing up data in tables. One thing that is missing from this suite is a form builder that would enable you to create front ends to give your user community safe and easy access to the database.

Who is it recommended for?

RazorSQL can be used with more than 40 DBMSs and its program editor is able to support more than 20 programming languages. This is an excellent tool for DBAs and developers. Ideally, the tool would be used to make minor adjustments to an instance rather than as a system to build a brand-new database.

Pros:

Designed specifically for DevOps and DBAs
Offers syntax highlighting and code completion to help speed up larger projects
Can generate SQL tables directly from within the tool
Supports Windows, Linux, and Mac, making it more flexible than some of its competitors

Cons:

Interface could use improvement, default layout can get cluttered very quickly

This is a paid tool but is very reasonably priced. You can buy the standard package which includes a year of updates and support or opt for more expensive packages with longer support periods. Another dimension in the pricing structure of RazorSQL is the number of people who will use it. The software installs on Windows, Mac OS, and Linux and you can get it on a 30-day free trial.

9. Microsoft SQL Server Management Studio

If you use SQL Server for your DBMS, you would benefit from this free tool by Microsoft. This group of utilities includes a graphical tool that enables you to design a database and decide on the tables for it. The database diagrams produced by the tool are useful as components of your project library and system documentation when you are creating a new database or adapting an existing instance.

Key Features:

Quickly shows database objects
Fast object creation scripts
Free to use

Why do we recommend it?

Microsoft SQL Server Management Studio is the definitive DBA tool for the administration of SQL Server database instances. The utility is free and it gives you a graphical front end for your instances. It is only possible to look at one instance at a time. You can explore the database structures, or use a template to create a table

The Object Explorer is a straightforward graphical representation of a database, showing the tables that have already been created. Template Explorer is a bundle of object creation scripts with prompts so you can enter the object names as you run them.

Solution Explorer is deprecated – it is included in the package but no longer supported. This tool creates “containers”, which bundle together views and scripts that relate to a specific object or group of linked objects.

Who is it recommended for?

This tool is useful as a reference to database objects. It doesn’t provide performance monitoring of correlation to server resources, so any DBA would probably still need to buy another system for automated monitoring. Developers could use this system to look at the objects in a database. You wouldn’t use this tool to create a new database from scratch.

Pros:

Offers database management with flexible built-in visualizations
Object explorer is scalable and robust in even large database environments
Lightweight tool, doesn’t demand a large amount of system resources
Completely free tool

Cons:

Some features within the tool are depreciated

This lightweight package doesn’t include a unifying interface, but the tools will come in useful.

10. MySQL Workbench

MySQL Workbench is a free SQL management tool developed by Oracle. The utility supports database design, development, data management, and migration/backup. The software for the package runs on Windows, Mac OS, and Linux.

Key Features:

SQL management tool
Supported by Oracle
Free to use

Why do we recommend it?

MySQL Workbench is produced by the MySQL team of Oracle, so just as the Microsoft tool above is the definitive utility for managing SQL Server databases, this is the definitive tool for MySQL. Along with a visualization of database objects, this system provides monitoring services that can identify poor indexing and guide developers to better foreign keys for joins.

All of the utilities of MySQL Workbench are accessed through a unifying visual interface. If you are creating a new database, you start off with the Entity-Relationship Diagram creation tool in the package. The detail screens on this diagram enable you to define all of the requirements for the objects in the database.

The SQL Editor supports the object creation tasks of your database creation project. The Editor presents color-coding for statements and clauses, helping you see immediately whether you have made an error in syntax.

The Visual Performance Dashboard of SQL Workbench helps you check on the delivery speeds of an existing database. You can see where objects and their links need to be optimized as the contents of the database grow. The performance dashboard includes attractive graphical data representations, which make problem recognition a lot easier.

Who is it recommended for?

This is a DBA tool and it is free to use, which makes it hard to beat. A nice feature of this tool is that it supports the migration of database instances that are constructed in other DBMSs into MySQL. Code developers can also use this package because it includes an SQL Editor that verifies each clause as it is written.

Pros:

Available on Windows, Linux, and Mac, making it a good OS agnostic option
Easy-to-use SQL editor offers color coding and syntax assistance
Offers built-in performance visualization
Completely free tool

Cons:

Some nested menus make tasks a bit more cumbersome

The Database Migration function in the Workbench is able to manage backups. It will organize transfers of databases into MySQL sourced from other RDBMSs, including Microsoft SQL Server, Microsoft Access, Sybase ASE, and PostgreSQL. Support for this tool is supplied by a user community forum.

11. TeamDesk

TeamDesk is a little different from the other tools on this list. It isn’t a system that helps you manage a DBMS, it is a DBMS. The ethos of TeamDesk is that you don’t need to worry too much about how your database is organized. You create an application, such as a contact utility or an invoice creation and query screen and the tool generates a database behind the scenes to support your new screens. The tool includes a library of templates, which helps you work out the layout of your new screens. This is a great assistant that provides you with fields that you might not have thought to put on your new form.

Key Features:

Cloud-based
Creates databases
Graphical database manager

Why do we recommend it?

TeamDesk is quite a lot like Microsoft Access. It runs in the cloud but you access it from your desktop computer or mobile device through a browser. The system enables anyone to create a database-backed application, which can be for use on your network or as a Web page.

This is a cloud-based service, so you don’t need to install any software in order to use it. You can access the system through a web browser running on any operating system. The configuration of this service and the design of the interface is organized to eradicate the need for you to employ an expert database and network administrator. This makes the tool ideal for a small enterprise, such as an individual or small partnership of owner-workers.

Who is it recommended for?

This system is very suitable for small businesses, particularly for own-er managers that like to be able to do everything for the business. You can cut out the need to hire application developers with this tool. It has tutorials on how to build an application and much of the process of constructing a database. Users who manage to master the skills to create a database and an application will find themselves tempted to make many customized utilities to improve business performance.

Pros:

A full-fledged DBMS with great collaboration features for DevOp teams
Operates in the cloud, no complicated onboarding
Offers built-in graphical database management

Cons:

Interface could use improvement, have to dig for more advanced features

This online package is available in three service levels, which makes it suitable for small to mid-sized businesses. You can create new databases with a free account through the company’s website and this includes access to the template library. It is also possible to create a database by uploading a spreadsheet. This will create the structure of the database including necessary tables and populate them, as well, from the data contained in your spreadsheet. The free account is active for 14 days. Then you will need to pay for the service.

12. TablePlus

TablePlus is a graphical data visualization interface for a range of RDBMS brands. It is capable of connecting to and displaying databases written in MySQL, PostgreSQL, SQL Server, Oracle, and SQLite, among others. The software for the tool installs on Windows and Mac OS.

Key Features:

MySQL, SQL Server, SQLite, Oracle PostgreSQL
Windows and macOS
Encrypted remote connections

Why do we recommend it?

TablePlus is a database management tool that is able to interface with a long list of relational and NoSQL DBMSs. The tool can remotely connect to databases anywhere across the internet with an operation that is like an FTP interface. This gives you access to the database schema and also table contents, both of which can be edited in the TablePlus application.

The interface can be adapted to different themes. The connection between the front end and your database is encrypted and you can also apply multi-level authentication to access the database application. Although ease of use of the graphical user interface makes database exploration a task that non-technical staff could use, this isn’t intended as an end-user tool. It is a support facility for developers and DBAs. The SQL assistant built into the tool is an assistant to trained programmers rather than an automated script generator for untrained staff.

The data browser reads in records from a selected table, enabling you to view, edit, or delete them. An SQL editor helps you to develop scripts through color-coded statement and clause recognition. This editor includes statement formatting and an autocomplete feature.

A data management function enables you to export a database including its data and import that data back again. This is a useful assistant for backup and recovery procedures.

Who is it recommended for?

TablePlus is all about database access for administrators. It doesn’t offer any performance monitoring features. The package includes an SQL editor, so it is good for use by developers or DBAs that need to create ad-hoc query utilities. It probably doesn’t offer enough features to be the main DBA support tool.

Pros:

Interface is easier to use than other DBMSs
Supports multiple database formats including Oracle, SQLite, and MySQL
Is a solid cross-platform solution for Windows and Mac
Convenient SQL Assistant helps aid programmers by highlighting issues and offering suggestions for query improvements

Cons:

Some task can feel delayed, no visual cue that they executed or not

You can get a free trial version of the system, which has operational limits. The pricing structure is based on the number of terminals that you install the software on. The license lets you use the software forever, but the support package that is included lasts for only one year. You get a 7-day money-back guarantee.

13. Sequel Pro

Sequel Pro is only available for Macs. It installs on Mac OS 10.6 and higher. This is a free SQL management tool, but you are able to make a donation to the developers if you wish.

Key Features:

Free to use
Only for macOS
Encrypted remote connections

Why do we recommend it?

Sequel Pro is a free SQL development tool for developers working on Macs. This is a remote access tool, which is ideal for the developers of Web pages that are resident on hosting packages. The tool gives a developer access to the structures and data in a remote MySQL database and it is also possible to use it for uploading data to tables.

This tool is able to interface with MySQL relational databases. You can connect to any database as long as the computer it is on is accessible via the network. This is an open-source project, so you can copy the source code and adapt it. If you have programming skills you could also contribute to the project and submit any improvements you make to be adapted into the core program for others to download. The software is updated every night.

The layout of the Sequel Pro window is a little like a file explorer. A left-hand pane shows all of the tables in your database and the main panel shows all of the records in the currently-selected table. You can also enter SQL queries into the interface and get the results shown in the data viewer. It is possible to use Sequel Pro to export data from your database.

The tool will also import stored data back into your database, or will create the same tables in another database instance and populate it with the data that you backed up.

Who is it recommended for?

This is more of an SQL developer support tool than a DBA tool. The system doesn’t provide any object creation utilities or performance monitoring tools. There also aren’t any features for database replication or migration. This tool runs on macOS and isn’t available for any other operating systems.

Pros:

Completely free Mac database manager
Interface is intuitive, easy to navigate the file explorer even in large databases
Suited for small to medium size databases

Cons:

Not available for Windows
Doesn’t support as many version of SQL as other options

14. phpMyAdmin

The phpMyAdmin utility is a free open source tool for interfacing with your MySQL or MariaDB database. This software will run on Windows and Linux. You can specify that the app enforces two-factor authentication for access control. The tool is a little complicated to set up, so it would be better as an aid to those who have technical training. The actions that the tool allows you to perform on your data also suggest that this is not a desktop database application for end-users in a big corporation.

Key Features:

Free to use
Included with many Web hosting packages
MySQL and MariaDB

Why do we recommend it?

Many subscribers to Web hosting packages will be familiar with phpMyAdmin. This package is frequently used by Web hosting services to provide system management functions to users. Features in the menu of this package provide a utility to create database objects for MySQL and MariaDB. It is also possible to create and save SQL queries through the interface.

You can create, alter, and remove tables and other database objects with this tool. It is also possible to manage user accounts on the database through phpMyAdmin. An SQL editor enables you to develop and execute your own scripts in the relational database. Other functions include the ability to export the entire database to file through the tool – it will also guide you through importing the instance back in from those files.

Who is it recommended for?

This package is suitable for low-volume database object creation. A large organization would not be able to manage a database with this tool because it doesn’t support tasks such as ERD creation or database script generation. Owner-managers of websites are the most likely users of this tool.

Pros:

Completely free and open-source tool
Operates on both WIndows and Linux systems
Offers a robust SQL editing tool
Exports are easy to execute, and allows for a variety of formats

Cons:

Interface is limited, graphical representations can be improved and made easier to read

15. SQLyog

SQLyog

SQLyog is an administration tool for MySQL relational databases and it runs on Windows. The tool is a useful aid to administration because it can export and import databases. You can schedule backups of your database to occur overnight. It is also possible to use SQLyog in order to synchronize between two versions of the same database. Thus, you can mirror your databases for instant recovery, or in order to maintain a test database.

Key Features:

Schedules database backups
Export and import databases
Index optimizer

Why do we recommend it?

SQLyog is a MySQL database support system. It will also manage databases created with MariaDB. This tool provides management for issues such as synchronization and replication of databases where you have copies for development, testing, and production. The system also offers a backup and recovery mechanism. There are some database analysis tools in this package, such as its index analysis service.

This utility’s strengths lie in its ability to analyze existing databases and improve their configurations. It won’t give you advice on normalization, but it will examine the indexes in your database and identify those that conflict. It will also examine your SQL statements and recommend how they could be improved to enhance the speed that results are returned.

The features of this SQL management tool are very sophisticated, and it is aimed at database administrators. However, its ease of use makes it a good option for individuals running a database without extensive training.

Who is it recommended for?

SQLyog is a good tool for managers of small databases. It offers indexing tips and can provide execution analysis that gives an explain plan layout for SQL query execution. This isn’t a tool for use with large databases and it isn’t intended for use in planning and creating new databases.

Pros:

Lightweight tool, ideal for quick tasks such as mirroring and recovery
UI is simple, but not limited or overly complicated
Can compared databases and cross-examine indexes
Feels intuitive, even for junior DBAs

Cons:

Could use a longer trial time for testing

It is a useful facility to close your skills gap. This tool is charged per user. It is available on a 14-day free trial.

16. Knack

Knack

Knack isn’t just a database analysis tool, but an entire DBMS. This is a cloud-based service that stores your database engine for you. So, you have two options; you could either use this service to back up your onsite database and optimize it, and copy down the improved database back to your home database server, or you could do away with your on-premises database entirely.

Key Features:

An independent DBMS
Cloud-based
Use to backup and optimize other databases

Why do we recommend it?

Knack is a similar service to TablePlus. This is a package that enables you to create small applications and simultaneously build databases to support them. The DBMS in this service is a relational system but it is proprietary and relies on a graphical user interface for manipulation rather than an SQL language.

A backup service is built into a Knack subscription. The company creates mirrors of your database engine onto multiple sites to ensure that a catastrophe at its main data center wouldn’t lose your data. Whether or not the continuity of this service is enough to provide you with recoverability is a risk that you would have to assess yourself.

This is a very good solution for small businesses. It includes templates for your database front ends, which include maps, credit card processing, input and query forms, and reports. You can also interface it to well-known apps, such as MailChimp and Dropbox.

Who is it recommended for?

Small business owners that don’t have any training in database development or application coding will enjoy creating customized utilities with Knack. Like TablePlus, this is very similar to Microsoft Access. The system is easy to learn and includes a series of templates that provide a quick way to create professional-looking applications.

Pros:

Highly visual, great for long-term monitoring or NOC environments
Lightweight application hosted in the cloud
Built with smaller businesses in mind
Offers front-end templates for improved time to market

Cons:

Not the best option for larger companies looking for IDE features
Could benefit from a longer trial period

The service is charged for on a monthly subscription with three plan levels, which makes it suitable for businesses of all sizes. Knack is available on a 14-day free trial.

Database Management Software FAQs

How do you monitor database health?

The issue of database health covers a wide range of topics. These include performance issues and also security matters. Performance issues can be heavily influenced by the capacity of supporting infrastructure as well as the efficiency of the DBMS and the manner in which data is organized and indexed. Covering all of these factors requires automated monitoring tools.

What is the importance of database reporting?

Database reporting allows a database administrator to keep tabs on the available capacity of the database. Performance and capacity tracking allow planners to ensure that the database has sufficient resources available to it so that it can continue to support the business.

What are database management system requirements?

There are many different database management systems (DBMSs) available commercially. Oracle, MySQL, PostgreSQL, Microsoft Access, SQL Server, MariaDB, Microsoft Access, and MongoDB are just a few examples.

Источник

At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked by Chris Wood to share all the extensions I use.

It’s worth mentioning that for the most part Azure Data Studio extensions are extremely lightweight, both in download size and memory usage. Installing this many on SQL Server Management Studio (SSMS) would slow it down dramatically.

Note: not all extensions can be installed from the Extensions pane. For many of them you must visit a website, download the VSIX file and install it manually using the File > Install Extension from VSIX Package menu option. In most cases you can trust extensions from reputable publishers, but always take care.

Since I use a MacBook as my day-to-day computer, I am listing two sets of extensions, because some of them have dependencies on the underlying operating system.

Mac version

Admin Pack for SQL Server (Microsoft) – a single package containing SQL Server Agent, SQL Server Profiler, SQL Server Import, and SQL Server Dacpac.
Central Management Servers (Microsoft) – store a list of instances of SQL Server that is organized into one or more groups (more info here).
Data Virtualization (Microsoft) – support for Data Virtualization in SQL Server 2019 and higher, including Virtualize Data wizards.
Delete database (AlexP) – add a “Delete” option when right-clicking on a database.
Demo Mode (Drew Skwiers-Koballa) – toggle the editor font size between your font and a larger font size.
First Responders Kit (Drew Skwiers-Koballa) – work with the First Responder’s Kit from Brent Ozar Unlimited.
Machine Learning (Microsoft) – manage packages and models, make predictions, and create notebooks to run experiments for SQL databases.
MSSQL Db Insights (matticusau) – provide additional dashboard widgets to give you insight into your SQL Server instance.
New Database (Kevin Cunnane) – add a “New Database” option when right-clicking on the Databases folder.
Poor SQL Formatter (WSR Publishing, Inc) – use the popular Transact-SQL code formatter created by Tao Klerks.
PostgreSQL (Microsoft) – connect, query, and manage Postgres databases with Azure Data Studio.
PowerShell (Microsoft) – write and run PowerShell scripts with rich language support including syntax highlighting and IntelliSense.
Query History (Microsoft) – keep a record of past executed queries. Note that it is in preview.
SandDance for Azure Data Studio (msrvida) – visually explore, understand, and present your data.
Schema Visualization (Jens Hunt) – visualize database schemas in Azure Data Studio using mermaid.js.
Server Reports (Microsoft) – get useful performance-related insights, including tempdb.
SQL Server Agent (Microsoft) – manage, configure and troubleshoot SQL Agent jobs.
SQL Server Dacpac (Microsoft) – manage data-tier applications, working with DACPAC and BACPAC files.
SQL Server Import (Microsoft) – the Import Flat File Wizard from SSMS, but in Azure Data Studio.
SQL Server Profiler (Microsoft) – trace queries, but don’t be fooled by the name: this actually uses Extended Events.
SQL Server Schema Compare (Microsoft) – compare DACPAC files and databases, and apply changes.
sp_executesql to SQL (Pejman Nikram) – convert dynamic T-SQL to regular T-SQL for troubleshooting queries.
SSMS Keymap (Kevin Cunnane) – use your favourite SSMS shortcuts in Azure Data Studio.
Visual Studio IntelliCode (Microsoft) – show recommended code completion tips based on context.
whoisactive (Microsoft) – get dashboard insights based on the popular sp_WhoIsActive, written by Adam Machanic.

Windows version

On my Windows development virtual machines I use all of the above extensions, as well as:

Database Administration Tool Extensions for Windows (Microsoft) – get direct access to SSMS, including Properties and Generate Scripts.
Redgate SQL Prompt (Redgate) – get access to snippets and powerful formatting options.
Redgate SQL Search (Redgate) – search for and within objects across multiple databases.
Plan Explorer (SentryOne) – get enhanced execution plan diagrams for queries inside Azure Data Studio.
SQL Assessment (Microsoft) – evaluate the configuration of SQL Server for best practices using the SQL Assessment API.

Share your favourite extensions in the comments below.

Источник

Useful free and paid Microsoft SQL Server utilities and tools — complete list of 395 SQL Server Utilities

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

[B]: Backup solutions {17}
[BI]: Business Intelligence Solutions {4}
[D]: Documentation solutions {8}
[DA]: Database Architecture {20}
[DC]: Data compare {15}
[ETL]: Extract Download Load (ETL) Tools {9}
[I]: Internal SQL Server utilities (for example, bcp) {15}
[IDX]: Index manager {3}
[G]: Data generation {4}
[J]: Job managers {4}
[M]: Monitoring and alerting Tools {27}
[MG]: Migration tool {31}
[MS]: Management Studio (alternative for SSMS) {33}
[REC]: Recovery tools {13}
[S]: Search tools {7}
[SEC]: Security tools {7}
[SC]: Structure compare {21}
[ST]: Statistics utilities {3}
[T]: Testing tools {7}
[?]: Not yet classified {155}

Name/Description	Cross Database	Platform	Type	Official/Download page	Release	Author	License	Free version	Price
SSMS	No	No	[MS]	SSMS	2020-10-27	Microsoft	Freeware	Yes	No
Azure Data Studio	PostgreSQL	Linux,Mac	[MS]	Azure Data Studio	2020-11-12	Microsoft	MIT	Open Source	No
bcp Utility	No	No	[I]	bcp Utility	2012-02-11	Microsoft		Yes	No
sqlcmd Utility	No	No	[I]	sqlcmd Utility	2016-08-23	Microsoft		Yes	No
mssql-cli	No	Linux,Mac	[?]	mssql-cli	2020-05-01	Microsoft	BSD-3	Open Source	No
RML Utilities for SQL Server	No	No	[T]	RML Utilities for SQL Server	2014-12-12	Microsoft		Yes	No
GraphView	No	No	[?]	GraphView	2016-02-23	Microsoft		Yes	No
Baseline Security Analyze	No	No	[SEC]	Baseline Security Analyze	2015-01-09	Microsoft		Yes	No
tablediff Utility	No	No	[I]	tablediff Utility	—	Microsoft		Yes	No
Microsoft Log Parser	No	No	[?]	Microsoft Log Parser	—	Microsoft		Yes	No
Log Parser Lizard GUI	Oracle,MySQL,PostgreSQL,Other	No	[MS]	Log Parser Lizard GUI	2017-06-01	Lizard Labs		Yes	$59
Diskspd	No	No	[T]	Diskspd	2015-12-14	Microsoft		Yes	No
HammerDB	No	No	[T]	HammerDB	2015-05-04	Open Source		Yes	No
Exchange Server Error Code Look-up	No	No	[?]	Exchange Server Error Code Look-up	2004-05-10	Microsoft		Yes	No
LINQPad	No	No	[?]	LINQPad	2016-01-02	Joseph Albahari		Non-commercial	$45
SqlDynamite	No	No	[S]	SqlDynamite	2016-04-06	Anatoly Sova		Yes	No
SQL Server Data Tools	No	No	[MS]	SQL Server Data Tools	2018-04-10	Microsoft		Yes	No
Database Health Monitor	No	No	[M]	Database Health Monitor	2019-12-01	Steve Stedman		Yes	No
SchemaDrift	No	No	[SC]	SchemaDrift	2016-02-28	Steve Stedman		Yes	No
Dbeaver	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	Dbeaver	2020-11-29	Open Source		Yes	No
HeidiSQL	MySQL,PostgreSQL,Other	No	[MS]	HeidiSQL	2020-11-02	Open Source		Yes	No
SQLExecStats	No	No	[ST]	SQLExecStats	2016-02-08	Joe Chang		Yes	No
ExpressProfiler	No	No	[?]	ExpressProfiler	2016-02-15	Chris Moore		Yes	No
Data Migration Assistant	No	No	[MG]	Data Migration Assistant	2020-04-23	Microsoft		Yes	No
SQL Server Migration Assistant for Sybase	No	No	[MG]	Migration Assistant for Sybase	2017-02-17	Microsoft		Yes	No
dta Utility	No	No	[I]	dta Utility	—	Microsoft		Yes	No
osql Utility	No	No	[I]	osql Utility	—	Microsoft		Yes	No
sqldiag Utility	No	No	[I]	sqldiag Utility	—	Microsoft		Yes	No
sqldumper Utility	No	No	[I]	sqldumper Utility	—	Microsoft		Yes	No
SqlLocalDB Utility	No	No	[I]	SqlLocalDB Utility	—	Microsoft		Yes	No
sqllogship Utility	No	No	[I]	sqllogship Utility	—	Microsoft		Yes	No
sqlservr Application	No	No	[I]	sqlservr Application	—	Microsoft		Yes	No
sqlps Utility	No	No	[I]	sqlps Utility	—	Microsoft		Yes	No
sqlmaint Utility	No	No	[I]	sqlmaint Utility	—	Microsoft		Yes	No
SSMS Utility	No	No	[I]	SSMS Utility	—	Microsoft		Yes	No
dtexec Utility	No	No	[I]	dtexec Utility	—	Microsoft		Yes	No
adutil Utility	No	Linux	[I]	adutil Utility	2020-10-30	Microsoft		Yes	No
SQL Server 2016 Report Builder	No	No	[?]	SQL Server 2016 Report Builder	2016-09-16	Microsoft		Yes	No
SQL Server 2005 Best Practices Analyzer	No	No	[?]	BPA 2005	2008-08-13	Microsoft		Yes	No
SQL Server 2000 Best Practices Analyzer	No	No	[?]	BPA 2000	2010-04-26	Microsoft		Yes	No
SQL Server 2008 R2 Best Practices Analyzer	No	No	[?]	BPA 2008	2010-06-18	Microsoft		Yes	No
SQL Server 2012 Best Practices Analyzer	No	No	[?]	BPA 2012	2012-06-04	Microsoft		Yes	No
Elastic database tools	No	No	[?]	Elastic database tools	?	Microsoft		Yes	No
Microsoft Sync Framework	No	No	[?]	Microsoft Sync Framework	2020-04-22	Microsoft		Yes	No
Query Performance Insight for Azure SQL Database	No	No	[?]	Query Performance Insight for Azure SQL Database	?	Microsoft		Yes	No
Microsoft Assessment and Planning (MAP) Toolkit	No	No	[MG]	Microsoft Assessment and Planning (MAP) Toolkit	2020-05-26	Microsoft		Yes	No
DLM Dashboard	No	No	[M]	DLM Dashboard	2016-04-27	Red Gate		Yes	No
Red Gate SQL Compare	No	No	[DC]	Red Gate SQL Compare	2016-10-31	Red Gate		No	$495
Red Gate SQL Data Compare	No	No	[SC]	Red Gate SQL Data Compare	2016-05-09	Red Gate		No	$495
Red Gate SQL Monitor	No	No	[M]	Red Gate SQL Monitor	2015-10-15	Red Gate		No	$1495
Red Gate SQL Backup Pro	No	No	[B]	Red Gate SQL Backup Pro	2014-07-08	Red Gate		No	$995
Red Gate SQL Doc	No	No	[D]	Red Gate SQL Doc	2016-04-26	Red Gate		No	$369
Red Gate SQL Data Generator	No	No	[G]	Red Gate SQL Data Generator	2016-04-26	Red Gate		No	$369
Red Gate SQL Dependency Tracker	No	No	[?]	Red Gate SQL Dependency Tracker	2016-04-26	Red Gate		No	$369
Red Gate SQL Multi Script	No	No	[?]	Red Gate SQL Multi Script	2016-04-15	Red Gate		No	$245
Red Gate SQL Index Manager	No	No	[IDX]	Red Gate SQL Index Manager	?	Red Gate		No	$149
Red Gate SQL Comparison SDK	No	No	[DC],[SC]	Red Gate SQL Comparison SDK	2016-02-22	Red Gate		No	$895
Red Gate SQL Clone	No	No	[?]	Red Gate SQL Clone	2017-02-27	Red Gate		No	$6955
Red Gate SQL Provision	No	No	[?]	Red Gate SQL Provision	2018-02-26	Red Gate		No	$2955
Red Gate Data Masker	Oracle	No	[?]	Red Gate SQL Data Masker	2018-02-26	Red Gate		No	$2395
DLM Automation	No	No	[?]	DLM Automation	?	Red Gate		No	?
ReadyRoll	No	No	[?]	ReadyRoll	2016-01-03	Red Gate		No	$345
Rapid Database Extractor	Oracle	No	[?]	Rapid Database Extractor	2016-11-03	Idera		Yes	No
SQL XEvent Profiler	No	No	[?]	SQL XEvent Profiler	2014-03-14	Idera		Yes	No
SQL Check	No	No	[?]	SQL Check	2015-09-24	Idera		Yes	No
SQL Fragmentation Analyzer	No	No	[?]	SQL Fragmentation Analyzer	2012-11-16	Idera		Yes	No
SQL Heat Map	No	No	[?]	SQL Heat Map	2016-01-27	Idera		Yes	No
SQL Hekaton Memory Check	No	No	[?]	SQL Hekaton Memory Check	2015-06-10	Idera		Yes	No
SQL Page Viewer	No	No	[?]	SQL Page Viewer	2014-08-25	Idera		Yes	No
SQL Update Statistics	No	No	[ST]	SQL Update Statistics	2015-12-14	Idera		Yes	No
SQL Statistics Aggregator	No	No	[ST]	SQL Statistics Aggregator	2015-05-18	Idera		Yes	No
SQL Backup Status Reporter	No	No	[B]	SQL Backup Status Reporter	2015-08-07	Idera		Yes	No
SQL Integrity Check	No	No	[?]	SQL Integrity Check	2013-08-26	Idera		Yes	No
SQL Job Manager	No	No	[J]	SQL Job Manager	2012-03-19	Idera		Yes	No
Azure SQL Database Backup	No	No	[B]	Azure SQL Database Backup	2012-10-02	Idera		Yes	No
SQL Column Search	No	No	[S]	SQL Column Search	2015-11-17	Idera		Yes	No
SQL Permissions Extractor	No	No	[?]	SQL Permissions Extractor	2015-08-07	Idera		Yes	No
SQL BI Check	No	No	[BI]	SQL BI Check	2016-04-13	Idera		Yes	No
SQL Inventory Check	No	No	[?]	SQL Inventory Check	2016-03-24	Idera		Yes	No
SQL Diagnostic Manager	No	No	[?]	SQL Diagnostic Manager	?	Idera		No	$1747
SQL Safe Backup	No	No	[B]	SQL Safe Backup	2016-09-08	Idera		No	$907
SQL Compliance Manager	No	No	[?]	SQL Compliance Manager	2015-09-08	Idera		No	$2657
SQL Inventory Manager	No	No	[?]	SQL Inventory Manager	2016-04-22	Idera		No	$3195
SQL Virtual Database	No	No	[?]	SQL Virtual Database	2016-03-24	Idera		No	$625
SQL Secure	No	No	[?]	SQL Secure	2016-04-19	Idera		No	$907
SQL Doctor	No	No	[?]	SQL Doctor	2015-12-17	Idera		No	$625
SQL Admin Toolset	No	No	[?]	SQL Admin Toolset	2016-01-13	Idera		No	$395
SQL Defrag Manager	No	No	[?]	SQL Defrag Manager	2016-03-10	Idera		No	$1495
DBArtisan	No	No	[?]	DBArtisan	?	Idera		No	$3122
SQL BI Manager	No	No	[BI]	SQL BI Manager	2015-09-08	Idera		No	$697
SQL Enterprise Job Manager	No	No	[J]	SQL Enterprise Job Manager	2015-09-08	Idera		No	$697
DB Optimizer	No	No	[?]	DB Optimizer	?	Idera		No	$1420
SQL Query Store Optimizer	No	No	[?]	SQL Query Store Optimizer	2016-07-01	Idera		Yes	No
Rapid SQL	Oracle,MySQL,PostgreSQL,Other	No	[MS]	Rapid SQL	?	Idera		No	$710
SQL Comparison Toolset	No	No	[DC],[SC]	SQL Comparison Toolset	?	Idera		No	$745
ER/Studio Data Architect	Oracle,MySQL,PostgreSQL,Other	No	[DA]	ER/Studio Data Architect		Idera		No	$1287
DB Change Manager	Oracle,MySQL,PostgreSQL,Other	No	[SC]	DB Change Manager	?	Idera		No	$1420
Uptime Infrastructure Monitor	No	Linux	[?]	Uptime Infrastructure Monitor	?	Idera		No	?
Powershell Scripts	No	No	[?]	Powershell Scripts	?	Idera		No	?
SQL Data Profiler	No	No	[?]	SQL Data Profiler	?	Idera		No	?
SQL Instance Check	No	No	[M]	SQL Instance Check	?	Idera		Yes	?
dbForge Schema Compare	No	No	[SC]	dbForge Schema Compare	2019-10-10	Devart	Shareware	No	$150
dbForge Data Compare	No	No	[DC]	dbForge Data Compare	2019-10-10	Devart	Shareware	No	$150
dbForge Data Generator	No	No	[G]	dbForge Data Generator	2019-10-10	Devart	Shareware	No	$250
dbForge Query Builder	No	No	[?]	dbForge Query Builder	2019-10-10	Devart	Shareware	No	$100
dbForge Event Profiler	No	No	[M]	dbForge Event Profiler	2019-10-10	Devart	Freeware	Yes	No
dbForge SQL Decryptor	No	No	[SEC]	dbForge SQL Decryptor	2017-09-19	Devart	Freeware	Yes	No
dbForge Studio	No	No	[MS]	dbForge Studio	2019-10-10	Devart	Shareware	Yes	$250
dbForge Fusion	No	No	[?]	dbForge Fusion	2019-11-08	Devart	Shareware	No	$150
dbForge Documenter	No	No	[D]	dbForge Documenter	2020-04-23	Devart	Shareware	No	$150
dbForge SSIS Data Flow Components	Oracle,MySQL,PostgreSQL,Other	No	[?]	dbForge SSIS Data Flow Components	2020-03-31	Devart	Shareware	No	$500
dbForge DevOps Automation for SQL Server	No	No	[?]	dbForge DevOps Automation for SQL Server	2020-01-27	Devart	Shareware	No	$900
dbForge Complete	No	No	[?]	dbForge Complete	2020-09-01	Devart	Shareware	No	$199
dbForge SQL Azure Backup	No	No	[B]	dbForge SQL Azure Backup	2013-04-18	Devart	Freeware	Yes	No
Devart Transaction Log	No	No	[B]	Devart Transaction Log	2020-10-19	Devart	Freeware	No	$600
Devart Excel Add-in for SQL Server	No	No	[?]	Devart Excel Add-in for SQL Server	2020-04-13	Devart	Shareware	No	$250
dbMonitor	Oracle,MySQL,PostgreSQL,Other	No	[M]	dbMonitor	2012-11-01	Devart	Freeware	Yes	No
SQL Server Compression Estimator	No	No	[?]	SQL Server Compression Estimator	2011-06-02	Bob Tavlor		Yes	No
ClearTrace	No	No	[M]	ClearTrace	2016-07-07	Bill Graziano		Yes	No
ClearTraceXE	No	No	[M]	ClearTraceXE	2019-09-04	Bill Graziano		Yes	No
Security Explorer	No	No	[SEC]	Security Explorer	2015-06-25	Quest Software		No	$850
LiteSpeed for SQL Server	No	No	[?]	LiteSpeed for SQL Server	2015-07-31	Quest Software		No	?
Toad for SQL Server	No	No	[MS]	Toad for SQL Server	2015-05-12	Quest Software		No	?
Quest Spotlight on SQL Server Enterprise	No	No	[?]	Quest Spotlight	2016-03-10	Quest Software		No	$2561
Quest Foglight	Oracle,MySQL,PostgreSQL,Other	No	[?]	Quest Foglight	2019-08-29	Quest Software		No	$8203
Quest Enterprise Reporter	No	No	[?]	Quest Enterprise Reporter	?	Quest Software		No	$511
SQL Scripter	No	No	[?]	SQL Scripter	2013-02-24	Thomas Hinsenkamp		No	€99
Simple Dynamic Scheduler	No	No	[?]	Simple Dynamic Scheduler	2016-05-02	Miljan Radovic		Yes	No
ApexSQL Audit	No	No	[?]	ApexSQL Audit	2017-07-11	ApexSQL		No	$1699
ApexSQL Backup	No	No	[B]	ApexSQL Backup	2017-10-12	ApexSQL		No	$499
ApexSQL Defrag	No	No	[IDX]	ApexSQL Defrag	2017-06-29	ApexSQL		No	$499
ApexSQL Log	No	No	[?]	ApexSQL Log	2017-05-24	ApexSQL		No	$1999
ApexSQL Monitor	No	No	[M]	ApexSQL Monitor	2017-10-05	ApexSQL		No	$499
ApexSQL Plan	No	No	[?]	ApexSQL Plan	2019-12-02	ApexSQL		Yes	No
ApexSQL Propagate	No	No	[?]	ApexSQL Propagate	2020-02-19	ApexSQL		Yes	No
ApexSQL Recover	No	No	[REC]	ApexSQL Recover	2017-10-26	ApexSQL		No	$1999
ApexSQL Build	No	No	[?]	ApexSQL Build	2017-05-15	ApexSQL		No	$399
ApexSQL Clean	No	No	[?]	ApexSQL Clean	2017-09-28	ApexSQL		No	$399
ApexSQL Data Diff	No	No	[DC]	ApexSQL Data Diff	2017-10-26	ApexSQL		No	$399
ApexSQL Decrypt	No	No	[SEC]	ApexSQL Decrypt	2020-03-12	ApexSQL		Yes	No
ApexSQL Diff	No	No	[SC]	ApexSQL Diff	2017-10-26	ApexSQL		No	$399
ApexSQL Doc	No	No	[D]	ApexSQL Doc	2017-09-06	ApexSQL		No	$299
ApexSQL Generate	No	No	[G]	ApexSQL Generate	2017-07-13	ApexSQL		No	$499
ApexSQL Script	No	No	[?]	ApexSQL Script	2016-05-10	ApexSQL		No	$249
ApexSQL Trigger	No	No	[?]	ApexSQL Trigger	2017-06-01	ApexSQL		No	$1999
ApexSQL Trigger Veiwer	No	No	[?]	ApexSQL Trigger Viewer	2017-06-01	ApexSQL		Yes	No
ApexSQL Snapshot Utility	No	No	[?]	ApexSQL Snapshot Utility	2016-01-12	ApexSQL		Yes	No
ApexSQL Model	No	No	[DA]	ApexSQL Model	2019-05-22	ApexSQL		Yes	No
ApexSQL Analyze	No	No	[?]	ApexSQL Analyze	2017-12-13	ApexSQL		No	$299
ApexSQL BI Monitor	No	No	[BI],[M]	ApexSQL BI Monitor	2018-05-18	ApexSQL		No	$499
ApexSQL VM Monitor	No	No	[M]	ApexSQL VM Monitor	2018-05-09	ApexSQL		No	$999
ApexSQL Job	No	No	[J]	ApexSQL Job	2018-03-29	ApexSQL		No	$499
ApexSQL Enforce	No	No	[?]	ApexSQL Enforce	2018-07-19	ApexSQL		No	$299
ApexSQL CI/CD toolkit	No	No	[?]	ApexSQL CI/CD toolkit	2020-05-21	ApexSQL		Yes	No
ApexSQL Compare	No	No	[?]	ApexSQL Compare	2020-03-17	ApexSQL		Yes	No
ApexSQL Complete	No	No	[?]	ApexSQL Complete	2020-05-28	ApexSQL		Yes	No
ApexSQL Refactor	No	No	[?]	ApexSQL Refactor	2020-06-09	ApexSQL		Yes	No
ApexSQL Search	No	No	[S]	ApexSQL Search	2020-07-30	ApexSQL		Yes	No
ApexSQL Source Control	No	No	[?]	ApexSQL Source Control	2020-01-20	ApexSQL		No	$299
DBBest T-SQL Analyzer	No	No	[?]	DBBest T-SQL Analyzer	2015-03-13	DBBest		No	$89
DBBest Database Compare Suite	No	No	[SC],[DC]	DBBest Database Compare Suite	2015-09-04	DBBest		No	$349
Advanced Query Tool	No	No	[?]	Advanced Query Tool	2015-03-18	Cardett Associates		No	$180
SqlDiffFramework	No	No	[SC]	SqlDiffFramework	2012-04-17	Michael Sorens		Yes	No
DataGrip	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	DataGrip	2017-02-21	Jet Brains		No	$89
Pssdiag and Sqldiag Manager	No	No	[?]	Pssdiag and Sqldiag Manager	2017-01-06	Jack Li		Yes	No
SQL Nexus Tool	No	No	[?]	SQL Nexus Tool	2016-11-20	Jack Li		Yes	No
DBSophic Qure Profiler	No	No	[?]	DBSophic Qure Profiler	?	DBSophic		No	$300
DBSophic Qure Optimizer	No	No	[?]	DBSophic Qure Optimizer	?	DBSophic		No	?
RestoreChecker	No	No	[?]	RestoreChecker	2015-01-15	SQLServerUtilities		No	$99
SQLScripter	No	No	[?]	SQLScripter	2009-08-24	SQLServerUtilities		No	$99
SQLC	No	No	[DC],[SC]	SQLC	2017-11-19	David Ingleton		Yes	No
Database Performance Analyzer	Oracle, MySQL, Other	Linux	[M]	Database Performance Analyzer	?	SolarWinds		No	$1995
Database Performance Analyzer for MSSQL	No	No	[M]	Database Performance Analyzer for MSSQL	?	SolarWinds		No	$1995
SQL Enlight	No	No	[MS]	SQL Enlight	2016-04-25	UbitSoft		No	$295
Aireforge Studio	No	No	[MG],[SC]	Aireforge Studio	2019-08-08	AireForge		Yes	$299
HexaTier	No	No	[?]	HexaTier	?	HexaTier		No	?
SoftTree SQL Assistant	Oracle,MySQL,PostgreSQL,Other	No	[MS]	SoftTree SQL Assistant	2017-12-17	SoftTree		No	$215
DB Audit and Security 360	Oracle,MySQL,Other	No	[SEC]	DB Audit and Security 360	2015-02-07	SoftTree		No	$499
EMS SQL Management Studio	No	No	[MS]	EMS SQL Management Studio	2016-05-26	EMS		No	$257
EMS SQL Backup	No	No	[B]	EMS SQL Backup	2016-04-13	EMS		Yes	$82
EMS SQL Administrator	No	No	[?]	EMS SQL Administrator	2015-04-14	EMS		Yes	$135
EMS SQL Manager	No	No	[?]	EMS SQL Manager	2016-05-26	EMS		Yes	$135
EMS Data Export	No	No	[?]	EMS Data Export	2016-04-29	EMS		No	$47
EMS Data Import	No	No	[?]	EMS Data Import	2016-04-14	EMS		No	$47
EMS Data Pump	No	No	[?]	EMS Data Pump	2016-11-03	EMS		No	$47
EMS Data Generator	No	No	[G]	EMS Data Generator	2010-07-10	EMS		No	$47
EMS DB Comparer	No	No	[SC]	EMS DB Comparer	2015-07-24	EMS		No	$47
EMS DB Extract	No	No	[?]	EMS DB Extract	2008-10-16	EMS		No	$47
EMS SQL Query	No	No	[?]	EMS SQL Query	2012-03-29	EMS		No	$47
EMS Data Comparer	No	No	[DC]	EMS Data Comparer	2012-11-16	EMS		No	$47
NitroAccelerator	No	No	[?]	NitroAccelerator	2016-07-10	Nitrosphere		No	$1265
ERwin Data Modeler	Oracle,MySQL,PostgreSQL,Other	No	[DA]	ERwin Data Modeler	2016-06-03	ERwin		No	$810
Toad Data Point	Oracle,MySQL,PostgreSQL,Other	No	[?]	Toad Data Point	2016-06-16	Quest Software		No	?
SQL Power Architect	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[DA]	SQL Power Architect	2016-02-11	SQLPower		Yes	$995
DbWrench	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[DA]	DbWrench	2019-09-17	Nizana Systems		No	$99
Navicat Data Modeler	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[DA]	Navicat Data Modeler	2016-08-01	PremiumSoft		No	$199
DeZign for Databases	Oracle,MySQL,PostgreSQL,Other	No	[DA]	DeZign for Databases	2019-04-01	Datanamic		No	€29/mo
ERDesigner NG	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[DA]	ERDesigner NG	2013-04-10	Mirko Sertic		Open Source	No
Vertabelo	Oracle,MySQL,PostgreSQL,Other	Online	[DA]	Vertabelo	?	Vertabelo		No	$948
dbDiffo	Oracle,MySQL,PostgreSQL,Other	Online	[DA]	dbDiffo	?	Contenet Ltd		Yes	No
SQL DXP	Oracle,MySQL	No	[DC],[SC]	SQL DXP	2016-06-20	SQL Delta		No	$530
Aqua Data Studio	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	Aqua Data Studio	2016-07-06	AquaFold		No	$499
RazorSQL	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	RazorSQL	2019-09-26	Richardson Software		No	$100
SQL Pretty Printer	No	No	[?]	SQL Pretty Printer	2016-02-19	Gudu Software		No	$50
Database .NET	Oracle,MySQL,PostgreSQL,Other	No	[MS],[SC]	Database .NET	2018-08-20	fish’s dotNET		Non-commercial	$69
dbMigration .NET	Oracle,MySQL,PostgreSQL,Other	No	[DC],[SC]	dbMigration .NET	2018-08-20	fish’s dotNET		Non-commercial	$49
Is It SQL	No	No	[M]	Is It SQL	2017-04-06	Bill Graziano		Non-commercial	No
Database Experimentation Assistant	No	No	[T]	Database Experimentation Assistant	2020-03-20	Microsoft		Yes	No
Data Platform Studio	No	No	[MG]	Data Platform Studio	?	Red Gate Software		Yes	?
Flyway	Oracle,MySQL,PostgreSQL,Other	No	[MG]	Flyway	2018-01-30	boxfuse	Apache	Open Source	$950
Liquibase	Oracle,MySQL,PostgreSQL,Other	No	[MG]	Liquibase	2018-04-11	Liquibase	Apache	Open Source	No
My Batis	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MG]	My Batis	2018-03-20	My Batis	Apache	Open Source	No
SentryOne Plan Explorer	No	No	[?]	SentryOne Plan Explorer	2017-05-25	SentryOne		Yes	No
SQL Sentry	No	No	[M]	SQL Sentry	2016-12-07	SentryOne		No	?
DBmaestro TeamWork	Oracle	No	[?]	DBmaestro TeamWork	?	DBmaestro		No	?
xSQL Schema Compare	No	No	[SC]	xSQL Schema Compare	2017-03-01	xSQL Software	Shareware	Yes	$399
xSQL Data Compare	No	No	[DK]	xSQL Data Compare	2017-06-26	xSQL Software	Shareware	Yes	$399
xSQL Script Executor	MySQL,DB2,SQL Server CE	No	[?]	xSQL Script Executor	2015-02-25	xSQL Software	Freeware	Yes	$249
xSQL Builder	No	No	[?]	xSQL Builder	2017-03-15	xSQL Software	Shareware	No	$799
xSQL Documenter	Oracle,MySQL,SQLite,Other	No	[D]	xSQL Documenter	2017-01-04	xSQL Software	Shareware	No	$199
xSQL Profiler	No	No	[?]	xSQL Profiler	2017-06-28	xSQL Software	Shareware	Yes	$999
xSQL Schema Compare SDK	No	No	[SC]	xSQL Schema Compare SDK	2017-10-25	xSQL Software	Shareware	No	$1499
xSQL RSS Reporter	No	No	[D]	xSQL RSS Reporter	2014-11-25	xSQL Software	Shareware	No	$169
xSQL Database Searcher	No	No	[S]	xSQL Database Searcher	2017-05-09	xSQL Software	Freeware	Yes	No
Cloud-based DB Monitoring Platform	No	Mobile	[M]	Cloud-based DB Monitoring Platform	?	SQLTreeo		No	€180
SchemaCrawler	Oracle,MySQL,PostgreSQL,Other	Yes	[D],[SC]	SchemaCrawler	2017-02-27	Sualeh Fatehi		Open Source	No
SA MaaS Microsoft SQL Server	No	No	[M]	SA MaaS Microsoft SQL Server	?	SENTINELAGENT		No	?
SSIS Framework	No	No	[ETL]	SSIS Framework	2017-01-07	Andy Leonard		Yes	?
SSIS Catalog Browser	No	No	[ETL]	SSIS Catalog Browser	2019-04-23	Andy Leonard		Yes	No
BimlExpress Metadata Framework	No	No	[?]	BimlExpress Metadata Framework	2017-01-06	Andy Leonard		Yes	No
MS Kerberos Configuration Manager	No	No	[?]	MS Kerberos Configuration Manager	2017-01-31	Microsoft		Yes	No
Spotlight	No	No	[M]	Spotlight	?	Quest Software		Yes	?
DBConvert Studio	Oracle,MySQL,PostgreSQL,Other	No	[MG]	DBConvert Studio	2020-05-11	Slotix		No	$499
DbDefence	No	No	[?]	DbDefence	2017-03-01	ActiveCrypt Software		Yes	$698
SQL Server Migration Assistant for MySQL	MySQL	No	[MG]	SQL Server Migration Assistant for MySQL	2017-02-17	Microsoft		Yes	No
sqlcmd for Mac and Linux	No	Linux,Mac	[?]	sqlcmd for Mac and Linux	2017-01-26	Soheil Rashidi		Open Source	No
SQL Migrator	No	No	[MG]	SQL Migrator	?	Datamate Technology		?	?
MS FoxPro to MS SQL Migration and Sync	No	No	[MG]	MS FoxPro to MS SQL Migration and Sync	2019-04-25	Slotix		No	$149
MySQL to MS SQL Migration and Sync	No	No	[MG]	MySQL to MS SQL Migration and Sync	2018-10-03	Slotix		No	$149
Oracle to MS SQL Migration and Sync	No	No	[MG]	Oracle to MS SQL Migration and Sync	2020-02-12	Slotix		No	$149
PostgreSQL to MS SQL Migration and Sync	No	No	[MG]	PostgreSQL to MS SQL Migration and Sync	2019-10-24	Slotix		No	$149
MS Excel to MS SQL Migration	No	No	[MG]	MS Excel to MS SQL Migration	2018-02-23	Slotix		No	$149
SQLite to MS SQL Migration and Sync	No	No	[MG]	SQLite to MS SQL Migration and Sync	2016-08-18	Slotix		No	$149
IBM DB2 to MS SQL Migration and Sync	No	No	[MG]	IBM DB2 to MS SQL Migration and Sync	2019-07-09	Slotix		No	$149
MS Access to MS SQL Migration and Sync	No	No	[MG]	MS Access to MS SQL Migration and Sync	2020-01-15	Slotix		No	$149
Firebird to MS SQL Migration and Sync	No	No	[MG]	Firebird to MS SQL Migration and Sync	2016-08-18	Slotix		No	$149
SQLines SQL Converter	No	No	[MG]	SQLines SQL Converter	?	Dmtolpeko		Open Source	No
SQLite & SQL Server Compact Toolbox	No	No	[?]	SQLite & SQL Server Compact Toolbox	?	ErikEJ		Open Source	No
SqlPad	Postgres,MySQL,Crate,Vertica	No	[MS]	SqlPad	?	Rickbergfalk		Open Source	No
Html-query-plan	No	No	[?]	Html-query-plan	?	JustinPealing		Open Source	No
SqlQueryStress	No	No	[?]	SqlQueryStress	?	Adam Machanic		Open Source	No
SQL Server Migration Assistant for DB2	DB2	No	[MG]	SQL Server Migration Assistant for DB2	2017-02-17	Microsoft		Yes	No
SQL Server Migration Assistant for Oracle	Oracle	No	[MG]	SQL Server Migration Assistant for Oracle	2017-02-17	Microsoft		Yes	No
SQL Server Migration Assistant for Access	Access	No	[MG]	SQL Server Migration Assistant for Access	2017-02-17	Microsoft		Yes	No
SQL Server Migration Assistant for SAP ASE	SAP ASE	No	[MG]	SQL Server Migration Assistant for SAP ASE	2020-06-29	Microsoft		Yes	No
mssql for Visual Studio Code	No	Linux,Mac	[MS]	mssql for Visual Studio Code	2017-05-02	Microsoft		Open Source	No
mssql-scripter	No	Linux,Mac	[?]	mssql-scripter	?	Microsoft		Open Source	No
DBFS	No	Linux	[M]	DBFS	?	Microsoft		Open Source	No
comparator	Oracle,MySQL,PostgreSQL,Other	No	[DC]	comparator	2017-06-06	Pumpet	LGPL-3.0	Open Source	No
Navicat for SQL Server	No	Mac	[MS]	Navicat for SQL Server	2017-06-14	PremiumSoft		No	$699
Navicat Premium	Oracle,MySQL,PostgreSQL,Other	Mac	[MS]	Navicat Premium	2017-06-14	PremiumSoft		No	$1299
DbVisualizer	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS],[DA]	DbVisualizer	2017-08-22	DbVis Software AB.		Yes	$197
DbSchema	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[DA]	DbSchema	2017-06-19	Wise Coders Solutions		Yes	$127
DBGhost	No	No	[?]	DBGhost	2017-01-31	Innovartis Ltd		No	£430
SQLAutomate	Oracle,MySQL,Other	No	[?]	SQLAutomate	2017-06-19	OnLine ToolWorks		No	$99
BimlExpress	No	No	[?]	BimlExpress	?	Varigence		No	No
BI Developer Extensions	No	No	[?]	BI Developer Extensions	2019-04-29	Microsoft		Open Source	No
Azure Data Warehouse Migration Utility	No	No	[MG]	Azure Data Warehouse Migration Utility	?	Microsoft		?	?
Benchmark Factory	Oracle,MySQL,Other	No	[T]	Benchmark Factory	?	Quest Software		No	$4413
manduka	Oracle	Linux,Mac	[?]	manduka	2017-03-08	Virtusa Corporation		Yes	No
PowerBI Desktop	Oracle,MySQL,PostgreSQL,Other	No	[BI]	PowerBI Desktop	2017-07-11	Microsoft		Yes	?
Stellar Phoenix SQL Database Repair	No	No	[REC]	Stellar Phoenix SQL Database Repair	2017-07-05	Stellar Technology		No	$349
DataNumen SQL Recovery	No	No	[REC]	DataNumen SQL Recovery	2017-03-20	DataNumen		No	$500
Recovery Toolbox for SQL Server	No	No	[REC]	Recovery Toolbox for SQL Server	?	Recovery Toolbox	Shareware	No	$99
SQL MDF Viewer	No	No	[?]	SQL MDF Viewer	?	SysTools	Shareware	No	$129
SQL MDF Recovery Tool	No	No	[REC]	SQL MDF Recovery Tool	?	SysTools	Shareware	No	$129
SQL Passord Recovery	No	No	[REC]	SQL Passord Recovery	?	SysTools	Shareware	No	$69
SQL Decryptor	No	No	[SEC]	SQL Decryptor	?	SysTools	Shareware	No	$69
SQL Backup Database Recovery	No	No	[REC]	SQL Backup Database Recovery	?	SysTools	Shareware	No	$149
SQL Log File Viewer	No	No	[?]	SQL Log File Viewer	?	SysTools	Shareware	No	$999
DAX Studio	No	No	[?]	DAX Studio	?	Sqlbi	Freeware	Yes	No
SQL Cop	No	No	[?]	SQL Cop	?	LessThanDot	Freeware	Yes	No
Dataedo	Oracle,MySQL	No	[D]	Dataedo	2017-09-15	Logic Systems	Shareware	Yes	$239
Azure Database Migration Service	Oracle,MySQL, Other	Online	[MG]	Azure Database Migration Service	2017-12-01	Microsoft		Yes	No
FlowHeater	Oracle,MySQL,PostgreSQL,Other	No	[ETL]	FlowHeater	2017-10-02	FlowHeater GmbH	Shareware	No	$79
EDIS	No	No	[ETL]	EDIS	?	SQL ETL	Shareware	Yes	$599
SchemaSpy	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[D]	SchemaSpy	2018-08-05	Rafal Kasa	MIT	Open Source	No
Adminer	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	Adminer	2019-08-27	Jakub Vrána	Apache	Open Source	No
Full Convert	Oracle,MySQL,PostgreSQL,Other	No	[MG]	Full Convert	2018-08-20	Spectral Core	Shareware	Yes	$699
Replicator	Oracle,MySQL,PostgreSQL,Other	No	[DC]	Replicator	2018-08-20	Spectral Core	Shareware	Yes	$699
JackDB	Oracle,MySQL,PostgreSQL,Other	Online	[MS]	JackDB	?	JackDB		No	$48
SQL Workbench	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	SQL Workbench	2018-08-20	Thomas Kellerer		Yes	No
Valentina Studio	MySQL,PostgreSQL,Other	Linux,Mac	[MS]	Valentina Studio	2018-09-24	Paradigma Software		Yes	$200
SQL Plus Dot Net	No	No	[?]	SQL Plus Dot Net	?	SQL+.NET		No	?
SQLIndexManager	No	No	[IDX]	SQLIndexManager	2019-05-19	Sergey Syrovatchenko		Open Source	No
JAMS Enterprise Job Scheduling	No	No	[J]	JAMS Enterprise Job Scheduling	2019-08-20	HelpSystems		No	?
Stitch Data Loader	Oracle,MySQL,PostgreSQL,Other	Online	[ETL]	Stitch Data Loader	2019-09-20	Talend		No	?
Talend Data Integration	Oracle,MySQL,PostgreSQL,Other	Mac	[ETL]	Talend Data Integration	2019-06-20	Talend	Apache	Yes	?
Talend Data Preparation	Oracle,MySQL,PostgreSQL,Other	Mac	[ETL]	Talend Data Preparation	2018-06-05	Talend	Apache	Yes	?
Pentaho Data Integration	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[ETL]	Pentaho Data Integration	2019-06-20	Hitachi Vantara	Shareware	No	?
Studio3T	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MG]	Studio3T	2019-09-19	Studio 3T	Shareware	No	$150
SQLGrease	No	Online	[M]	SQLGrease	2019-09-20	SQLGrease	Shareware	No	$948
QuickDBD	Oracle,MySQL,PostgreSQL,Other	Online	[DA]	QuickDBD	?	Dovetail Technologies		Yes	$95
DB Designer	Oracle,MySQL,PostgreSQL,Other	Online	[DA]	DB Designer	?	DB Designer		Yes	$180
ESF Database Migration Toolkit	Oracle,MySQL,PostgreSQL,Other	No	[MG]	ESF Database Migration Toolkit	2019-10-23	DBSofts Inc	Shareware	No	$322
MS SQL Migration Toolkit	Oracle,MySQL,PostgreSQL,Other	No	[MG]	MS SQL Migration Toolkit	2019-04-22	Intelligent Converters	Shareware	No	$99
DatabasesSpy	Oracle,MySQL,PostgreSQL,Other	No	[MS]	DatabaseSpy	2019-10-09	Altova	Shareware	No	€109
DiffDog	Oracle,MySQL,PostgreSQL,Other	No	[DC],[SC]	DiffDog	2019-10-09	Altova	Shareware	No	€109
ERBuilder data modeler	Oracle,MySQL,PostgreSQL,Other	No	[DA]	ERBuilder data modeler	2019-11-14	Softbuilder		Yes	$99
SQLDatabaseStudio	No	No	[MS]	SQLDatabaseStudio	2017-05-10	Jan Pivarcek		Yes	$215
Enterprise Architect	Oracle,MySQL,PostgreSQL,Other	Online	[DA]	Enterprise Architect	2019-10-31	Sparx Systems Pty Ltd	Shareware	No	$225
MogwaiERDesignerNG	Oracle,MySQL,PostgreSQL	No	[DA]	MogwaiERDesignerNG	2019-08-22	Mirko Sertic	LGPL-3.0	Open Source	No
Xcase	Oracle,MySQL,PostgreSQL,Other	No	[DA]	Xcase	2018-06-19	Resolution Software	Shareware	No	$799
Oracle SQL Developer Data Modeler	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[DA]	[Oracle SQL Developer Data Modeler]	2019-08-01	Oracle	Shareware	Yes	No
Exportizer	Oracle,MySQL,PostgreSQL,Other	No	[MG]	Exportizer	2019-11-17	Vitaliy Levchenko	Shareware	No	$29
Reportizer	Oracle,MySQL,PostgreSQL,Other	No	[?]	Reportizer	2019-09-10	Vitaliy Levchenko	Shareware	No	$39
Database Tour	Oracle,MySQL,PostgreSQL,Other	No	[MS]	Database Tour	2019-11-20	Vitaliy Levchenko	Shareware	No	$49
Ispirer MnMATK	Oracle,MySQL,PostgreSQL,Other	No	[MG]	Ispirer MnMATK	?	Ispirer Systems	Shareware	No	?
SQL Database Recovery	No	No	[REC]	SQL Database Recovery	2019-09-10	KernelApps Private	Shareware	No	$399
SysTools SQL Log Analyzer	No	No	[M][REC]	SysTools SQL Log Analyzer	2019-01-01	SysTools	Shareware	No	$999
SysTools SQL Server Recovery Manager	No	No	[REC]	SysTools SQL Log Analyzer	2017-01-01	SysTools	Shareware	No	$1499
SysTools SQL Recovery	No	No	[REC]	SysTools SQL Recovery	2019-01-01	SysTools	Shareware	No	$249
SQL Backup Recovery	No	No	[REC]	SQL Backup Recovery	2018-01-01	SysTools	Shareware	No	$149
SysTools SQL Password Recovery	No	No	[REC]	SysTools SQL Password Recovery	2018-01-01	SysTools	Shareware	No	$69
SysTools SQL Decryptor	No	No	[SEC]	SysTools SQL Decryptor	2019-01-01	SysTools	Shareware	No	$69
SysTools SQL Server Database Migrator	No	No	[MG]	SysTools SQL Server Database Migrator	2018-01-01	SysTools	Shareware	No	$249
SQL Server to Azure Database Migrator	No	No	[MG]	SQL Server to Azure Database Migrator	2018-01-01	SysTools	Shareware	No	$169
Commvault Complete Backup & Recovery	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[B]	Commvault Complete Backup & Recovery	2019-12-31	Commvault	Shareware	No	?
Veeam Backup & Replication	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[B]	Veeam Backup & Replication	2019-12-31	Veeam	Shareware	No	$600
Veeam Explorer for Microsoft SQL Server	?	?	[B]	Veeam Explorer for Microsoft SQL Server	?	Veeam	Shareware	No	?
Database Modeling Excel	Oracle,MySQL,PostgreSQL,Other	No	[DA]	Database Modeling Excel	?	Yang Ning (Steven)	BSD-3	Open Source	No
DBAchecks	No	No	[?]	DBAchecks	?	sqlcollaborative	MIT	Open Source	No
DBComparer	No	No	[DC],[SC]	DBComparer	?	DBComparer		Yes	No
DbViewSharp	No	No	[MS]	DbViewSharp	2014-08-08	David Moore	MIT	Yes	No
DTSQL	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[?]	DTSQL	2017-08-18	DigerTech Inc	Shareware	Yes	$69
MSKerberos Configuration Manager	No	No	[DC],[SC]	MSKerberos Configuration Manager	2020-02-25	Microsoft		Yes	No
Partition Management	No	No	[?]	Partition Management	?	?		Open Source	No
PSDatabaseClone	No	No	[?]	PSDatabaseClone	2018-07-27	Sander Stad		Open Source	No
Pssdiag&Sqldiag Manager	No	No	[?]	Pssdiag&Sqldiag Manager	2020-05-04	Jack Li		Open Source	No
SQuirreL SQL Client	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[MS]	SQuirreL SQL Client	2020-04-30	Colin Bell		Yes	No
Data Synchronisation Studio	No	No	[?]	Data Synchronisation Studio	2020-05-26	Simego Ltd		No	$999
SQL Converter	No	No	[?]	SQL Converter	2015-12-15	Alaa Ben Fatma		Yes	No
SQLDBSearch	No	No	[S]	SQLDBSearch	?	Mohamed Bouarroudj		Yes	No
SQLDBSize	No	No	[?]	SQLDBSize	?	Mohamed Bouarroudj		Yes	No
SQLines Data	Oracle,MySQL,PostgreSQL,Other	Linux	[MG],[ETL]	SQLines Data	2019-05-29	SQLines		Open Source	No
SqlDbAid	No	No	[?]	SqlDbAid	2018-02-10	Miken		Yes	No
sqlectron	Oracle,MySQL,PostgreSQL,Other	Linux,Mac	[?]	sqlectron	2018-09-06	sqlectron		Open Source	No
SQL ExecStats	No	No	[?]	SQL ExecStats	?	Elemental Inc		Yes	No
SQL-FineBuild	No	No	[?]	SQL-FineBuild	2017-10-28	Edward Vassie		Open Source	No
SQL Health Monitor	No	No	[M]	SQL Health Monitor	?	ManageEngine		Yes	No
SQLPRep	No	No	[?]	SQLPRep	?	Consequential Solutions		Yes	No
SQL Server Monitoring	No	No	[M]	SQL Server Monitoring	?	Spiceworks		Yes	No
SQL Server Storage manager	No	No	[M]	SQL Server Storage manager	?	Lepide Software		Yes	No
SysKit Pulse	No	No	[M]	SysKit Pulse	?	SysKit Ltd		Yes	No
WhatsUp SQL Server Monitor	No	No	[M]	WhatsUp SQL Server Monitor	?	Ipswitch		Yes	No
POPSQL	Oracle,MySQL,PostgreSQL,Other	Online	[MS]	POPSQL	2020-08-01	PopSQL		Yes	$10
Azure Blob Studio 2011	No	No	[?]	Azure Blob Studio 2011	2010-12-25	Alessandro Del Sole		Yes	No
Azure Explorer	No	No	[?]	Azure Explorer	?	Monza Cloud		Yes	No
Azure SQL Agent	No	No	[?]	Azure SQL Agent	?	?	MIT	Open Source	No
Azure SQL Database DTU Calculator	No	No	[?]	Azure SQL Database DTU Calculator	?	Justin Henriksen	MIT	Open Source	No
Azure SQL Database Stress Test Tool	No	No	[T]	Azure SQL Database Stress Test Tool	?	Kiyoaki Tsurutani	MIT	Open Source	No
Azure SQL Dev Cloner	No	No	[?]	Azure SQL Dev Cloner	?	?	MIT	Open Source	No
Azure User Management Console	No	No	[?]	Azure User Management Console	?	?	Apache	Open Source	No
CloudMonix SQL Azure Database Management	No	No	[?]	CloudMonix SQL Azure Database Management	?	CloudMonix		No	$15
DB Ghost Change Manager Professional	No	No	[?]	DB Ghost Change Manager Professional	?	Innovartis Ltd		No	£430
MSSQL-Maestro	No	No	[MS]	MSSQL-Maestro	2017-06-29	SQL Maestro Group		No	$229
MSSQLMerge	No	No	[?]	MSSQLMerge	?	Konstantin Semenenkov		Yes	$50
SQL Backup and FTP	MySQL,PostgreSQL	Linux	[B]	SQL Backup and FTP	?	Pranas.NET		Yes	$129
SQL Bak	MySQL,PostgreSQL	Linux	[B]	SQL Bak	?	Pranas.NET		Yes	$9
SQL Bulk Tools	No	No	[?]	SQL Bulk Tools	?	Greg Taylor	MIT	Open Source	No
SQL Data Examiner	Oracle,MySQL,PostgreSQL	No	[?]	SQL Data Examiner	?	Intelligent Database Solutions		No	$400
SQL Examiner	Oracle,MySQL,PostgreSQL	No	[?]	SQL Examiner	?	Intelligent Database Solutions		No	$400
SQL Database Backup	No	No	[B]	SQL Database Backup	?	Richard Astbury	MIT	Open Source	No
SQL Database Copy	No	No	[MG]	SQL Database Copy	2017-07-25	ryanovic	MIT	Open Source	No
SQL Delta Duo for SQL Server	No	No	[?]	SQL Delta Duo for SQL Server	?	The Australian Software Company		No	$370
SQL Trace Replay	No	No	[?]	SQL Trace Replay	?	Mikhail Shilkov	MIT	Open Source	No
SQL Workload Profiler	No	No	[?]	[SQL Workload Profiler]	2014-10-01	Chris Bailiss		Yes	No
SQLDBdiff	No	Linux	[?]	[SQLDBdiff]	?	SQLDBtools		Yes	$60
SQL Backup Master	No	No	[B]	SQL Backup Master	?	Key Metric Software		Yes	$49
Handy Backup Server	Oracle,MySQL,PostgreSQL,Other	Linux	[B]	Handy Backup Server	2019-03-11	Novosoft		No	$39
EaseUS Todo Backup Server	No	No	[B]	EaseUS Todo Backup Server	?	EaseUS		No	$39
SqlBackupFree	No	No	[B]	SqlBackupFree	?	pranas.net		Yes	No
ERDPlus	No	No	[?]	ERDPlus	2020-05-24	ERDPlus		?	?
SentryOne Test	No	No	[T]	SentryOne Test	?	SQL Sentry		No	$828
Code Quality and Security for T-SQL	No	No	[?]	Code Quality and Security for T-SQL	?	SonarSource		No	€120
DBBALANCE	Oracle,MySQL,PostgreSQL,Other	No	[?]	DBBALANCE	?	DBBalance		No	?
Convert SQL to Excel	No	No	[?]	Convert SQL to Excel	2015-10-09	MSSQL.TOOLS		Yes	No
Search string in Schema	No	No	[S]	Search string in Schema	2015-10-09	MSSQL.TOOLS		Yes	No
Search string in SQL	No	No	[S]	Search string in SQL	2015-10-09	MSSQL.TOOLS		Yes	No
SQL Table Scripter	No	No	[?]	SQL Table Scripter	2015-10-09	MSSQL.TOOLS		Yes	No
SQLCLR Util	No	No	[?]	SQLCLR Util	2015-10-09	MSSQL.TOOLS		Yes	No
Image To SQL	No	No	[?]	Image To SQL	2015-10-09	MSSQL.TOOLS		Yes	No
dbdiagram	No	No	[?]	dbdiagram	?	holistics.io		Yes	$9/mo
Beekeeper Studio	MySQL,PostgreSQL,Other	Linux,Mac	[MS]	Beekeeper Studio	2020-11-21	Beekeeper Studio	MIT	Yes	No
Babelfish for Aurora PostgreSQL	No	Online	[?]	Babelfish for Aurora PostgreSQL	2020-12-01	Amazon	Apache	Open Source	No

SSMS

Download page: SSMS
Release date: 2020-10-27
Support Version: 2005-2019/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.

Azure Data Studio

Download page: Azure Data Studio
Release date: 2020-11-12
Support Version: 2008-2019/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

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: 2020-01-05
Support Version: 2008-2019/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

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: 2019-12-01
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: 2020-11-29
Support Version: 2005-2019
Author: Open Source
Free version: Yes
Price: No

Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases.
Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.

HeidiSQL

Download page: HeidiSQL
Release date: 2020-11-02
Support Version: 2005-2019
Author: Open Source
Free version: Yes
Price: No

HeidiSQL is a useful and reliable tool designed for web developers using the popular MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite.
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: 2020-04-23
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.

adutil Utility

Download page: adutil Utility
Release date: —
Support Version: 2017-2019
Author: Microsoft
Free version: Yes
Price: No

Configure Active Directory authentication with SQL Server on Linux.

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 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

SQL Data Profiler

Download page: SQL Data Profiler
Release date: ?
Support Version: 2008-2019
Author: Idera
Free version: No
Price: ?

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

dbForge Schema Compare

Download page: dbForge Schema Compare
Release date: 2019-10-10
Support Version: 2005-2019/Amazon/Azure
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 Data Compare
Release date: 2019-10-10
Support Version: 2005-2019/Amazon/Azure
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: 2019-10-10
Support Version: 2005-2019/Amazon/Azure
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: 2019-10-10
Support Version: 2005-2019/Amazon/Azure
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: 2019-10-10
Support Version: 2005-2019
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-09-19
Support Version: 2005-2019
Author: Devart
Free version: Yes
Price: No

Decrypt SQL Server Procedures, Functions, Triggers, and Views

dbForge Studio

Download page: dbForge Studio
Release date: 2019-10-10
Support Version: 2005-2019/Amazon/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: 2019-11-08
Support Version: 2005-2019/Amazon/Azure
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: 2020-04-23
Support Version: 2005-2019
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 SSIS Data Flow Components

Download page: dbForge SSIS Data Flow Components
Release date: 2020-03-31
Support Version: 2014-2019
Author: Devart
Free version: No
Price: $500

Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine.
They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.

dbForge DevOps Automation for SQL Server

Download page: dbForge DevOps Automation for SQL Server
Release date: 2020-04-13
Support Version: 2014-2019
Author: Devart
Free version: No
Price: $900

dbForge DevOps Automation for SQL Server is a cutting-edge solution that takes conventional database development and deployment to a whole new level.

Devart Excel Add-in for SQL Server

Download page: Devart Excel Add-in for SQL Server
Release date: 2019-12-11
Support Version: 2005-2019
Author: Devart
Free version: No
Price: $250

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

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: 2000-2017
Author: Bill Graziano
Free version: Yes
Price: No

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

Summarize SQL Server Query Performance
Enhance SQL Server Performance Tuning

ClearTraceXE

Download page: ClearTraceXE
Release date: 2019-09-04
Support Version: 2008-2017
Author: Bill Graziano
Free version: Yes
Price: No

ClearTrace for Extended Events imports extended event files from SQL Server 2017, 2016, 2014, 2012, 2008.

Summarize SQL Server Query Performance
Enhance SQL Server Performance Tuning

Security Explorer

Download page: Security Explorer
Release date: 2008-2017
Support Version: 2019-08-29
Author: Quest Software
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.

LiteSpeed for SQL Server

Download page: LiteSpeed for SQL Server
Release date: 2019-08-29
Support Version: 2008-2017
Author: Quest Software
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.

Toad for SQL Server

Download page: Toad for SQL Server
Release date: 2019-08-29
Support Version: 2008-2017
Author: Quest Software
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.

Quest Spotlight

Download page: Quest Spotlight
Release date: 2019-08-29
Support Version: 2008-2017
Author: Quest Software
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.

Quest Foglight

Download page: Quest Foglight
Release date: 2019-08-29
Support Version: 2008-2017
Author: Quest Software
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.

Quest Enterprise Reporter

Download page: Quest Enterprise Reporter
Release date: ?
Support Version: 2008-2017
Author: Quest Software
Free version: No
Price: $511

Quest 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: 2019-12-02
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: 2020-02-19
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: 2020-03-12
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: 2019-05-22
Support Version: 2008-2019
Author: ApexSQL
Free version: No
Price: No

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

ApexSQL CI/CD toolkit

Download page: ApexSQL CI/CD toolkit
Release date: 2020-05-21
Support Version: 2005-2017
Author: ApexSQL
Free version: Yes
Price: No

Build from source control
Include static data in builds
Generate synthetic test data
Automatically run SQL unit tests
Add a data change audit trail
Document and report on changes
Create a data sync script
Create a schema sync script
Plug into popular build servers
Enforce SQL coding standards
Work with all popular SC systems
Trigger manually or automatically

ApexSQL Compare

Download page: ApexSQL Compare
Release date: 2020-03-17
Support Version: 2005-2017
Author: ApexSQL
Free version: Yes
Price: No

Two-way SQL code compare
SSMS and Visual Studio integration
Char-by-char compare
Windows Explorer integration
Line-by-line compare
File and folder compare
Block-by-block compare
Database object compare
Syntax highlighting
Ignore script options
HTML results report
Automation and scheduling

ApexSQL Complete

Download page: ApexSQL Complete
Release date: 2020-05-28
Support Version: 2005-2017
Author: ApexSQL
Free version: Yes
Price: No

Automatically complete SQL statements
Review an object’s script and description
Improve productivity with snippets
Identify the structure of complex SQL queries
Keep track of all your tabs
Log every executed query
Easily navigate to SQL objects
Check queries in test mode
Color query tabs by environment
Search and export query results
Create CRUD procedures
Guard against queries that may damage data

ApexSQL Refactor

Download page: ApexSQL Refactor
Release date: 2020-06-09
Support Version: 2005-2019
Author: ApexSQL
Free version: Yes
Price: No

SQL formatter with over 160 options
Qualify objects and expand wildcards
Encapsulate SQL into procedures
Add surrogate keys
Replace one-to-many relationships
Change procedure parameters
Safely rename SQL objects
Locate & highlight unused variables
Format SQL objects
Obfuscate SQL

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: 2019-08-08
Support Version: 2008-2019/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…

DB Audit and Security 360

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 Point

Download page: Toad Data Point
Release date: 2016-06-16
Support Version: 2008-2017
Author: Quest Software
Free version: No
Price: ?

Query and Reporting Software Tool for Data Analysts

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: 2019-09-17
Support Version: 2008-2017
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: 2019-04-01
Support Version: 2008-2017
Author: Datanamic
Free version: No
Price: €29/month

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: 2019-09-26
Support Version: 2008-2019
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

Download page: Database Experimentation Assistant
Release date: 2020-03-20
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 executable.

xSQL Builder

Download page: xSQL Builder
Release date: 2017-03-15
Support Version: 2005/2008/2012/2014/2016, Azure
Author: xSQL Software
Free version: No
Price: $799

xSQL Builder is a SQL Server tool that allows for automating the deployment of SQL Server based solutions.
It generates executable packages that contain all the information and logic required to deploy the database to the clients’ environments regardless of whether it is a first time deployment or an upgrade from a previous version.

xSQL Documenter

Download page: xSQL Documenter
Release date: 2017-01-04
Support Version: 2000 to 2016
Author: xSQL Software
Free version: No
Price: $199

Comprehensive, uniform, and easily navigable database documentation in HTML and compiled CHM format.

xSQL Profiler

Download page: xSQL Profiler
Release date: 2017-06-28
Support Version: 2005/2008/2012/2014/2016, Azure
Author: xSQL Software
Free version: Yes
Price: $999

xSQL Profiler is a SQL tracing tool that provides for monitoring multiple SQL Servers from one central location.
Traces can be customized and scheduled to run on certain servers at certain times and all trace data is automatically collected into the central repository.

xSQL Schema Compare SDK

Download page: xSQL Schema Compare SDK
Release date: 2017-10-25
Support Version: 2000 to 2016
Author: xSQL Software
Free version: No
Price: $1499

Schema Compare SDK is a set of class libraries that allows you to perform schema comparison and synchronization for SQL Server databases in your .NET or ASP.NET applications.

xSQL RSS Reporter

Download page: xSQL RSS Reporter
Release date: 2014-11-25
Support Version: 2005/2008/2012/2014
Author: xSQL Software
Free version: No
Price: $169

RSS Reporter is a tool that generates standard Atom or RSS feeds for:

SQL Server job execution history
SQL Server job definition
The output of any T-SQL query
Database size and space usage

xSQL Database Searcher

Download page: xSQL Database Searcher
Release date: 2017-05-09
Support Version: 2005/2008/2012/2014/2016, Azure
Author: xSQL Software
Free version: Yes
Price: No

Database Searcher, previously known as «xSQL Object Search», is a free tool that allows you to search the schema of SQL Server databases.

Cloud-based DB Monitoring Platform

Download page: Cloud-based DB Monitoring Platform
Release date: ?
Support Version: ?
Author: SQLTreeo
Free version: No
Price: €180

Charts-on-charts technology, 24/7/365.
Alerting via Windows, Android and iOS.
Drill down into detailed history charts.
Send instant messages within your secured network.

SchemaCrawler

Download page: SchemaCrawler
Release date: 2017-02-27
Support Version: Oracle, PostgreSQL, MySQL, Other
Author: Sualeh Fatehi
Free version: Open Source
Price: No

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. The output serves for
database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.
SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java SE 8, Compact Profile 2 or better.

SA MaaS Microsoft SQL Server

Download page: SA MaaS Microsoft SQL Server
Release date: ?
Support Version: ?
Author: SENTINELAGENT
Free version: No
Price: ?

SA MaaS Microsoft SQL Server for on-premise and virtual Microsoft SQL servers gathers, stores and analyzes raw Microsoft recommended health & performance
diagnostics to help network admins and DBAs keep SQL servers running at peak performance and find the logs they need.

SSIS Framework

Download page: SSIS Framework
Release date: 2019-01-07
Support Version: ?
Author: Andy Leonard
Free version: Yes
Price: ?

Orchestrate SSIS Applications
Execute SSIS Applications with a single command
SSIS Catalog-integrated execution
Works with SSMS Catalog Reporting
Works with DILM Suite Catalog Reports
SSIS Catalog-integrated logging
SSIS Framework Reporting
Restart SSIS Applications at Failed Application Package
Application Package Parameter Support
Metadata-Driven Data Tap Support
Application Package Environment (References) Support
Application Package Property Override Support
Execute SSIS Applications / Packages on Different / Several Servers
Support for “Enterprise Data Integration Farm” SSIS Scale-Out
Enterprise Data Integration Reporting

BimlExpress Metadata Framework

Download page: BimlExpress Metadata Framework
Release date: 2017-01-06
Support Version: ?
Author: Andy Leonard
Free version: Yes
Price: No

The BimlExpress Metadata Framework version 2 uses Business Intelligence Markup Language (Biml) to:

Read metadata stored in a SQL Server database.
Build SSIS projects that create the target database, schemas, and tables.
Build an SSIS project that contains one SSIS package per table, plus a Controller package that executes each table-package.

MS Kerberos Configuration Manager

Download page: MS Kerberos Configuration Manager
Release date: 2017-01-31
Support Version: 2008/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No

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.

Spotlight

Download page: [Spotligh]
Release date: ?
Support Version: 2008/2012/2014/2016
Author: Quest Software
Free version: Yes
Price: ?

Can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure.

DBConvert Studio

Download page: DBConvert Studio
Release date: 2020-05-11
Support Version: 1.7.5
Author: Slotix
Free version: Yes
Price: $499

DBConvert Studio Software combines familiar and powerful features from the mature DBConvert and DBSync product series along with a redesigned and improved UI.
The following scenarios are available:

Simple master to slave migration
One-way Synchronization
Bidirectional synchronization
Data distribution (data flows from one source database to multiple destinations)

DbDefence

Download page: DbDefence
Release date: 2017-03-01
Support Version: 2005/2008/2012/2014/2016
Author: ActiveCrypt Software
Free version: Yes
Price: $698

DbDefence for Microsoft SQL Server implements server-side encryption and additional level of protection for databases.
With DbDefence you can hide table structure and data from prying eyes, even from DBA. Free version for databases less than 200 MB.

SQL Server Migration Assistant for MySQL

Download page: SQL Server Migration Assistant for MySQL
Release date: 2017-02-17
Support Version: 2005/2008/2012/2014/2016/Azure
Author: Microsoft
Free version: Yes
Price: No

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.

sqlcmd for Mac and Linux

Download page: sqlcmd for Mac and Linux
Release date: 2017-01-26
Support Version: 2005/2008/2012/2014/2016/Azure
Author: Soheil Rashidi
Free version: Open Source
Price: No

sqlcmd utility for Mac and Linux

SQL Migrator

Download page: SQL Migrator
Release date: ?
Support Version: 2005/2008/2012/2014/2016
Author: Datamate Technology
Free version: ?
Price: ?

Automatically upgrade objects within a SQL Server Instance from lower to higher versions or just refresh Objects between the same Versions

MS FoxPro to MS SQL Migration and Sync

Download page: MS FoxPro to MS SQL Migration and Sync
Release date: 2013-10-08
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Our software helps to migrate and synchronize MS Visual FoxPro databases .DBC or MS Visual FoxPro free tables .DBF to MS SQL Server.
It combines an easy-to-use interface with bunch of customization options, so your migration and replication of data can be fulfilled smoothly and rapidly.

Approximately 1 Million of records from FoxPro to MSSQL Server with «Bulk» option activated can be converted in 8 minutes.

MySQL to MS SQL Migration and Sync

Download page: MySQL to MS SQL Migration and Sync
Release date: 2013-10-08
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Our software automates conversion and synchronization of your databases from MySQL to MS SQL Server.
Transfer the entire database or select only needed dataset at customization stage in easy-to-use wizard style GUI.

Views migration between MS SQL and MySQL in both directions is available. You don’t need to know any differences in SQL syntax.
Every view will be converted from source db to target automatically.

Integrated Data Types Mapping feature helps to find and map similar data types between MySQL and MS SQL Server to make cross database conversion more flexible.

Oracle to MS SQL Migration and Sync

Download page: Oracle to MS SQL Migration and Sync
Release date: 2013-10-09
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Convert and synchronize databases from Oracle to MS SQL Server efficiently and fast.
Automatic views conversion from Oracle to MS SQL is easily performed with our software even with no any knowledge in differences between SQL dialects.
Besides, any server access restrictions may be overcome by creating dump files instead of direct connection to a target database.

Our tool easily handles huge databases and tables. A clear easy-to-use wizard interface helps you to move the whole database or only selected tables, indexes and foreign keys effortlessly.

PostgreSQL to MS SQL Migration and Sync

Download page: PostgreSQL to MS SQL Migration and Sync
Release date: 2013-10-08
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Convert and synchronize your databases from PostgreSQL to MS SQL server or to SQL Azure databases using our powerful software.
Wizard style interface will guide you through several steps performing migration and replication jobs easily and effectively.

In case you have any server restrictions, you can stuff MS SQL Dump file with all data out of the PostgreSQL database.

Our software will save you hours of learning SQL commands as any large PostgreSQL db can be converted and synchronized approximately in 5-10 min.

MS Excel to MS SQL Migration

Download page: MS Excel to MS SQL Migration
Release date: 2013-09-23
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Ability to create tables from MS Excel file with Integrated Data Selector
Microsoft Excel 2000 or higher 2003/2007/2010
Views conversion from MS SQL to MySQL and Oracle and back support
Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
Saving data into a MS SQL Dump for export to MS SQL database

SQLite to MS SQL Migration and Sync

Download page: SQLite to MS SQL Migration and Sync
Release date: 2014-05-08
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Conversion Tool for data migration and synchronization between SQLite and MS SQL databases in both directions.
One of the main benefit of this converter is the range of effective features that help you to transfer all database objects together or each individually,
skipping unnecessary tables, fields, indexes, foreign keys and constrains; change data types for various fields; rename each database element and many other options.

If you have any restrictions on direct access to MS SQL server our product provides you with the opportunity to create Dump files for further data uploading to MS SQL server.

IBM DB2 to MS SQL Migration and Sync

Download page: IBM DB2 to MS SQL Migration and Sync
Release date: 2013-09-09
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Our robust and cost-effective solution is a key for successful conversion and synchronization from IBM DB2 to MS SQL server.
Software is able to connect to source and destination databases directly without any other additional software installed.
Optionally target SQL Dump file may be generated if you haven’t a direct access to the MS SQL server.

MS Access to MS SQL Migration and Sync

Download page: IBM DB2 to MS SQL Migration and Sync
Release date: 2013-10-08
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

Powerful cross database software that will upsize and synchronize Access data into MS SQL database.

The program allows migrating MS Access queries to MSSQL views automatically with no need to know about the differences between SQL dialects.

Firebird to MS SQL Migration and Sync

Download page: Firebird to MS SQL Migration and Sync
Release date: 2013-09-11
Support Version: 2005/2008/2012/Azure
Author: Slotix
Free version: No
Price: $149

All Firebird / InterBase versions support
Saving data into a Firebird Dump
Views conversion from MS SQL to MySQL and Oracle and back support
Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL

SQLines SQL Converter

Download page: SQLines SQL Converter
Release date: ?
Support Version: ?
Author: Dmtolpeko
Free version: Open Source
Price: No

SQLines SQL Converter is an open source tool (Apache License 2.0) that allows you to convert database schema (DDL),
queries and DML statements, views, stored procedures, packages, functions and triggers between Microsoft SQL Server,
Oracle, MariaDB, MySQL, PostgreSQL, IBM DB2, Sybase, Informix, Teradata, Greenplum and Netezza.

SQLite & SQL Server Compact Toolbox

Download page: SQLite & SQL Server Compact Toolbox
Release date: ?
Support Version: ?
Author: ErikEJ
Free version: Open Source
Price: No

Visual Studio & SSMS 2016 extension, standalone app and command line tools, for managing all aspects of your SQL Server Compact/SQLite database files’ data and schema, including generation of code, database diagrams and database documentation.

SqlPad

Download page: SqlPad
Release date: ?
Support Version: ?
Author: Rickbergfalk
Free version: Open Source
Price: No

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, Crate, Vertica, and Presto. Written in Node.js.

Html-query-plan

Download page: Html-query-plan
Release date: ?
Support Version: ?
Author: JustinPealing
Free version: Open Source
Price: No

Html-query-plan is a JavaScript library for showing Microsoft SQL Server execution plans in HTML.

SqlQueryStress

Download page: SqlQueryStress
Release date: ?
Support Version: ?
Author: Adam Machanic
Free version: Open Source
Price: No

SQL query stress simulator created by Adam Machanic http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx

SQL Server Migration Assistant for DB2

Download page: SQL Server Migration Assistant for DB2
Release date: 2017-02-17
Support Version: 2005/2008/2012/2014/2016/Azure
Author: Microsoft
Free version: Yes
Price: No

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

SQL Server Migration Assistant for Oracle

Download page: SQL Server Migration Assistant for Oracle
Release date: 2017-02-17
Support Version: 2005/2008/2012/2014/2016/Azure
Author: Microsoft
Free version: Yes
Price: No

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

SQL Server Migration Assistant for Access

Download page: SQL Server Migration Assistant for Access
Release date: 2017-02-17
Support Version: 2005/2008/2012/2014/2016/Azure
Author: Microsoft
Free version: Yes
Price: No

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

SQL Server Migration Assistant for SAP ASE

Download page: SQL Server Migration Assistant for SAP ASE
Release date: 2020-06-29
Support Version: 2012/2014/2016/2019/Azure
Author: Microsoft
Free version: Yes
Price: No

Microsoft SQL Server Migration Assistant (SSMA) for SAP ASE is a tool to automate migration from SAP ASE database(s) to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance.
SSMA for SAP ASE is designed to support migration from SAP ASE version 11.9 and higher.

mssql for Visual Studio Code

Download page: mssql for Visual Studio Code
Release date: 2017-02-02
Support Version: ?
Author: Microsoft
Free version: Open Source
Price: No

mssql for Visual Studio Code an extension for developing Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere with a rich set of functionalities, including:

Connect to Microsoft SQL Server, Azure SQL Database and SQL Data Warehouses
Create and manage connection profiles and most recently used connections
Write T-SQL script with IntelliSense, Go to Definition, T-SQL snippets, syntax colorizations, T-SQL error validations and GO batch separator
Execute your scripts and view results in a simple to use grid
Save the result to json or csv file format and view in the editor
Customizable extension options including command shortcuts and more

Microsoft Assessment and Planning (MAP) Toolkit

Download page: Microsoft Assessment and Planning (MAP) Toolkit
Release date: 2020-05-26
Support Version: 2008-2019
Author: Microsoft
Free version: Yes
Price: No

The Microsoft Assessment and Planning Toolkit makes it easy to assess your current IT infrastructure for a variety of technology migration projects.
This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process.

Microsoft Assessment and Planning (MAP) Toolkit Wiki

mssql-scripter

Download page: mssql-scripter
Release date: ?
Support Version: ?
Author: Microsoft
Free version: Open Source
Price: No

mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS.
You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse.

DBFS

Download page: DBFS
Release date: ?
Support Version: ?
Author: Microsoft
Free version: Open Source
Price: No

DBFS uses FUSE to mount MS SQL Server DMVs as a virtual file system.
This gives you the ability to explore information about your database (Dynamic Management Views) using native bash commands.

Comparator

Download page: Comparator
Release date: 2017-06-06
Support Version: 2008-2017
Author: Pumpet
Free version: Open Source
Price: No

Simple application for compare data

Navicat for SQL Server

Download page: Navicat for SQL Server
Release date: 2017-06-14
Support Version: 2008-2017/Azure/AmazonRDS
Author: PremiumSoft
Free version: No
Price: $699

Navicat for SQL Server gives you a fully graphical approach to database management and development.
Quickly and easily create, edit, and delete all database objects, or execute SQL queries and scripts.
Connect to any local/remote SQL Server, and compatible with cloud databases like Amazon RDS and SQL Azure.

Navicat Premium

Download page: Navicat Premium
Release date: 2017-06-14
Support Version: 2008-2017/Azure/AmazonRDS
Author: PremiumSoft
Free version: No
Price: $1299

Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application.
Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud.
You can quickly and easily build, manage and maintain your databases.

DbVisualizer

Download page: DbVisualizer
Release date: 2017-08-22
Support Version: 2008-2017
Author: DbVis Software AB.
Free version: Yes
Price: $197

DbVisualizer is the universal database tool for developers, DBAs and analysts.
It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.

DbSchema

Download page: DbSchema
Release date: 2017-06-19
Support Version: 2008-2017/Azure/Amazon
Author: Wise Coders Solutions
Free version: No
Price: $127

DbSchema is a diagram-oriented database designer with integrated data and query tools
DbSchema is build for large diagrams and schemes. No database experience required — the tool is visual.
For deployment of the schema on multiple databases, management of multiple versions of the schema and migration scripts, work in a team on the design project.
This are possible as DbSchema is using its own image of the schema and saves it to XML file.

DBGhost

Download page: DBGhost
Release date: 2017-01-31
Support Version: 2008/2012/2014/2016
Author: Innovartis Ltd
Free version: No
Price: £430

The Change Manager gives you all the tools to implement the full DB Ghost Process enabling you to script out your databases into individual DROP/CREATE scripts, place those scripts under source control, modify them there and then build and deploy from those scripts.

SQLAutomate

Download page: SQLAutomate
Release date: 2017-06-19
Support Version: 2008/2012/2014/2016
Author: OnLine ToolWorks
Free version: No
Price: $99

SQLAutomate is an advanced database automation solution for SQL Server, Oracle, MySQL, DB2 or other advanced database management system.
It provides the ability to manage the necessary repetitive DBMS maintenance to help keep your databases efficient over time.
SQLAutomate makes it easy to manage a single database server instance, hundreds or even thousands of instances.

BimlExpress

Download page: BimlExpress
Release date: ?
Support Version: ?
Author: Varigence
Free version: No
Price: No

BimlExpress Visual Studio Add-in built specifically to work with SQL Server 2016.

Generate packages within Visual Studio and avoid slow, repetitive, «drag ‘n drop» workflow.
Write Biml code with syntax highlighting, making it easier to read and write Biml.
Updates are released more rapidly to work with the most current versions of SQL Server.

BI Developer Extensions

Download page: BI Developer Extensions
Release date: 2019-04-29
Support Version: ?
Author: Microsoft
Free version: Open Source
Price: No

A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI).

Azure Data Warehouse Migration Utility

Download page: Azure Data Warehouse Migration Utility
Release date: ?
Support Version: ?
Author: Microsoft
Free version: ?
Price: ?

The Data Warehouse Migration Utility is a tool designed to migrate schema and data from SQL Server and Azure SQL Database to Azure SQL Data Warehouse.
During schema migration, the tool automatically maps the corresponding schema from source to destination.
After the schema has been migrated, the tools provides the option to move data with automatically generated scripts.

Benchmark Factory

Download page: Benchmark Factory
Release date: ?
Support Version: 2008/2012/2014/2016/Azure
Author: Quest Software
Free version: No
Price: $4413

database workload generation
database code scalability testing
industry-standard benchmark testing
virtual user and transaction load simulation

manduka

Download page: manduka
Release date: 2017-03-08
Support Version: ?
Author: Virtusa Corporation
Free version: Yes
Price: No

The Free Static code analyzer

PL-SQL & T-SQL
Support for more than 50 violation rules
Light weight & fast
Easy to install & use
XML reports

PowerBI

Download page: PowerBI Desktop
Release date: 2017-07-11
Support Version: 2008-2017
Author: Microsoft
Free version: Yes
Price: ?

Power BI is a suite of business analytics tools to analyze data and share insights.
Monitor your business and get answers quickly with rich dashboards available on every device.

Stellar Phoenix SQL Database Repair

Download page: Stellar Phoenix SQL Database Repair
Release date: 2017-07-05
Support Version: 2008/2012/2014/2016
Author: Stellar Information Technology
Free version: No
Price: $349

Repairs corrupt MDF and NDF file of SQL Server database
Recovers tables, triggers, indexes, keys, rules and defaults
Perform deleted records recovery from MS SQL Server database
Saves Scan result of SQL Server database file automatically
Allows to search and recover specific database objects
Allows saving the repaired file in MS SQL, HTML, XLS & CSV formats
Supports MS SQL Server 2016, 2014, 2012, 2008 and all lower versions

DataNumen SQL Recovery

Download page: DataNumen SQL Recovery
Release date: 2017-03-20
Support Version: 2008/2012/2014/2016
Author: DataNumen
Free version: No
Price: $500

Recovery rate is the most important criterion of a SQL recovery product.
Based on our comprehensive tests, DataNumen SQL Recovery has the best recovery rate, much more better than any other competitors in the market!

Recovery Toolbox for SQL Server

Download page: Recovery Toolbox for SQL Server
Release date: ?
Support Version: 7/2000/2005/2008/2008 R2/2012/2014
Author: Recovery Toolbox
Free version: No
Price: $99

Recovery Toolbox for SQL Server is a comprehensive recovery solution for damaged MS SQL Server database files.

SQL MDF Viewer

Download page: SQL MDF Viewer
Release date: ?
Support Version: 2000-2016
Author: SysTools
Free version: No
Price: $129

Read and open MDF database file along with its related elements

Preview all tables, indexes, triggers of the MDF file
Auto detects the SQL Server version
Save scanned MDF file data in .str file format

SQL MDF Recovery Tool

Download page: SQL MDF Recovery Tool
Release date: ?
Support Version: 2014 and all lower versions
Author: SysTools
Free version: No
Price: $129

Repair corrupt MDF file data with ease and accuracy

Recover tables, function, stored procedure, triggers, etc
Performs Quick and Advance Scan to repair MDF & NDF file
Export selective file with Schema or Schema and Data

SQL Passord Recovery

Download page: SQL Passord Recovery
Release date: ?
Support Version: 2008 & all below versions
Author: SysTools
Free version: No
Price: $69

Tool to Reset SQL Server Database Password

Recover passwords of multiple SQL Server databases
Reset both unknown and empty SQL DB passwords
Remove and reset passwords of all SQL Server users

SQL Decryptor

Download page: SQL Decryptor
Release date: ?
Support Version: 2014 & all below versions
Author: SysTools
Free version: No
Price: $69

User Friendly Solution to Remove Encryption From SQL Database

Remove encryption from batch SQL objects
Display complete preview of MS SQL database
Export data to SQL Server and compatible script

SQL Backup Database Recovery

Download page: SQL Backup Database Recovery
Release date: ?
Support Version: ?
Author: SysTools
Free version: No
Price: $149

Recover Corrupt SQL Backup File with .bak Repair Tool

Repair corrupt SQL Server backup file with confidence
Fix all SQL backup error messages quickly
Advanced and affordable solution to recover SQL BAK file
Simple and nifty graphical user interface

SQL Log File Viewer

Download page: SQL Log File Viewer
Release date: ?
Support Version: 2016/2014/2012/2008 and all below versions
Author: SysTools
Free version: No
Price: $999

Read SQL Server database transaction log file with SQL log analysis tool

Analyze and view SQL Server LDF file transactions
View all the transactions, i.e. insert, update, delete etc.
Export log file into SQL Server, SQL script or as CSV file

DAX Studio

Download page: DAX Studio
Release date: ?
Support Version: ?
Author: Sqlbi
Free version: Yes
Price: No

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.

SQL Cop

Download page: SQL Cop
Release date: ?
Support Version: ?
Author: LessThanDot
Free version: Yes
Price: No

SQL Cop is a static code analysis tool to automatically detect issues with your database.

Dataedo

Download page: Dataedo
Release date: 2017-09-15
Support Version: 2008-2017
Author: Sqlbi
Free version: Yes
Price: $239

Document SQL Server, Oracle and MySQL databases

Azure Database Migration Service

Download page: Dataedo
Release date: 2017-12-01
Support Version: 2008-2017
Author: Microsoft
Free version: Yes
Price: No

Reduce the complexity of your cloud migration by using a single comprehensive service instead of multiple tools.
The public preview release of Azure Database Migration Service is designed as a seamless, end-to-end solution for moving on-premises SQL Server databases to the cloud.

FlowHeater

Download page: flowheater
Release date: 2017-10-02
Support Version: 2008-2017
Author: FlowHeater GmbH
Free version: No
Price: $79

The FlowHeater functionality closely resembles the concept of a continuous-flow water heater. A wide variety of data sources can be interconnected with FlowHeater and by making use of exchangeable adapters, there is no restriction to the data flow.

EDIS

Download page: EDIS
Release date: ?
Support Version: 2008-2017
Author: SQL ETL
Free version: Yes
Price: $599

EDIS is an Extract-Transform-Load (ETL) application for Microsoft SQL Server.
No 3rd Party Language, No Packages, Just SQL.

SchemaSpy

Download page: SchemaSpy
Release date: 2018-08-05
Support Version: 2008-2017
Author: Rafal Kasa
Free version: Open Source
Price: No

Document your database simply and easily.
SchemaSpy is a Java-based tool (requires Java 8 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.
It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.
It’s also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
It is free software that is distributed under the terms of the MIT License.

Adminer

Download page: Adminer
Release date: 2019-08-27
Support Version: 2005-2017
Author: Adminer
Free version: Open Source
Price: No

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server.
Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.

Full Convert Enterprise

Download page: Full Convert
Release date: 2018-08-20
Support Version: 2005-2017
Author: Spectral Core
Free version: No
Price: $699

Full Convert allows easy copying of tables and data between 40 or so supported databases. It will create all the tables, copy all of your data, then create indexes and foreign keys.
It has powerful mapping and customization features and uses optimal copying mode for each table separately to achieve the best possible throughput.

Replicator Pro

Download page: Replicator
Release date: 2018-08-20
Support Version: 2005-2017
Author: Spectral Core
Free version: No
Price: $799

Replicator allows table data comparison and sync — even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, Excel documents, Paradox…).
Replicator has a built-in scheduler for easy periodic change replication.

JackDB

Download page: JackDB
Release date: ?
Support Version: 2008-2017/Azure
Author: JackDB
Free version: No
Price: $49

JackDB is a modern database client. Collaborate with data securely across your entire organization.

SQL Workbench

Download page: SQL Workbench
Release date: 2018-08-20
Support Version: 2008-2017
Author: Thomas Kellerer
Free version: Yes
Price: No

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment.
Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features.
Graphical query building or more advanced DBA tasks are not the focus and are not planned.

Valentina Studio

Download page: Valentina Studio
Release date: 2018-09-24
Support Version: 2008-2017
Author: Paradigma Software
Free version: Yes
Price: $200

Valentina Studio is your universal database management tool for working with MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB databases.
Valentina Studio lets you connect with all major databases, run queries and generate diagrams to better understand your mission critical business data — and that is the free version of Valentina Studio.

SQL Plus Dot Net

Download page: SQL Plus Dot Net
Release date: ?
Support Version: ?
Author: SQL+.NET
Free version: No
Price: ?

SQL+ is a tool that generates a class library from stored procedures by utilizing a tagging system in the form of comments.
Does all the ADO stuff like setting up parameters and converting result sets into objects.

SQLIndexManager

Download page: SQLIndexManager
Release date: 2019-05-19
Support Version: 2008-2019/Azure
Author: Sergey Syrovatchenko
Free version: Yes
Price: No

Analyze and fix index fragmentation for SQL Server / Azure

JAMS Enterprise Job Scheduling

Download page: JAMS Enterprise Job Scheduling
Release date: 2019-08-20
Support Version: 2008-2019
Author: HelpSystems
Free version: No
Price: ?

Take control of SQL Agent sprawl. Automate smarter with JAMS and regain control over your critical SQL Server batch processes.

Monitor SQL Server Job Progress
Customize SQL Job Schedules (Dates, times, triggers, dependencies and more)
Send Alerts

Stitch Data Loader

Download page: Stitch Data Loader
Release date: 2019-09-20
Support Version: 2008-2019/Azure
Author: Talend
Free version: No
Price: ?

Stitch makes it simple to load data from dozens of cloud sources into cloud data warehouses and data lakes in minutes.

Talend Data Integration

Download page: Talend Data Integration
Release date: 2019-06-20
Support Version: 2008-2019/Azure
Author: Talend
Free version: Yes
Price: ?

Talend Data Integration an enterprise data integration software to connect, access, and transform any data across the cloud or on-premises.

Talend Data Preparation

Download page: Talend Data Preparation
Release date: 2018-06-05
Support Version: 2008-2019/Azure
Author: Talend
Free version: Yes
Price: ?

Talend Data Preparation empowers anyone to quickly prepare data for trusted insights throughout the organization.

Pentaho Data Integration

Download page: Talend Data Integration
Release date: 2019-06-20
Support Version: 2008-2019/Azure
Author: Hitachi Vantara
Free version: No
Price: ?

This end-to-end platform meets all data integration challenges. Its intuitive drag-and-drop graphical interface simplifies the creation of self-documented data pipelines.
For data transformation, easily use push-down processing to scale out compute platforms, such as Apache Hadoop.

Studio3T

Download page: Studio3T
Release date: 2019-09-19
Support Version: 2008-2019
Author: Studio 3T
Free version: No
Price: $149

Speed up tasks like query building, data exploration, import/export, code generation, and more – with or without the knowledge of the MongoDB query language.
MongoDB from and to migrations with many RDBMS.

SQLGrease

Download page: SQLGrease
Release date: 2019-09-20
Support Version: 2008-2019/Azure/RDS
Author: SQLGrease
Free version: No
Price: $948

SQLGrease was built from the ground up specifically for monitoring SQL Server.
Using the newest monitoring features in SQL Server, SQLGrease collects detailed information with extremely low overhead.

QuickDBD

Download page: QuickDBD
Release date: ?
Support Version: ?
Author: Dovetail Technologies Ltd
Free version: Yes
Price: $95

Draw databases diagrams by typing online and collaborating.

DB Designer

Download page: DB Designer
Release date: ?
Support Version: ?
Author: DB Designer
Free version: Yes
Price: $180

All The Features You Need For Database Design – Simple But Powerful.

ESF Database Migration Toolkit

Download page: ESF Database Migration Toolkit
Release date: 2019-10-23
Support Version: 2008-2017
Author: DBSofts Inc
Free version: No
Price: $322

ESF Database Migration Toolkit is the most popular toolkit to help people migrate data across various database formats, supporting Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, IBM DB2, IBM Informix, InterSystems Caché, Teradata, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus, dBase, CSV/Text and so on.

MS SQL Migration Toolkit

Download page: MS SQL Migration Toolkit
Release date: 2019-04-22
Support Version: 2008-2017
Author: Intelligent Converters
Free version: No
Price: $99

MS SQL Migration Toolkit is a software pack to convert any data source to Microsoft SQL Server or Azure SQL and vice versa. The product has high performance because it does not use ODBC or any other middleware software.
Command line support allows to script, automate and schedule the conversion.

DatabaseSpy

Download page: DatabaseSpy
Release date: 2019-10-09
Support Version: 2008-2019
Author: Altova
Free version: No
Price: €109

Altova DatabaseSpy is the unique multi-database query and design tool that even generates elegant charts directly from query results.

DiffDog

Download page: DatabaseSpy
Release date: 2019-10-09
Support Version: 2008-2019
Author: Altova
Free version: No
Price: €109

Altova DiffDog® 2020 is a powerful diff/merge tool for files, folders, and databases.
This easy-to-use synchronization tool quickly compares and merges text or source code files, Microsoft Word documents, directories, CSV files, databases, and XML Schemas via its intuitive visual interface.
It indicates differences, intelligently merges content, and creates XSLT to convert XML data.

ERBuilder data modeler

Download page: ERBuilder data modeler
Release date: 2019-11-14
Support Version: 2008-2019/AzureSQL
Author: Softbuilder
Free version: Yes
Price: $99

ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases.
It also allows developers to easily deploy databases by offering a sophisticated visual data modeling environment.

SQLDatabaseStudio

Download page: SQLDatabaseStudio
Release date: 2017-05-10
Support Version: 2008-2017
Author: Jan Pivarcek
Free version: Yes
Price: $215

Attention to the details is what makes SQL Database Studio (SDS) perfect. SDS automates repetitive tasks such as filtering, sorting, searching and much more. You can stay focused on problem you are solving and be more productive.
Start Up in No Time
Smart and Modern IDE

Enterprise Architect

Download page: Enterprise Architect
Release date: 2019-10-31
Support Version: 2008-2017
Author: Sparx Systems Pty Ltd
Free version: No
Price: $225

Integrated modeling platform.
Enterprise Architect, t’s built-in Data Modeling tools and profiles extend UML to provide an intuitive mapping from the database concepts of tables and relationships onto the UML concepts of classes and associations. These extensions also enable you to model database keys, triggers, constraints, RI and other relational database features.
Enterprise Architect supports modeling of database schema and automatic generation of DDL scripts for eleven DBMS targets out-of-the-box: DB2, Firebird, MS Access, MySQL, MS SQL Server, Oracle, PostgreSQL

MogwaiERDesignerNG

Download page: MogwaiERDesignerNG
Release date: 2019-08-22
Support Version: 2008-2017
Author: Mirko Sertic
Free version: Yes
Price: No

Java 2D & 3D visual entity relationship design & modeling (ERD,SQL) for Oracle, MSSQL, Postgres and MySQL.

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.

Xcase

Download page: Xcase
Release date: 2018-06-19
Support Version: 2008-2017
Author: Resolution Software Ltd
Free version: No
Price: $799

Xcase is a complete database design tool engineered to help you accomplish all your database-related tasks – from database design to modeling to daily modifications – with greater speed, higher quality, and better adherence to best practices. Its powerful automation and graphics features quickly and accurately complete tasks throughout the entire life cycle of your database, freeing you to focus on database strategy.

Oracle SQL Developer Data Modeler

Download page: [Oracle SQL Developer Data Modeler]
Release date: 2019-08-01
Support Version: 2008-2017
Author: Oracle
Free version: Yes
Price: No

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.
Using Oracle SQL Developer Data Modeler users can create, browse and edit, logical, relational, physical, multi-dimensional, and data type models.
The Data Modeler provides forward and reverse engineering capabilities and supports collaborative development through integrated source code control.
The Data Modeler can be used in both traditional and in Cloud environments.

Exportizer

Download page: Exportizer
Release date: 2019-11-17
Support Version: 2008-2017
Author: Vitaliy Levchenko
Free version: No
Price: $29

You can export dbf to txt, csv to dbf, Paradox to xls, and make several other data conversions.
Beside that, in Exportizer Pro or Exportizer Enterprise, it is possible to export DB2 to xlsx, SQLite to dBase, Access to HTML, Excel to Access, migrate Interbase to SQL Server, FDB to Excel, Oracle to PostgreSQL, and much more.

Reportizer

Download page: Reportizer
Release date: 2019-09-10
Support Version: 2008-2017
Author: Vitaliy Levchenko
Free version: No
Price: $39

Reportizer is a software tool to create database and file reports.
With Reportizer, you can create professional reports in a couple of minutes!

Database Tour

Download page: Database Tour
Release date: 2019-11-20
Support Version: 2008-2017
Author: Vitaliy Levchenko
Free version: No
Price: $49

Database Tour is a multi-functional database tool for Windows.
In addition, Database Tour Pro provides powerful command line and reporting functionality.

Ispirer MnMATK

Download page: Ispirer MnMATK
Release date: 2019-10-23
Support Version: 2008-2017
Author: Ispirer Systems
Free version: No
Price: ?

Ispirer Migration and Modernization Assessment Toolkit (Ispirer MnMATK) is designed to collect statistical information about your database or application, as well as better realize the size of a migration project.
The software provides a full report on the number of tables, the amount of data, the number of database objects, and the number of lines of code in each type of database object.
The toolkit consists of Migration Assessment Wizard designed to collect and evaluate information about the database, and Migration Assessment Studio designed to collect and evaluate information about the application.

SQL Database Recovery

Download page: SQL Database Recovery
Release date: 2019-09-10
Support Version: 2008-2019
Author: KernelApps Private
Free version: No
Price: $399

Repair corrupt and damaged MS SQL database files.

SysTools SQL Log Analyzer

Download page: SysTools SQL Log Analyzer
Release date: 2019-01-01
Support Version: 2000-2019
Author: SysTools
Free version: No
Price: $999

SysTools SQL Log Analyzer — To Read & Analyze SQL Server Log File (.ldf) Transactions

Complete analyses of SQL transaction Log (.ldf) file to identify critical changes in record
Open, Read & Analyze all Microsoft SQL transactions: Insert, Update & Delete
SQL LDF File Recovery to restore the modified database back into SQL Server
Forensic Investigator can track who modified SQL table records with details provide by Log Analyzer
Quick Scan to deeply examine log file & provide full visibility to database records
Open & Analyze all operation of a transaction(LDF) file Without MS SQL Server application
SQL Log Analyzer works on both Online & Offline SQL Database Environment
Support to fetch & view records from Live SQL database environment
Support For Advance SQL Data Type : Datetime2, datetimeoffset, sql_variant, hierarchyid, geometry & geography data types
Dynamic Filters to export only Selective transaction records after complete analyses
Display LDF information in SQL Scripts, CSV file or directly export to any SQL Server database
Auto-locate MDF to read database schema of scanned Log File while opting Offline DB Option
Provide support to Unicode (Collation) property after exporting database

SysTools SQL Server Recovery Manager

Download page: SysTools SQL Server Recovery Manager
Release date: 2017-01-01
Support Version: 2000-2016
Author: SysTools
Free version: No
Price: $1499

Recover & Export SQL Database: Primary (MDF) and Secondary (NDF)
Analyze SQL Server LOG database transactions
Scan, recover & Export database from corrupt SQL Server Backup File
Recover & Reset SQL User Password from master.mdf file
Decrypt Encryption of SQL Server Scripts & Database from Live Environ
Recover Data from all Database Files : master.mdf/.ndf/.bak/.ldf etc.

SysTools SQL Recovery

Download page: SysTools SQL Recovery
Release date: 2019-01-01
Support Version: 2000-2019
Author: SysTools
Free version: No
Price: $249

Quick & Advanced Scan To Repair SQL Database : Both Primary & Secondary
SQL Recovery Software will Recover Deleted SQL Server Database Table’s Data
Scan & Recover Multiple NDF Files (Secondary Database)
Scan & Recover Triggers, Rules, Functions, Tables, Stored Procedures
Export File into SQL Server Database or as SQL Server Compatible Scripts Using SQL Database Repair Tool
Auto Fetches SQL Server Name while Exporting to SQL Server Database
Desired Items Selection to Save File with Schema or Schema & Data Both
Option to preview deleted records in red colour
Support ASCII and Unicode XML datatype
Recover data from Wallet Ransomware affected .mdf files.

SysTools SQL Recovery

Download page: SysTools SQL Recovery
Release date: 2018-01-01
Support Version: 2000-2017
Author: SysTools
Free version: No
Price: $149

Recover & Preview Tables, Views, Procedures, Triggers, Functions, Columns
Supports to repair corrupt SQL Backup file without any modification
Recover MDF & NDF files Saved within SQL Backup File
Option of Auto-Detect to detect the version of SQL .bak file
2 Export Options: SQL Server Database or SQL Server Compatible Script
Supports XML Data type in MS SQL server 2017, 2016, 2014, 2012, 2008
No File Size Limitation: Tested with 1.4 TB of SQL .bak file

SysTools SQL Password Recovery

Download page: SysTools SQL Password Recovery
Release date: 2018-01-01
Support Version: 2000-2017
Author: SysTools
Free version: No
Price: $149

Reset both Individual User & SA passwords from SQL master.mdf file
Installation of MS SQL Server is not mandatory to reset SA password
SQL Server services should be stopped while loading master.mdf file
Recover & Reset SQL password of any length or type without any fail
Provide facility to set new password for User Login within a software
Capable to recover Multilingual Password of MDF Files successfully
SQL Server SA Password Recovery can install on Windows OS

SysTools SQL Decryptor

Download page: SysTools SQL Decryptor
Release date: 2019-01-01
Support Version: 2000-2019
Author: SysTools
Free version: No
Price: $69

Remove encryption from complete MS SQL database
Supports Dual Login Mode : Windows & SQL Server Authentication
SQL Server credentials required to decrypt SQL database file
Option Export SQL database: SQL Server & Compatible Scripts
Able to Decrypt SQL Stored Procedure, Triggers, Functions, Views.
SQL Server should be installed on machine for decryption
Dedicated Admin Connection (DAC) is required to run the utility

SysTools SQL Server Database Migrator

Download page: SysTools SQL Server Database Migrator
Release date: 2018-01-01
Support Version: 2000-2017
Author: SysTools
Free version: No
Price: $249

Migrate Corrupted SQL Server Database from SQL Server 2008 to 2012, 2014, 2016, 2017
Move Tables, Functions, SPs etc from One database to Another In all SQL Server
Migrate Database Objects (Tables, Functions, Stored Procedures etc) from One Server to Another
Creates .sql Script File of All Database Objects of an MDF File One by One
Migrate SQL Database Objects from One Server to Another With Only Schema
Copy SQL Server Database from One Server to Another With Schema & Data
Move & Export SQL Server Database on an Existing Database or as a New Database.

SQL Server to Azure Database Migrator

Download page: SQL Server to Azure Database Migrator
Release date: 2018-01-01
Support Version: 2000-2017
Author: SysTools
Free version: No
Price: $169

Able to Move all SQL database objects : Tables, Triggers, Stored Procedures etc.
Migrate corrupted / inaccessible SQL database to Azure Database
Preview all database components before migrating SQL Database to Azure
Auto-detect SQL Server version while migrating data to Azure SQL database
Allows to migrate selected data items ‘With Schema’ or ‘With Schema & Data’ option
Provides facility to Migrate NDF file data to Azure SQL database
Allows to Migrate deleted records to SQL Azure cloud database

Commvault Complete Backup & Recovery

Download page: Commvault Complete Backup & Recovery
Release date: 2019-12-31
Support Version: 2008-2019
Author: Commvault
Free version: No
Price: ?

Complete coverage starts and ends here. Commvault Complete Backup & Recovery is a single, powerful solution for data protection – wherever your data lives.
Supported Technologies

Veeam Backup & Recovery

Download page: Veeam Backup & Replication
Release date: 2019-12-31
Support Version: 2008-2019
Author: Veeam
Free version: No
Price: $600

Veeam Backup & Replication™ delivers Intelligent Data Management for ALL your virtual, physical and cloud-based workloads.
Through a single management console, you can manage fast, flexible and reliable backup, recovery and replication of all your applications and data to eliminate legacy backup solutions forever.

Database Modeling Excel

Download page: Database Modeling Excel
Release date: ?
Support Version: ?
Author: Yang Ning (Steven)
Free version: Yes
Prise: No

The database modeling utility is a Microsoft Office Excel workbook which can help you to design databases.
It supports DB2, MariaDB, MySQL, Oracle, PostgreSQL, SQLite and SQL Server.
In the workbook, you can define database, generate DDL scripts, and import database definition from existing databases.

DBAchecks

Download page: DBAchecks
Release date: ?
Support Version: ?
Author: sqlcollaborative
Free version: Yes
Prise: No

This open source module allows us to crowd-source our checklists using Pester tests. Such checks include:

Backups are being performed
Identity columns are not about to max out
Servers have access to backup paths
Database integrity checks are being performed and corruption does not exist
Disk space is not about to run out
All enabled jobs have succeeded

DBComparer

Download page: DBComparer
Release date: ?
Support Version: 2005-2008
Author: DBComparer
Free version: Yes
Prise: No

Automate compare database
Compare all database objects or selected ones only
Compare database by all or selected properties of objects only
A wide variety of options for comparison
Compare databases using all or selected object properties
Advanced visual build tree interface for an intuitive visual representation of any differences
Built-in text differences control with SQL syntax highlighting

DbViewSharp

Download page: DbViewSharp
Release date: 2014-08-08
Support Version: 2005 – 2014
Author: David Moore
Free version: Yes
Prise: No

DbViewSharp is a very useful application that is designed to provide you with a means of exploring and managing SQL databases.

DTSQL

Download page: DTSQL
Release date: 2017-08-18
Support Version: ?
Author: DigerTech Inc
Free version: Yes
Prise: $69

DtSQL is an 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.

MSKerberos Configuration Manager

Download page: MSKerberos Configuration Manager
Release date: 2020-02-25
Support Version: 2008 – 2019
Author: Microsoft
Free version: Yes
Prise: No

Partition Management

Download page: Partition Management
Release date: ?
Support Version: ?
Author: ?
Free version: Yes
Prise: No

Remove all the data from one partition by switching it out to a staging table. It creates the required staging table.
Create a staging table for loading data into a partition. The staging table can be created with or without indexes — if created without indexes this utility provides a separate command to create appropriate indexes on the staging table, before SWITCHing it into the partitioned table.

Powershell Scripts

Download page: Powershell Scripts
Release date: ?
Support Version: 2008-2017
Author: Idera
Free version: Yes
Prise: No

147 sample PowerShell scripts to manage SQL Server and Azure SQL Database
Scripts to initialize PowerShell modules
Scripts for Database Engine, and for Analysis, Integration and Reporting Services
Support for SQL Server 2016 and 2017, and Windows Server 2016
15 New scripts for Azure SQL Database

PSDatabaseClone

Download page: PSDatabaseClone
Release date: ?
Support Version: ?
Author: Sander Stad
Free version: Yes
Prise: No

PSDatabaseClone is a PowerShell module dedicated to the provisioning of databases using virtual disk technology.

Pssdiag&Sqldiag Manager

Download page: Pssdiag&Sqldiag Manager
Release date: 2020-05-04
Support Version: ?
Author: Jack Li
Free version: Yes
Prise: No

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. This is the same tool Microsoft SQL Server support engineers use to for data collection to troubleshoot customer’s performance problems.

SQuirreL SQL Client

Download page: SQuirreL SQL Client
Release date: 2020-04-30
Support Version: ?
Author: Colin Bell, Gerd Wagner
Free version: Yes
Prise: No

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.

Data Synchronisation Studio

Download page: Data Synchronisation Studio
Release date: 2020-05-26
Support Version: SQL Server 2014 or higher
Author: Simego Ltd
Free version: No
Prise: $999

The complete package for data integration and automation for SQL.

Import + Export
Data Reconciliation
Data Preview
Transformation
Lookups
Connection Library
Schedule

SQL Converter

Download page: SQL Converter
Release date: 2015-12-15
Support Version: ?
Author: Alaa Ben Fatma
Free version: Yes
Prise: No

SQL Converter is the utility, allowing one to extract information from source servers selectively and save it to a variety of formats.

SQLDBSearch

Download page: SQLDBSearch
Release date: ?
Support Version: 2000-2019
Author: Mohamed Bouarroudj
Free version: Yes
Prise: No

SQLDBSearch is a SQL Server tool that lets you easily and quickly search for database objects or SQL statements across your databases.

SQLDBSize

Download page: SQLDBSize
Release date: ?
Support Version: 2000-2019
Author: Mohamed Bouarroudj
Free version: Yes
Prise: No

SQLDBSize is a 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

Download page: SQLines Data
Release date: 2019-05-29
Support Version: ?
Author: SQLines
Free version: Yes
Prise: No

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.

SSqlDbAid

Download page: SqlDbAid
Release date: 2018-02-10
Support Version: 2005+
Author: Miken
Free version: Yes
Prise: No

Text search inside code definition with highlitghting
DBA reports (missing indexes, missing foreign key indexes, indexes status, top queries, table MBytes)
One file per object or single file scripts (tables, views, triggers, procedures, functions, indexes…)
Select, Insert and Update scripts
Table data insert script creation
Table/View data export
Offline database compare tool

sqlectron

Download page: sqlectron
Release date: 2018-09-06
Support Version: ?
Author: sqlectron
Free version: Yes
Prise: No

A simple and lightweight SQL client with cross database and platform support.

SQL ExecStats

Download page: SQL ExecStats
Release date: ?
Support Version: ?
Author: Elemental Inc
Free version: Yes
Prise: No

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

Download page: SQL-FineBuild
Release date: 2017-10-28
Support Version: 2005-2017
Author: Edward Vassie
Free version: Yes
Prise: No

SQL FineBuild provides 1-click install and best-practice configuration on Windows of SQL Server 2017 down to SQL Server 2005.

SQL Health Monitor

Download page: SQL Health Monitor
Release date: ?
Support Version: 2000-2014
Author: Edward Vassie
Free version: Yes
Prise: No

Keep a tab on the performance parameters of both default and named instances
Get a dashboard view of system resources used & MS SQL performance parameters
Fetch the status of Winodws services related to your MS SQL Server
Keep an eye on buffer, memory, lock and latch details of your MS SQL Server
Generate real time performance reports in PDF format and Email it from the tool

SQL Instance Check

Download page: SQL Instance Check
Release date: ?
Support Version: 2008-2019
Author: Idera
Free version: Yes
Prise: No

Monitor 20 key performance metrics
See throughput of varying types
See «heartbeat» statistics at different intervals
Up and running in minutes with easy installation wizard
No agents required
Connect to cloud and run in cloud (provisional)

SQLPRep

Download page: SQLPRep
Release date: ?
Support Version: ?
Author: Consequential Solutions
Free version: Yes
Prise: No

SQLPRep 2015 aka SQL Performance Report is our newest 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, optimising, testing and reviewing TSQL.

SQL Server Monitoring

Download page: SQL Server Monitoring
Release date: ?
Support Version: 2005 and higher
Author: Spiceworks
Free version: Yes
Prise: No

Auto collect data about the server
Instantly access health info on the data
Create multiple widgets to monitor what you want
Monitor SQL Server size, connection, speed & more

SQL Server Storage manager

Download page: SQL Server Storage manager
Release date: ?
Support Version: ?
Author: Lepide Software
Free version: Yes
Prise: No

Removes the need to writing complex SQL Servers and stored procedures
Provides real time alerts based on easy to configure criteria
Provides a centralized platform to create consolidated reports of all SQL resources
Provides simple graphical displays showing all elements of your SQL servers

SysKit Pulse

Download page: SysKit Pulse
Release date: ?
Support Version: ?
Author: SysKit Ltd
Free version: Yes
Prise: No

Track servers via interactive live dashboards.
Server Auto-Discover Wizard
Performance Counters Check
A simplified way of looking at your servers.

WhatsUp SQL Server Monitor

Download page: WhatsUp SQL Server Monitor
Release date: ?
Support Version: ?
Author: Ipswitch
Free version: Yes
Prise: No

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.

YourSqlDba

Download page: [YourSqlDba]
Release date: 2020-05-05
Support Version: ?
Author: Maurice Pelchat
Free version: Yes
Prise: No

YourSqlDba script creates a database named YourSqlDba packed with T-SQL modules (function, stored procedures, and views) on the server where it is run.
You don’t need to be concerned by all of them, albeit some of them are interesting tools for exceptional day-to-day DBA tasks, out of regular maintenance tasks.

POPSQL

Download page: POPSQL
Release date: 2020-08-01
Support Version: 2008-2019
Author: POPSQL
Free version: Yes
Prise: $10

Collaborative SQL editor for your team.
Write queries, visualize data, and share your results.

ApexSQL Search

Download page: ApexSQL Search
Release date: 2020-07-30
Support Version: SQL Server 2005 and higher
Author: ApexSQL
Free version: Yes
Price: No

Search for SQL objects
Quickly find data in SQL tables
Edit extended properties
Easily navigate to result objects
Rename SQL objects safely
Export results to HTML, CSV and Excel

ApexSQL Source Control

Download page: ApexSQL Source Control
Release date: 2020-01-20
Support Version: SQL Server 2005 and higher
Author: ApexSQL
Free version: No
Price: $299

Integrate SQL source control directly into SSMS
Use dedicated or shared development models
View conflicts and resolve directly in the UI
View a detailed history of changes
Lock objects to prevent overwrites
Set team policies for check outs and locks
Apply changes with dependency aware scripts
Create and apply labels from source control
Create branch or merge branches directly from SSMS
Associate a changeset with a TFS work item

Azure Blob Studio 2011

Download page: Azure Blob Studio 2011
Release date: 2010-12-25
Support Version: ?
Author: Alessandro Del Sole
Free version: Yes
Price: No

Azure Blob Studio is a tool for managing files in the Windows Azure’s Blob Storage
You can:

Work with both the developer and on-line accounts
Create containers (folders)
Upload multiple blobs (files)
Remove containers
Remove multiple blobs
Retrieve URI for each blob
Copy the blob’s URI to the clipboard right-clicking the Blob’s name
Retrieve metadata
Open blobs via URI

Azure Explorer

Download page: Azure Explorer
Release date: ?
Support Version: ?
Author: Monza Cloud
Free version: Yes
Price: No

Manage Azure blobs like local files
Support for common blob operations
Built for users with thousands of blob containers
Designed for Microsoft Azure

Azure SQL Agent

Download page: Azure SQL Agent
Release date: ?
Support Version: ?
Author: ?
Free version: Yes
Price: No

Command line agent to automatically add your current public IP address to the Azure SQL firewall

Azure SQL Database DTU Calculator

Download page: Azure SQL Database DTU Calculator
Release date: ?
Support Version: ?
Author: Justin Henriksen
Free version: Yes
Price: No

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.

Azure SQL Database Stress Test Tool

Download page: Azure SQL Database Stress Test Tool
Release date: ?
Support Version: ?
Author: Kiyoaki Tsurutani
Free version: Yes
Price: No

Azure SQL Database Stress Test Tool

Azure SQL Dev Cloner

Download page: Azure SQL Dev Cloner
Release date: ?
Support Version: ?
Author: ?
Free version: Yes
Price: No

Command line tool for cloning an Azure SQL Database from website instance to another. It optionally allows the target to be a Deployment Slot.

Azure User Management Console

Download page: Azure User Management Console
Release date: ?
Support Version: ?
Author: ?
Free version: Yes
Price: No

AUMC is a User Graphic Interface (GUI) that manages the users and logins of an Azure SQL database. The tool is simply convertin

CloudMonix SQL Azure Database Management

Download page: CloudMonix SQL Azure Database Management
Release date: ?
Support Version: ?
Author: CloudMonix
Free version: No
Price: $15

CloudMonix monitors Azure SQL Databases by tracking their key performance indicators retrieved from Azure Management API and Dynamic Management Views. In addition, CloudMonix allows to automate maintenance tasks and automatically scale the database performance tier according to load.

DB Ghost Change Manager Professional

Download page: DB Ghost Change Manager Professional
Release date: ?
Support Version: 2000-2019, Azure
Author: Innovartis Ltd
Free version: No
Price: £430

Scripts all object types into individual DROP/CREATE scripts, ready for check in to source control.
Scripts data into boilerplate INSERT scripts.
Builds databases from individual object scripts.
Highlights syntax, dependency and data errors.
Creates a single script for the database build that can be reused.
Can synchronize two databases making them match precisely.
Can synchronize an existing database to a set of base schema creation scripts in your Source Management System. This means that your Source Management System itself provides a complete audit trail.
Can insert custom scripts at the end of the build, before and after the synch process.
Creates a script of the differences between two databases or base schema scripts and a target database.
Handles all types of database object and all complex interactions.
Intuitive, straightforward wizard based interface.
SessionSave facility lets you save your wizard answers for later reuse.

dbForge Complete

Download page: dbForge Complete
Release date: 2020-09-01
Support Version: 2000-2019, Azure
Author: Devart
Free version: No
Price: $199

Speed up SQL query writing with IntelliSense-style SQL code completion
Beautify T-SQL code and unify code standards with smart SQL Formatter
Get the essential information on DB objects while you are writing a code
Format your SQL query right in Management Studio or Visual Studio
Use rich SQL code snippet collection, manage and modify the existing snippets or create your own templates
Navigate through the SQL document easily and synchronize it with the code
Rename tables, columns, procedures, and functions safely with automatic correction of references to the renamed objects
Boost your productivity significantly with convenient tabs and windows, as well as intuitive SQL statements management

dbForge SQL Azure Backup

Download page: dbForge SQL Azure Backup
Release date: 2013-04-18
Support Version: ?
Author: Devart
Free version: Yes
Price: No

Create a copy of your SQL Azure database on local SQL Server
Make an archive copy on your local hard drive
Restore SQL Azure database from archive
Schedule periodic backups to your Azure Blob storage

Devart Transaction Log

Download page: Devart Transaction Log
Release date: 2020-10-16
Support Version: 2008-2019
Author: Devart
Free version: No
Price: $600

dbForge Transaction Log for SQL Server is a powerful transaction log reader tool and .ldf file viewer.
With its help, you can view and analyze SQL Server transaction logs and recover data from them.
The tool provides detailed information about all data changes in your database and gives you the ability to revert unwanted transactions on different levels depending on your current needs.

Elastic database tools

Download page: Elastic database tools
Release date: ?
Support Version: Azure
Author: Microsoft
Free version: Yes
Price: No

The elastic database client library helping you run a sample app. The sample app creates a simple sharded application and explores key capabilities of the Elastic Database Tools feature of Azure SQL Database. It focuses on use cases for shard map management, data-dependent routing, and multi-shard querying. The client library is available for .NET as well as Java.

Microsoft Sync Framework

Download page: Microsoft Sync Framework
Release date: 2020-04-22
Support Version: Azure
Author: Microsoft
Free version: Yes
Price: No

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services, and devices.
Sync Framework 2.1 introduces new features that let you synchronize a SQL Server or SQL Server Compact database on your computer with a SQL Azure database. This release also introduces parameter-based filtering, the ability to remove synchronization scopes and templates from a database, and performance enhancements to make synchronization faster and easier.

MSSQL-Maestro

Download page: MSSQL-Maestro
Release date: 2017-06-29
Support Version: from 7.0 to 2019, Azure 11 and 12
Author: SQL Maestro Group
Free version: No
Price: $229

Complete and powerful database management, admin and development tool for Microsoft SQL Server and Microsoft Azure SQL Database.

MSSQLMerge

Download page: MSSQLMerge
Release date: ?
Support Version: 2008-2019, Azure
Author: Konstantin Semenenkov
Free version: Yes
Price: $50

MssqlMerge is an easy to use diff & merge tool for Microsoft SQL Server databases. This tool allows users to compare and import/export the most common database programming objects and the data between any two databases.

SQL Backup and FTP

Download page: SQL Backup and FTP
Release date: ?
Support Version: ?
Author: Pranas.NET
Free version: Yes
Price: $129

SQLBackupAndFTP is SQL Server, MySQL and PostgreSQL backup software that runs scheduled backups (full, differential or transaction log) of SQL Server or SQL Server Express databases (any version), runs file/folder backup, zips and encrypts the backups, stores them on a network or on an FTP server or in the cloud (Amazon S3 and others we’re constantly adding more), removes old backups, and sends an e-mail confirmation on the job’s success or failure.

SQL Bak

Download page: SQL Bak
Release date: ?
Support Version: ?
Author: Pranas.NET
Free version: Yes
Price: $9

Schedule and restore sql backup from any web browser on any device
Send backups to a folder, FTP, Dropbox, Google Drive, OneDrive, Amazon S3 and more
Monitor database performance and receive email alerts
Install our app on Windows or Linux, connect to sqlbak.com, then manage backups via the web

SQL Bulk Tools

Download page: SQL Bulk Tools
Release date: ?
Support Version: ?
Author: Greg Taylor
Free version: Yes
Price: No

SQL Data Examiner

Download page: SQL Data Examiner
Release date: ?
Support Version: ?
Author: Intelligent Database Solutions
Free version: No
Price: $400

Migrate data between database servers
Verify data migration success
Consolidate data from slave databases to a master database
Perform one-way master-slave or slave-master replication

SQL Examiner

Download page: SQL Examiner
Release date: ?
Support Version: ?
Author: Intelligent Database Solutions
Free version: No
Price: $400

Speed up the deployment of schema updates
Eliminate a chance of a human error
Quickly compare databases and find all the differences
Work with MSSQL, Oracle, PostgreSQL, MySQL
Keep your database schema under Source Control
Set up a scheduled comparison and synchronization
Performs cross-platform comparison and synchronization

SQL Database Backup

Download page: SQL Database Backup
Release date: ?
Support Version: ?
Author: Richard Astbury
Free version: Yes
Price: No

Windows Azure SQL Database Backup Utility.
This utility will take a copy of your SQL Database, and once the copy has completed, will make a backup of the database to blob storage using the bacpac format.

SQL Database Copy

Download page: SQL Database Copy
Release date: 2017-07-25
Support Version: ?
Author: ryanovic
Free version: Yes
Price: No

Simple console tool uses SMO scripting capabilities and SqlBulkCopy for schema and data migration between different instances.
Available options:

SQL Server database to Azure SQL database
SQL Server database to SQL Server database

SQL Delta Duo for SQL Server

Download page: SQL Delta Duo for SQL Server
Release date: ?
Support Version: ?
Author: The Australian Software Company
Free version: No
Price: $370

Compare and Sync Schema and Data for SQL Server databases.

SQL Trace Replay

Download page: SQL Trace Replay
Release date: ?
Support Version: ?
Author: Mikhail Shilkov
Free version: Yes
Price: No

Tool to capture and replay traces between SQL Server instances (and to Azure SQL Database in particular)

SQL Workload Profiler

Download page: [SQL Workload Profiler]
Release date: 2014-10-01
Support Version: 2008+, Azure
Author: Chris Bailiss
Free version: Yes
Price: No

SQL Workload Profiler is a free tool for capturing and logging workload performance information from SQL Server. Performance statistics can be captured minute-by-minute (or more frequently if you want, up to every ten seconds, depending on the type/size of workload). Data can be analysed as it is being collected and/or saved for later analysis. Workload Profiler supports both (on-premise) SQL Server and Azure SQL Database.

SQLDBdiff

Download page: [SQLDBdiff]
Release date: ?
Support Version: 2005-2019, Azure
Author: SQLDBtools
Free version: No
Price: $60

Tables and columns (with the possibility to respect or not columns order);
Views (including their indexes and triggers);
Stored procedures;
User defined functions;
Triggers;
PK and Indexes (with the possibility to include or not statistic indexes);
Relationships (FK);
CHECK Constraints;
Default Constraints;
User Defined Data Type & User Defined Table Type
DDL Triggers;
Synonyms;
In-Memory table
System versioning (Temporal type)
Permissions;
User and Roles;
Database properties;
SQL Server properties.

SQL Backup Master

Download page: SQL Backup Master
Release date: ?
Support Version: 2005-2019
Author: Key Metric Software
Free version: Yes
Price: $49

Supports full, differential, and transaction log backups
Simple yet powerful backup job scheduling
Built-in email notifications for backup job successes, failures, and warnings
Back up to local folders, network folders, or attached storage devices
Back up to FTP servers with first-class FTP, SFTP, & FTPS support
Back up to Dropbox, Google Drive, Box, Amazon S3, OneDrive, & Azure

Handy Backup Server

Download page: Handy Backup Server
Release date: 2019-03-11
Support Version: 2005-2019
Author: Novosoft
Free version: Yes
Price: $39

Automating All Operations
Native and Generic Database Backup
Other Server Data Backup
Saving Snapshots of Virtual Machines
Using Modern Local and Online Data Storages
Dealing with OS older than Windows Server 2019 or other

Veeam Explorer for Microsoft SQL Server

Download page: Veeam Explorer for Microsoft SQL Server
Release date: ?
Support Version: ?
Author: Veeam
Free version: No
Price: ?

Full database and table level recovery
Perform quick point-in-time restore
Delegate restore tasks to SQL DBAs
Part of Veeam Backup & Replication
Recover one or multiple databases simultaneously from a single-pass image level backup
Restore entire Microsoft SQL databases down to the table level
Microsoft SQL log backup provides transaction log replay to restore to a specific point in time

EaseUS Todo Backup Server

Download page: EaseUS Todo Backup Server
Release date: ?
Support Version: ?
Author: EaseUS
Free version: No
Price: $39

Add new backup tasks on disk, partition, system, mail and other data
Select a source system/disk/partition, target a location to store copies and clone fast
Create a bootable WinPE/Linux bootable USB/DVD/CD to restart the system from it
Check backup logs, replicate backup issues, and restore data from exact backup files
P2V copy, P2V recovery, P2V conversion. Clone, restore, and convert backup to the virtual machine

SqlBackupFree

Download page: SqlBackupFree
Release date: ?
Support Version: ?
Author: pranas.net
Free version: Yes
Price: No

Schedule SQL Server Database Backups. Full backups
Compress (zip) the backups
Send backups to FTP, local, network folder or HDD drive
Send e-mail confirmation on job success or failure

ERDPlus

Download page: ERDPlus
Release date: ?
Support Version: ?
Author: ERDPlus
Free version: ?
Price: ?

A database modeling tool for creating Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements.

SentryOne Test

Download page: SentryOne Test
Release date: ?
Support Version: ?
Author: SQL Sentry
Free version: No
Price: $828

Quickly build tests with wizards
Simplify unit testing
Build tests within Visual Studio
Create custom testing modules
Reconcile and verify data
Conduct BI testing

Query Performance Insight for Azure SQL Database

Download page: Query Performance Insight for Azure SQL Database
Release date: ?
Support Version: Azure
Author: Microsoft
Free version: Yes
Price: No

Deeper insight into your databases resource (DTU) consumption
Details on top database queries by CPU, duration, and execution count (potential tuning candidates for performance improvements)
The ability to drill down into details of a query, to view the query text and history of resource utilization
Annotations that show performance recommendations from database advisors

Code Quality and Security for T-SQL

Download page: Code Quality and Security for T-SQL
Release date: ?
Support Version: ?
Author: SonarSource
Free version: Yes
Price: €120

SonarSource provides static code analysis for T-SQL projects. Based on our own T-SQL compiler front-end, it uses the most advanced techniques (pattern matching, program flow analysis) to analyze code and find Code Smells, Bugs, and Security Vulnerabilities. As with everything we develop at SonarSource, it was built on the principles of depth, accuracy, and speed.

DBBALANCE

Download page: DBBALANCE
Release date: ?
Support Version: ?
Author: DBBalance
Free version: No
Price: ?

Data and Schema Synchronization
Data and Schema Comparison
Database Migration
Database Development

Convert SQL to Excel

Download page: Convert SQL to Excel
Release date: 2015-10-09
Support Version: 2000-2014
Author: MSSQL.TOOLS
Free version: Yes
Price: No

Easy way to convert SQL table or a subset of table to Excel. No programming.
Convert / export a SQL Table to Excel file (.xlsx or .xls format)
Convert multiple tables (multiple query results) to multiple Excel worksheets.
Allow flexible TSQL query which can have multiple SELECT statements or other complex query statements.
Supports command line execution (unattended mode). Useful for periodical scheduling.
Allow user defined Excel worksheet names.

Search string in Schema

Download page: Search string in Schema
Release date: 2015-10-09
Support Version: 2005-2012
Author: MSSQL.TOOLS
Free version: Yes
Price: No

This tool searches tables, columns, views, stored procedures, XPs, functions, triggers, constraints and SQL Agent Jobs in a database to find a given string.
Simply input target server, target database, search keyword and you will get fast search results!
Supports filterng by object type or schema user
Supports easy switch between multiple SQL Servers.
Supports SQL Agent Jobs search.

Search string in SQL

Download page: Search string in SQL
Release date: 2015-10-09
Support Version: 2005-2008
Author: MSSQL.TOOLS
Free version: Yes
Price: No

This tool helps you to search all columns of all tables in a database for a string keyword. In order to increase performance, it examines string type columns only in all tables to search for a given keyword.

SQL Table Scripter

Download page: SQL Table Scripter
Release date: 2015-10-09
Support Version: 2005, 2008
Author: MSSQL.TOOLS
Free version: Yes
Price: No

Generates a CREATE SQL script for a table.
Script can include all DRI (declarative referential integrity) such as Foreign Key, Constraints for the table.
Script can include Indexes for the table.
Generates INSERT SQL scripts for table data (optionally).

SQLCLR Util

Download page: SQLCLR Util
Release date: 2015-10-09
Support Version: 2005-2019r
Author: MSSQL.TOOLS
Free version: Yes
Price: No

generates DLL file from SQL CLR assembly in the SQL Server. When creating SQL CLR assembly with its DLL file, SQL Server saves the DLL binary into SQL Server system table. This tool help you to recreate DLL file easily from the SQL Server system table.
generates CREATE ASSEMBLY script from a DLL file. Once CREATE script is generated, one can run the script without physical .DLL file. This method will be useful when one has no permission to access physical disk on the server because there is no need to copy the file to server.

Image To SQL

Download page: Image To SQL
Release date: 2015-10-09
Support Version: 2005,2008 or later
Author: MSSQL.TOOLS
Free version: Yes
Price: No

Save any image file such as .JPG, .PNG, .BMP, .GIF to SQL Server table.
Image file is saved to any varbinary column (or image column)
User can specify input image file and table/column target in easy UI.
User can specify where to save image file by setting primary key value(s) of the user table in easy UI.

dbdiagram

Download page: dbdiagram
Release date: ?
Support Version: ?
Author: holistics.io
Free version: Yes
Price: $9/mo

A free, simple tool to draw ER diagrams by just writing code. Designed for developers and data analysts.

Generate SQL statements
Export to Images and PDFs
One Click Sharing
Integrate with your SQL Databases
Integrate with Popular Web Frameworks

Beekeeper Studio

Download page: Beekeeper Studio
Release date: 2020-10-19
Support Version: 2008-2019
Author: Beekeeper Studio
Free version: Yes
Price: No

Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

Autocomplete SQL query editor with syntax highlighting
Tabbed interface, so you can multitask
Sort and filter table data to find just what you need
Sensible keyboard-shortcuts
Save queries for later
Query run-history, so you can find that one query you got working 3 days ago
Default dark theme

Babelfish for Aurora PostgreSQL

Download page: Babelfish for Aurora PostgreSQL
Release date: 2020-12-01
Support Version: 2008-2019
Author: Amazon
Free version: Yes
Price: No

Babelfish is a new translation layer for Amazon Aurora PostgreSQL that enables Aurora to understand commands from applications written for Microsoft SQL Server.

Источник

EMS Database Management Solutions offers a comprehensive set of free database tools that allow you to achieve higher availability and better performance for data maintenance and database administration. These freeware programs for database management cover major database maintenance tasks and have essential functionality for efficient DBA and DB application developer work removing the need for a multitude of separate SQL utilities.

Designed for novices and power users alike, EMS SQL Manager Freeware makes it easy to control data infrastructure and provides all SQL tools necessary to set up database systems properly. Our free products line enables you to perform server administration, database development, user and security management, data viewing and editing and other common tasks using a single powerful free database program with an easy-to-use graphical interface.

EMS SQL Manager Freeware allows you to work with servers, databases and schemas, view, edit, search, group, sort and filter any data stored in a database, create and execute SQL queries with a powerful SQL editor, handle multiple selected objects at a time and much more.

We provide a wide range of free database software to access and manage the most popular database systems. EMS SQL Manager Freeware products support all server, database and table objects as well as the latest server versions and features for particular RDBMS

SQLManager.net Free Family

High performance tool for DB2 database administration and development

Simplify and automate your database development process

Simplify and automate SQL Server administration process

Simplify and automate your database development process

Simplify and automate your MySQL database development process

Powerful tool for InterBase and Firebird database administration and development

High performance database tool for Oracle database development and administration

Источник