| title | Develop applications for SQL Server on Linux |
|---|---|
| description | You can create applications that connect to and use SQL Server on Linux from a variety of programming languages and popular web frameworks. |
| author | VanMSFT |
| ms.author | vanto |
| ms.date | 11/17/2017 |
| ms.topic | conceptual |
| ms.prod | sql |
| ms.technology | linux |
| ms.assetid | 758cb738-b018-465b-9ab0-59a24b892e66 |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-linuxonly]
You can create applications that connect to and use SQL Server on Linux from a variety of 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.
[!VIDEO https://channel9.msdn.com/events/Connect/2017/T153/player]
Tip
These same development options also enable you to target SQL Server on other platforms. Applications can target SQL Server running on-premises or in the cloud, on Linux, Windows, or Docker on macOS. Or you can target Azure SQL Database and Azure SQL Data Warehouse.
The best way to get started and build applications with SQL Server is to try it out for yourself.
- Browse to Getting Started Tutorials.
- Select your language and development platform.
- Try the code samples.
Tip
If you want to develop for SQL Server on Docker, take a look at the macOS tutorials.
If you're creating a new application, take a look at a list of the Connectivity libraries for a summary of the connectors and popular frameworks available for various programming languages.
If you have an existing database application, you can simply change its connection string to target SQL Server on Linux. Make sure to read about the Known Issues in SQL Server on Linux.
Tools that currently run on Windows such as SSMS, SSDT, and PowerShell, also work with SQL Server on Linux. Although they do not run natively on Linux, you can still manage remote SQL Server instances on Linux.
See the following topics for more information:
Note
Make sure that you are using the latest versions of these tools for the best experience.
You can use the new 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 new command-line tools that are native for Linux. These tools include the following:
To get started, install SQL Server on Linux using one of the following quickstarts: