Tools – SQL Server

To manage your database, you need a tool. Whether your databases run in the cloud, on Windows, on macOS, or on Linux, your tool doesn’t need to run on the same platform as the database.

You can view the links to the different SQL tools in the following tables.

Recommended tools

Graphical User Interface (GUI) – Tools

ToolsDescriptionOperating System

SQL Server Management Studio (SSMS)
Manage a SQL Server instance or database with full GUI support. Access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and SQL Data Warehouse. Provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQl for developers and database administrators of all skill levels.Windows

SQL Server Data Tools (SSDT)
A modern development tool for building SQL Server relational databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) 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.Windows

Azure Data Studio
A light-weight editor that can run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.Windows
macOS
Linux
Graphical User Interface (GUI) – Tools

SQL Server Management Studio (SSMS)

SSMS is Free!! SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud.

SSMS – Prerequisites for Installation:

SSMS supports the following 64-bit platforms when used with the latest available service pack:

Supported Operating Systems:
  • Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • Windows 8.1 (64-bit)
  • Windows Server 2019 (64-bit)
  • Windows Server 2016 (64-bit)
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)
Supported hardware:
  • 1.8 GHz or faster processor. Dual-core or better recommended.
  • 2 GB of RAM; 4 GB of RAM recommended. (2.5 GB minimum if running on a virtual machine)
  • Hard disk space: Minimum of 2 GB up to 10 GB of available space.
SSMS – Latest Release Download:

Version Details:
Release number: 18.6
Build number: 15.0.18338.0
Release date: July 22, 2020

Download SQL Server Management Studio (SSMS)

Previous Releases:

Version Details:
Release number: 18.5.1
Build number: 15.0.18333.0
Release date: June 09, 2020

Version Details:
Release number: 18.5
Build number: 15.0.18330.0
Release date: April 07, 2020

Version Details:
Release number: 18.4
Build number: 15.0.18206.0
Release date: Nov 04, 2019

SQL Server Data Tools (SSDT)

SSDT is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) 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.

SSDT – Prerequisites for Installation:

Supported Operating Systems:

  • Windows 10 version 1507 or higher: Home, Professional, Education, and Enterprise (LTSC and S are not supported)
  • Windows Server 2016: Standard and Datacenter
  • Windows 8.1 (with Update 2919355): Core, Professional, and Enterprise
  • Windows Server 2012 R2 (with Update 2919355): Essentials, Standard, Datacenter
  • Windows 7 SP1 (with latest Windows Updates): Home Premium, Professional, Enterprise, Ultimate

Supported hardware:

  • 1.8 GHz or faster processor. Dual-core or better recommended.
  • 2 GB of RAM; 4 GB of RAM recommended. (2.5 GB minimum if running on a virtual machine)
  • Hard disk space: up to 130 GB of available space, depending on features installed; typical installations require 20-50 GB of free space.
  • Hard disk speed: to improve performance, install Windows and Visual Studio on a solid state drive (SSD).
  • Video card that supports a minimum display resolution of 720p (1280 by 720); Visual Studio will work best at a resolution of WXGA (1366 by 768) or higher.
Install SSDT with Visual Studio 2019

SSDT for Visual Studio 2019

If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT. If you don’t have Visual Studio 2019 installed, then you can download and install Visual Studio 2019 Community.

  • For SQL Database projects, select SQL Server Data Tools under Data storage and processing in the list of workloads.
Install SSDT with Visual Studio 2017
  • To install SSDT during Visual Studio installation, select the Data storage and processing workload, and then select SQL Server Data Tools.

If Visual Studio is already installed, you can edit the list of workloads to include SSDT.

SSDT
  • Install Analysis Services, Integration Services, and Reporting Services tools.
  • To install Analysis Services, Integration Services, and Reporting Services project support, run the SSDT standalone installer.

The installer lists available Visual Studio instances to add SSDT tools. If Visual Studio isn’t already installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience, we recommend using SSDT with the latest version of Visual Studio.

SQL Server Data Tools
SSDT for VS 2017 (standalone installer)

Download SSDT for Visual Studio 2017 (15.9.6)

Azure Data Studio

A light-weight editor that can run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. Azure Data Studio runs on Windows, macOS, and Linux.

Download and install the latest release:

Platform: Windows
Release date: August 12, 2020
Version: 1.21.0
Download: User Installer (recommended) / System Installer / .zip

Platform: macOS
Release date: August 12, 2020
Version: 1.21.0
Download: .zip

Platform: Linux
Release date: August 12, 2020
Version: 1.21.0
Download: .deb / .rpm / .tar.gz

Supported Operating Systems:
Azure Data Studio runs on Windows, macOS, and Linux, and is supported on the following platforms:

  • Windows
  • Windows 10 (64-bit)
  • Windows 8.1 (64-bit)
  • Windows 8 (64-bit)
  • Windows 7 (SP1)
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)
  • macOS
  • macOS 10.15 Catalina
  • macOS 10.14 Mojave
  • macOS 10.13 High Sierra
  • macOS 10.12 Sierra
  • Linux
  • Red Hat Enterprise Linux 7.4
  • Red Hat Enterprise Linux 7.3
  • SUSE Linux Enterprise Server v12 SP2
  • Ubuntu 16.04

Recommended System Requirements:
CPU Cores: 4 (Recommended) / 2 (Minimum)
Memory/RAM: 8 GB (Recommended) / 4 GB (Minimum)

Command-line tools

The tools below are the main command-line tools.
  1. bcp – The bulk copy program utility (bcp) 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. 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.

NOTE: The command-line tools are General Availability (GA), however they’re being released with the installer package for SQL Server 2019 (15.x).

Following link to download:

Version Information:
Release number: 15.0
Build number: 15.0.1300.359
Release date: March 13, 2019
Platform: Windows, macOS, Linux
Command to check the present version: bcp /v

Download bcp for x64 Download Microsoft Command Line Utilities 15 for SQL Server (x64)
Download bcp for x86 Download Microsoft Command Line Utilities 15 for SQL Server (x86)

System Requirements: Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019.

This component requires both Windows Installer 4.5 and Microsoft ODBC Driver 17 for SQL Server.

  1. sqlcmd – utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.

Following link to download:

Version Information:
Release number: 15.0.2
Build number: 15.0.2000.5
Release date: September 11, 2020
Platform: Windows, Linux
Command to check the present version: sqlcmd -?

Download sqlcmd for x64 Download Microsoft Command Line Utilities 15 for SQL Server (x64) (2.6 MB)
Download sqlcmd for x86 Download Microsoft Command Line Utilities 15 for SQL Server (x86) (2.3 MB)

Published by Abdul Samad

Having 17+ years of extensive experience in IT industry, enabled to enhance the team performance and maximize customer satisfaction by strategically managing calls and implementing process improvements. Demonstrated ability to solve problems, meets challenging goals, and expedites delivery. Skilled MSSQL administrator guide team during the crisis situation. Apply Creative thoughts process in re-designing the workflow system to eliminate duplication of effort and increase productivity.

Leave a Reply