Graphic User Interface (GUI-based Tools)
SQL Server Management Studio (SSMS)
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
Previous Five Releases:
Version Details:
Version Details:
Version Details:
Version Details:
Version Details:
Azure Data Studio
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
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)
SQL Server Data Tools (SSDT)
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.
![Data storage and processing workload](https://docs.microsoft.com/en-us/sql/ssdt/media/download-sql-server-data-tools-ssdt/data-workload-2019.png?view=sql-server-ver15)
- For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from either Tools -> Extensions and Updates or from the Marketplace.
SSDT for Visual Studio 2017
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.
![Data storage and processing workload](https://docs.microsoft.com/en-us/sql/ssdt/media/download-sql-server-data-tools-ssdt/data-workload-2017.png?view=sql-server-ver15)
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.
![Select AS, IS, RS](https://docs.microsoft.com/en-us/sql/ssdt/media/download-sql-server-data-tools-ssdt/select-services.png?view=sql-server-ver15)
SSDT for VS 2017 (standalone installer):
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.
Following link to download:
Version Information:
Release number: 15.0
Build number: 15.0.1300.359
Release date: March 13, 2019
Build number: 15.0.1300.359
Release date: March 13, 2019
Platform: Windows, macOS, Linux
Command to check the present version: bcp /v
NOTE: The command-line tools are General Availability (GA), however they're being released with the installer package for SQL Server 2019 (15.x).
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.
2. 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
Build number: 15.0.1300.359
Release date: March 13, 2019
Build number: 15.0.1300.359
Release date: March 13, 2019
Platform: Windows, macOS, Linux
Command to check the present version: sqlcmd -?
System Requirements
Windows 10 , Windows 7, Windows 8, Windows 8.1, Windows Server 2008 - 2019.