Get started with SQL Server on Linux

Get started using SQL Server vNext CTP 1.3 on Linux. Here are basic steps with links to how-to information.

1: Install Linux

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 CTP 1.3 already installed. For more information, see Provision a Linux VM in Azure for SQL Server.

2: Install 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 Installation guide
SUSE Linux Enterprise Server v12 SP2 Installation guide
Ubuntu 16.04 and 16.10 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.

Note

You need at least 3.25GB of memory to run SQL Server on Linux. SQL Server Engine has been tested up to 1 TB of memory at this time.

3: Connect locally or remotely

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

4: Explore SQL Server capabilities 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:

Next steps

For the complete set of SQL Server documentation, see the Microsoft SQL Server Documentation.