Table of Contents

Table of Contents

About SQL Server on Linux Overview

Release notes What's new in this release? New and updated articles Editions and supported features Quickstarts Install & Connect - Red Hat Install & Connect - SUSE Install & Connect - Ubuntu Run & Connect - Docker Provision a SQL VM in Azure Run & Connect - Cloud Tutorials 1_Migrate from Windows 2_Migrate from Oracle 3_Migrate to Docker 4_Create a job 5_Setup AD Authentication 6_Create failover cluster instance

iSCSI NFS SMB 7_Deploy a Pacemaker cluster 8_Create and configure availability groups 9_Configure in Kubernetes for high availability Concepts Install Install SQL Server

Install SQL Server tools Install SQL Server Agent Install SQL Server Full-Text Search Install SQL Server Integration Services Register GA repository Configure Configure with mssql-conf Environment variables Configure Docker containers Customer Feedback Develop Connectivity libraries Use Visual Studio Code Use SSMS Use SSDT Manage Use SSMS to manage Use PowerShell to manage Use log shipping Use DB Mail and email alerts Configure multiple subnets for availability Migrate Export and import a BACPAC from Windows Migrate with SQL Server Migration Assistant Bulk copy with bcp Extract, transform, load Limitations and known issues Configure SSIS Schedule SSIS packages Configure business continuity Availability basics Backup and restore

Failover cluster instance Availability groups Security Get started with security features Encrypting connections Performance Best practices Get started with performance features Samples Unattended install Red Hat Enterprise Linux (RHEL) SUSE Linux Enterprise Server (SLES) Ubuntu Resources FAQ Troubleshoot SQL Server Documentation Partners Monitoring High availability and disaster recovery Management Development DBA Stack Exchange Stack Overflow MSDN Forums Microsoft Connect Reddit

SQL Server on Linux

12/22/2017 ? 1 min to read ? Edit Online

SQL Server 2017 now runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system.

Install

To get started, install SQL Server on Linux using one of the following quickstarts: Install on Red Hat Enterprise Linux Install on SUSE Linux Enterprise Server Install on Ubuntu Run on Docker Provision a SQL VM in Azure

NOTE Docker itself runs on multiple platforms, which means that you can run the Docker image on Linux, Mac, and Windows.

Connect

After installation, connect to the SQL Server instance on your Linux machine. You can connect locally or remotely and with a variety of tools and drivers. The quickstarts demonstrate how to use the sqlcmd command-line tool. Other tools include the following:

TOOL

TUTORIAL

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

Explore

SQL Server 2017 has the same underlying database engine on all supported platforms, including Linux. So many existing features and capabilities operate the same way on Linux. This area of the documentation exposes some of these features from a Linux perspective. It also calls out areas that have unique requirements on Linux.

If you are already familiar with SQL Server, review the Release notes for general guidelines and known issues for this release. Then look at what's new for SQL Server on Linux as well as what's new for SQL Server 2017 overall. For answers to frequently asked questions, see the SQL Server on Linux FAQ.

Engage with the SQL Server engineering team

DBA Stack Exchange: Ask database administration questions Stack Overflow: Ask development questions MSDN Forums: Ask technical questions

Microsoft Connect: Report bugs and request feature Reddit: Discuss SQL Server

Release notes for SQL Server 2017 on Linux

1/9/2018 ? 11 min to read ? Edit Online

The following release notes apply to SQL Server 2017 running on Linux. The topic below is broken into sections for each release. The GA release has detailed supportability and known issues listed. Each Cumulative Update (CU) release has a link to a support topic describing the CU changes as well as links to the Linux package downloads.

Supported platforms

PLATFORM

FILE SYSTEM

INSTALLATION GUIDE

Red Hat Enterprise Linux 7.3 or 7.4 Workstation, Server, and Desktop

XFS or EXT4

Installation guide

SUSE Enterprise Linux Server v12 SP2 EXT4

Installation guide

Ubuntu 16.04LTS

EXT4

Installation guide

Docker Engine 1.8+ on Windows, Mac, N/A or Linux

