Skip to content

sql-server-linux-release-notes.md

Latest commit

 

History

History
109 lines (92 loc) · 5.34 KB

sql-server-linux-release-notes.md

File metadata and controls

109 lines (92 loc) · 5.34 KB
title Release notes for SQL Server on Linux - SQL Server vNext CTP1 | Microsoft Docs
description This topic contains the release notes and supported features for SQL Server vNext CTP1 running on Linux.
author rothja
ms.author jroth
manager jhubbard
ms.date 11/08/016
ms.topic article
ms.prod sql-linux
ms.technology database-engine
ms.assetid 1314744f-fcaf-46db-800e-2918fa7e1b6c

Release notes for SQL Server on Linux

The following release notes apply to SQL Server vNext CTP1 running on Linux.

Supported operating systems

  • Ubuntu 16.04LTS (EXT4 file system)
  • Red Hat Enterprise Linux 7.2: Workstation, Server, and Desktop. (XFS or EXT4 file systems).
  • Docker Engine 1.8+ on Windows, Mac or Linux.

Minimum requirements

Docker

  • Less than 64 cores. Using 64 or more cores will cause an error.
  • Less than 32 GB of memory. If more than 32 GB of memory is available, only 32 GB will be used.

Unsupported features and services

The following features and services are not available on Linux at this time.

Area Unsupported feature or service
Database engine Full-text Search
  Replication
  Stretch DB
  Polybase
  Distributed Query
  Filestream
  XP_CMDSHELL
  Filetable
High Availability Always On Availability Groups
  Clustering
  Database mirroring
Security Active Directory authentication
  Windows Authentication
Services SQL Server Agent
  SQL Server Browser
  SQL Server R services
  StreamInsight
  Business Intelligence Suite
  Analysis Services
  Reporting Services
  Integration Services
  Data Quality Services
  Master Data Services

Known issues

The following sections describe known issues with this release of SQL Server vNext CTP1 on Linux.

General

  • Manually setting the system time backwards in time will cause SQL Server to stop updating the internal system time within SQL Server. Resolution: Restart SQL Server.
  • Some time zone names in Linux don’t map exactly to Windows time zone names. Resolution: Use time zone names from TZID column in the ‘Mapping for: Windows’ section table on the Unicode.org documentation page.
  • The length of the hostname where SQL Server is installed needs to be 15 characters or less.
  • The length of the hostname where SQL Server is installed needs to be 15 characters or less.
  • Dynamic Management Views, including dm_os_volume_stats, are currently unsupported.
  • Paths in T-SQL queries must use "C:" as the root of the path. “C:\” is mapped to /var/opt/mssql/ on the Linux host. ** Resolution**: Use this mapping in T-SQL queries. For example: C:\data maps to /var/opt/mssql/data.
  • SQL Server Engine expects lines in text files to be terminated with CR-LF (Windows-style line formatting).
  • The operating system version displayed in SQL Management Studio for the SQL Server properties will say ‘Windows NT’ even though SQL Server is running on Linux.
  • Only database files that are backed up from SQL Server 2016 RTM and lower can be restored.
  • Only single instance installations are supported.
  • All log files and error logs are encoded in UTF-16.
  • Using SqlPackage requires to specify an absolute path for files. Using relative paths will map the files under the“/tmp/sqlpackage.<code>/system/system32” folder. Resolution: Use absolute file paths.
  • SqlPackage shows the location of files with a “C:\” prefix.
  • Changing the locations of TempDB data and log files is not supported.
  • SQL Server Configuration Manager can’t connect to SQL Server on Linux.

In-Memory OLTP

In-Memory OLTP databases can only be created in the /var/opt/mssql directory. If you require more space than what is available at that location, one solution is to mount a drive under var/opt/mssql.

SQL Server Management Studio (SSMS)

The following limitations apply to SSMS on Windows connected to SQL Server on Linux.

  • Maintenance plans are not supported.
  • Management Data Warehouse (MDW) and the data collector in SSMS is not supported.
  • SSMS UI components that have Windows Authentication or Windows event log options do not work with Linux. You can still use these features with other options, such as SQL logins.
  • The SQL Server Agent only supports TSQL-based jobs. Agent functionality in SSMS which relies on other job types do not work on Linux.
  • The file browser is restricted to the “C:\” scope, which resolves to /var/opt/mssql/ on Linux. To use other paths, generate scripts of the UI operation and replace the C:\ paths with Linux paths. Then execute the script manually in SSMS.

Supported client tools

Tool Minimum version
SQL Server Management Studio (SSMS) for Windows 13.0.11000.78
SQL Server Data Tools for Visual Studio 14.0.60203.0
Visual Studio Code with the vscode-mssql extension Latest