title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | |
---|---|---|---|---|---|---|---|---|---|
Develop applications for SQL Server on Linux |
You can create applications that connect to and use SQL Server on Linux from various programming languages and popular web frameworks. |
rwestMSFT |
randolphwest |
01/03/2024 |
sql |
linux |
conceptual |
|
[!INCLUDE SQL Server - Linux]
You can create applications that connect to and use [!INCLUDE ssnoversion-md] on Linux from various programming languages, such as C#, Java, Node.js, PHP, Python, Ruby, and C++. You can also use popular web frameworks and Object Relational Mapping (ORM) frameworks.
Tip
These same development options also enable you to target [!INCLUDE ssnoversion-md] on other platforms. Applications can target [!INCLUDE ssnoversion-md] running on-premises or in the cloud, on Linux, Windows, or Docker on macOS. Or you can target Azure SQL Database and Azure Synapse Analytics.
The best way to get started and build applications with [!INCLUDE ssnoversion-md] is to try it out for yourself.
- Browse to SQL Data Developer.
- Select your language and development platform.
- Try the code samples.
Tip
If you want to develop for [!INCLUDE ssnoversion-md] on Docker, take a look at the macOS tutorials.
If you're creating a new application, refer to the Connectivity libraries and frameworks for Microsoft SQL Server, for a summary of the connectors and popular frameworks available for various programming languages.
If you have an existing database application, you can change its connection string to target [!INCLUDE ssnoversion-md] on Linux. For more information, see SQL Server on Linux: Known issues.
Tools that currently run on Windows such as SSMS, SSDT, and PowerShell, also work with [!INCLUDE ssnoversion-md] on Linux. Although they don't run natively on Linux, you can still manage remote [!INCLUDE ssnoversion-md] instances on Linux.
See the following articles for more information:
- Use SQL Server Management Studio on Windows to manage SQL Server on Linux
- Use Visual Studio to create databases for SQL Server on Linux
- Use PowerShell on Windows to manage SQL Server on Linux
Note
Make sure that you're using the latest versions of these tools for the best experience.
You can use the mssql extension for Visual Studio Code on Linux, macOS, and Windows. For a step-by-step walkthrough, see the following tutorial:
You can also use command-line tools that are native for Linux. These tools include the following: