| title | Manage SQL Server on Linux | |
|---|---|---|
| description | This article provides links to common management tasks and tools for SQL Server running on Linux. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 08/23/2023 | |
| ms.service | sql | |
| ms.subservice | linux | |
| ms.topic | conceptual | |
| ms.custom |
|
|
| monikerRange | >=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 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.