Use SSMS to manage

on Linux

This article introduces

Management Studio (SSMS)

and walks you through a few

common tasks. SSMS is a Windows application, so use SSMS when you have a Windows machine

that can connect to a remote SQL Server instance on Linux.

Management Studio (SSMS) is part of a suite of SQL tools that Microsoft offers free of

charge for your development and management needs. SSMS is an integrated environment to

access, configure, manage, administer, and develop all components of SQL Server. It can connect

to SQL Server running on any platform both on-premises, in Docker containers, and in the cloud.

It also connects to Azure SQL Database and Azure Synapse Analytics. SSMS combines a broad

group of graphical tools with many rich script editors to provide access to SQL Server to

developers and administrators of all skill levels.

SSMS offers a broad set of development and management capabilities for SQL Server, including

tools to:

Configure, monitor, and administer single or multiple instances of SQL Server

Deploy, monitor, and upgrade data-tier components such as databases and data

warehouses

Back up and restore databases

Build and execute Transact-SQL (T-SQL) queries and scripts and see results

Generate T-SQL scripts for database objects

View and edit data in databases

Visually design T-SQL queries and database objects such as views, tables, and stored

procedures

For more information, see

What is SQL Server Management Studio (SSMS)?



Tip

You can connect to an instance of SQL Server using any familiar SQL Server client tool, such

as

sqlcmd

,

Management Studio (SSMS)

, or the.