Installation guide

TIP For more details, review the system requirements for SQL Server on Linux. For the latest support policy for SQL Server 2017, see the Technical support policy for Microsoft SQL Server.

Supported client tools

TOOL

SQL Server Management Studio (SSMS) for Windows SQL Server Data Tools for Visual Studio Visual Studio Code with the mssql extension

MINIMUM VERSION

17.0 17.0 Latest

Release history

The following table lists the release history for SQL Server 2017.

RELEASE

VERSION

CU3

14.0.3015.40

CU2

14.0.3008.27

CU1

14.0.3006.16

RELEASE DATE

1-2018 11-2017 10-2017

RELEASE

GA

VERSION

14.0.1000.169

RELEASE DATE

10-2017

How to install cumulative updates

If you have configured the Cumulative Update repository, then you will get the latest cumulative update of SQL Server packages when you perform new installations. The Cumulative Update repository is the default for all package installation articles for SQL Server on Linux. For more information about repository configuration, see Source repositories.

If you are updating existing SQL Server packages, run the appropriate update command for each package to get the latest cumulative update. For specific update instructions for each package, see the following installation guides:

Install SQL Server package Install Full-text Search package Install SQL Server Agent package Install SQL Server Integration Services

Cumulative Update 3 (January 2018)

This is the Cumulative Update 3 (CU3) release of SQL Server 2017. The SQL Server engine version for this release is 14.0.3015.40. For information about the fixes and improvements in this release, see .

Package details For manual or offline package installations, you can download the RPM and Debian packages with the information in the following table:

PACKAGE

PACKAGE VERSION

DOWNLOADS

Red Hat RPM package

14.0.3015.40-1

Engine RPM package High Availability RPM package Full-text Search RPM package SQL Server Agent RPM package SSIS package

SLES RPM package

14.0.3015.40-1

mssql-server Engine RPM package High Availability RPM package Full-text Search RPM package SQL Server Agent RPM package

Ubuntu 16.04 Debian package

14.0.3015.40-1

Engine Debian package High Availability Debian package Full-text Search Debian package SQL Server Agent Debian package SSIS package

Cumulative Update 2 (November 2017)

This is the Cumulative Update 2 (CU2) release of SQL Server 2017. The SQL Server engine version for this release is 14.0.3008.27. For information about the fixes and improvements in this release, see .

Package details For manual or offline package installations, you can download the RPM and Debian packages with the information in the following table:

PACKAGE

PACKAGE VERSION

DOWNLOADS

Red Hat RPM package

14.0.3008.27-1

Engine RPM package High Availability RPM package Full-text Search RPM package SQL Server Agent RPM package SSIS package

SLES RPM package

14.0.3008.27-1

mssql-server Engine RPM package High Availability RPM package Full-text Search RPM package SQL Server Agent RPM package

Ubuntu 16.04 Debian package

14.0.3008.27-1

Engine Debian package High Availability Debian package Full-text Search Debian package SQL Server Agent Debian package SSIS package

Cumulative Update 1 (October 2017)

This is the Cumulative Update 1 (CU1) release of SQL Server 2017. The SQL Server engine version for this release is 14.0.3006.16. For information about the fixes and improvements in this release, see .

Package details For manual or offline package installations, you can download the RPM and Debian packages with the information in the following table:

PACKAGE

PACKAGE VERSION

DOWNLOADS

Red Hat RPM package

14.0.3006.16-3

Engine RPM package High Availability RPM package Full-text Search RPM package SQL Server Agent RPM package SSIS package

SLES RPM package

14.0.3006.16-3

mssql-server Engine RPM package High Availability RPM package Full-text Search RPM package SQL Server Agent RPM package

Ubuntu 16.04 Debian package

14.0.3006.16-3

Engine Debian package High Availability Debian package Full-text Search Debian package SQL Server Agent Debian package SSIS package

GA (October 2017)

This is the General Availability (GA) release of SQL Server 2017. The SQL Server engine version for this release is 14.0.1000.169.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download