| title | Get started with SQL Server on Linux - SQL Server vNext CTP1 | Microsoft Docs |
|---|---|
| description | This topic provides a learning path for getting started with SQL Server vNext on Linux. It also includes links to other resources for each step. |
| author | rothja |
| ms.author | jroth |
| manager | jhubbard |
| ms.date | 11/14/2016 |
| ms.topic | article |
| ms.prod | sql-linux |
| ms.technology | database-engine |
| ms.assetid | 66d96e59-2ded-4460-b350-fda80d93d79b |
Get started using SQL Server vNext CTP1 on Linux. Here are basic steps with links to how-to information.
If you do not already have a Linux machine, install Linux on a physical server or a virtual machine (VM). Review the Release notes on supported platforms and requirements.
Note
One option is to create use a pre-configured Linux VM in Azure. In addition to OS-only VMs, there is also a VM image with SQL Server vNext CTP1 already installed. For more information, see Provision a Linux VM in Azure for SQL Server.
Next, set up SQL Server vNext on your Linux machine, or run the Docker image, using one of the following guides:
| Platform | Installation |
|---|---|
| Red Hat Enterprise 7.2 | Installation guide |
| Ubuntu 16.04 | Installation guide |
| Docker | Installation guide |
Note that Docker itself runs on multiple platforms, which means that you can run the Docker image on Linux, Mac, and Windows.
After installation, connect to the running SQL Server instance on your Linux machine. For a general discussion of connectivity, see Connect and query SQL Server on Linux. Then run some Transact-SQL queries using a client tool. Examples include:
| Tool | Tutorial |
|---|---|
| Sqlcmd | Use the Sqlcmd command-line utility on Linux |
| Visual Studio Code (VS Code) | Use VS Code with SQL Server on Linux |
| SQL Server Management Studio (SSMS) | Use SSMS on Windows to connect to SQL Server on Linux |
| SQL Server Data Tools (SSDT) | Use SSDT with SQL Server on Linux |
SQL Server vNext has the same underlying database engine on all supported platforms, including Linux. So many existing features and capabilities operate the same way on Linux.
If you are already familiar with SQL Server, you'll want to review the Release notes for general guidelines and known issues for this release.
If you are new to SQL Server, you might find it helpful to quickly explore some of the security and performance capabilities in the following two guides:
Then learn how to develop and manage SQL Server:
For the complete set of SQL Server documentation, see the Microsoft SQL Server Documentation.