Skip to content

Latest commit

 

History

History
74 lines (56 loc) · 3.79 KB

File metadata and controls

74 lines (56 loc) · 3.79 KB
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 with SQL Server on Linux

Get started using SQL Server vNext CTP1 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 CTP1 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 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.

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.