| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
Manage SQL Server on Linux |
This article provides links to common management tasks and tools for SQL Server running on Linux. |
rwestMSFT |
randolphwest |
01/21/2025 |
sql |
linux |
conceptual |
|
>=sql-server-linux-2017 || >=sql-server-2017 |
[!INCLUDE SQL Server - Linux]
There are several ways to manage [!INCLUDE ssnoversion-md] on Linux. The following section provides a quick overview of different management tools and techniques with pointers to more resources.
The mssql-conf tool configures [!INCLUDE ssnoversion-md] on Linux. For more information, see Configure SQL Server on Linux with mssql-conf.
Almost everything you can do in a client tool can also be accomplished with Transact-SQL statements. [!INCLUDE ssnoversion-md] provides Dynamic Management Views (DMVs) that query the status and configuration of [!INCLUDE ssnoversion-md]. There are also Transact-SQL commands for database management tasks. You can run these commands in any client tool that supports connecting to [!INCLUDE ssnoversion-md] and running Transact-SQL queries, for example sqlcmd or Visual Studio Code.
The new Azure Data Studio is a cross-platform tool for managing [!INCLUDE ssnoversion-md]. For more information, see What is Azure Data Studio?
The Named Pipes protocol isn't supported for [!INCLUDE ssnoversion-md] on Linux.
SQL Server Management Studio (SSMS) is a Windows application that provides a graphical user interface for managing [!INCLUDE ssnoversion-md]. Although it currently runs only on Windows, you can use it to remotely connect to your Linux [!INCLUDE ssnoversion-md] instances. For more information on using SSMS to manage [!INCLUDE ssnoversion-md], see Use SSMS to Manage SQL Server on Linux.
Microsoft has released a new cross-platform scripting tool for [!INCLUDE ssnoversion-md], mssql-cli. This tool is currently in preview.
PowerShell provides a rich command-line environment to manage [!INCLUDE ssnoversion-md] on Linux. For more information, see Use PowerShell to Manage SQL Server on Linux.