Skip to content

Commit fb20516

Browse files
VanMSFTVanMSFT
committed
Update for CU3 and Ubuntu 18.04
1 parent b862adb commit fb20516

6 files changed

Lines changed: 138 additions & 30 deletions

‎docs/linux/quickstart-install-connect-docker.md‎

Lines changed: 13 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@ ms.custom: seo-lt-2019
55
author: vin-yu
66
ms.author: vinsonyu
77
ms.reviewer: vanto
8-
ms.date: 11/04/2019
8+
ms.date: 03/12/2020
99
ms.topic: conceptual
1010
ms.prod: sql
1111
ms.technology: linux
@@ -31,13 +31,17 @@ In this quickstart, you use Docker to pull and run the SQL Server 2017 container
3131
<!--SQL Server 2019 on Linux-->
3232
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
3333

34+
> [!NOTE]
35+
> Starting with SQL Server 2019 CU3, Ubuntu 18.04 is supported.
36+
3437
In this quickstart, you use Docker to pull and run the SQL Server 2019 container image, [mssql-server](https://hub.docker.com/r/microsoft/mssql-server). Then connect with **sqlcmd** to create your first database and run queries.
3538

3639
> [!TIP]
3740
> This quickstart creates SQL Server 2019 containers. If you prefer to create SQL Server 2017 containers, see the [SQL Server 2017 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-2017).
41+
3842
::: moniker-end
3943

40-
This image consists of SQL Server running on Linux based on Ubuntu 16.04. It can be used with the Docker Engine 1.8+ on Linux or on Docker for Mac/Windows. This quickstart specifically focuses on using the SQL Server on **linux** image. The Windows image is not covered, but you can learn more about it on the [mssql-server-windows-developer Docker Hub page](https://hub.docker.com/r/microsoft/mssql-server-windows-developer/).
44+
This image consists of SQL Server running on Linux based on Ubuntu 18.04. It can be used with the Docker Engine 1.8+ on Linux or on Docker for Mac/Windows. This quickstart specifically focuses on using the SQL Server on **linux** image. The Windows image is not covered, but you can learn more about it on the [mssql-server-windows-developer Docker Hub page](https://hub.docker.com/r/microsoft/mssql-server-windows-developer/).
4145

4246
## <a id="requirements"></a> Prerequisites
4347

@@ -178,19 +182,19 @@ Before starting the following steps, make sure that you have selected your prefe
178182

179183
::: zone pivot="cs1-bash"
180184
```bash
181-
sudo docker pull mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
185+
sudo docker pull mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04
182186
```
183187
::: zone-end
184188

185189
::: zone pivot="cs1-powershell"
186190
```PowerShell
187-
docker pull mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
191+
docker pull mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04
188192
```
189193
::: zone-end
190194

191195
::: zone pivot="cs1-cmd"
192196
```cmd
193-
docker pull mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
197+
docker pull mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04
194198
```
195199
::: zone-end
196200

@@ -209,23 +213,23 @@ Before starting the following steps, make sure that you have selected your prefe
209213
```bash
210214
sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong@Passw0rd>" \
211215
-p 1433:1433 --name sql1 \
212-
-d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
216+
-d mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04
213217
```
214218
::: zone-end
215219

216220
::: zone pivot="cs1-powershell"
217221
```PowerShell
218222
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong@Passw0rd>" `
219223
-p 1433:1433 --name sql1 `
220-
-d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
224+
-d mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04
221225
```
222226
::: zone-end
223227

224228
::: zone pivot="cs1-cmd"
225229
```cmd
226230
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=<YourStrong@Passw0rd>" `
227231
-p 1433:1433 --name sql1 `
228-
-d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
232+
-d mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04
229233
```
230234
::: zone-end
231235

@@ -243,7 +247,7 @@ Before starting the following steps, make sure that you have selected your prefe
243247
| **-e "SA_PASSWORD=\<YourStrong@Passw0rd\>"** | Specify your own strong password that is at least 8 characters and meets the [SQL Server password requirements](../relational-databases/security/password-policy.md). Required setting for the SQL Server image. |
244248
| **-p 1433:1433** | Map a TCP port on the host environment (first value) with a TCP port in the container (second value). In this example, SQL Server is listening on TCP 1433 in the container and this is exposed to the port, 1433, on the host. |
245249
| **--name sql1** | Specify a custom name for the container rather than a randomly generated one. If you run more than one container, you cannot reuse this same name. |
246-
| **mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04** | The SQL Server 2019 Ubuntu Linux container image. |
250+
| **mcr.microsoft.com/mssql/server:2019-CU3-ubuntu-18.04** | The SQL Server 2019 Ubuntu Linux container image. |
247251

248252
3. To view your Docker containers, use the `docker ps` command.
249253

‎docs/linux/quickstart-install-connect-ubuntu.md‎

Lines changed: 80 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "Ubuntu: Install SQL Server on Linux"
33
description: This quickstart shows how to install SQL Server 2017 or SQL Server 2019 on Ubuntu and then create and query a database with sqlcmd.
44
author: VanMSFT
55
ms.author: vanto
6-
ms.date: 11/04/2019
6+
ms.date: 03/12/2020
77
ms.topic: conceptual
88
ms.prod: sql
99
ms.custom: seo-lt-2019
@@ -17,13 +17,14 @@ ms.assetid: 31c8c92e-12fe-4728-9b95-4bc028250d85
1717
<!--SQL Server 2017 on Linux-->
1818
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
1919

20-
In this quickstart, you install SQL Server 2017 or SQL Server 2019 on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
20+
In this quickstart, you install SQL Server 2017 on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
2121

2222
::: moniker-end
23+
2324
<!--SQL Server 2019 on Linux-->
2425
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
2526

26-
In this quickstart, you install SQL Server 2019 on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
27+
In this quickstart, you install SQL Server 2019 on Ubuntu 18.04. You then connect with **sqlcmd** to create your first database and run queries.
2728

2829
::: moniker-end
2930

@@ -32,6 +33,9 @@ In this quickstart, you install SQL Server 2019 on Ubuntu 16.04. You then connec
3233
3334
## Prerequisites
3435

36+
<!--SQL Server 2017 on Linux-->
37+
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
38+
3539
You must have a Ubuntu 16.04 machine with **at least 2 GB** of memory.
3640

3741
To install Ubuntu 16.04 on your own machine, go to [http://releases.ubuntu.com/xenial/](http://releases.ubuntu.com/xenial/). You can also create Ubuntu virtual machines in Azure. See [Create and Manage Linux VMs with the Azure CLI](https://docs.microsoft.com/azure/virtual-machines/linux/tutorial-manage-vm).
@@ -44,6 +48,22 @@ For other system requirements, see [System requirements for SQL Server on Linux]
4448
> [!NOTE]
4549
> Ubuntu 18.04 is not yet officially supported, but running SQL Server is possible with [modifications](https://blogs.msdn.microsoft.com/sql_server_team/installing-sql-server-2017-for-linux-on-ubuntu-18-04-lts/).
4650
51+
::: moniker-end
52+
53+
<!--SQL Server 2019 on Linux-->
54+
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
55+
56+
You must have a Ubuntu 18.04 machine with **at least 2 GB** of memory.
57+
58+
To install Ubuntu 18.04 on your own machine, go to [http://releases.ubuntu.com/xenial/](http://releases.ubuntu.com/xenial/). You can also create Ubuntu virtual machines in Azure. See [Create and Manage Linux VMs with the Azure CLI](https://docs.microsoft.com/azure/virtual-machines/linux/tutorial-manage-vm).
59+
60+
> [!NOTE]
61+
> At this time, the [Windows Subsystem for Linux](https://msdn.microsoft.com/commandline/wsl/about) for Windows 10 is not supported as an installation target.
62+
63+
For other system requirements, see [System requirements for SQL Server on Linux](sql-server-linux-setup.md#system).
64+
65+
::: moniker-end
66+
4767
<!--SQL Server 2017 on Linux-->
4868
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
4969

@@ -100,6 +120,7 @@ To configure SQL Server on Ubuntu, run the following commands in a terminal to i
100120
At this point, SQL Server is running on your Ubuntu machine and is ready to use!
101121

102122
::: moniker-end
123+
103124
<!--SQL Server 2019 on Linux-->
104125
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
105126

@@ -116,7 +137,7 @@ To configure SQL Server on Ubuntu, run the following commands in a terminal to i
116137
2. Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019:
117138

118139
```bash
119-
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list)"
140+
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"
120141
```
121142

122143
3. Run the following commands to install SQL Server:
@@ -149,6 +170,9 @@ At this point, SQL Server 2019 is running on your Ubuntu machine and is ready to
149170

150171
## <a id="tools"></a>Install the SQL Server command-line tools
151172

173+
<!--SQL Server 2017 on Linux-->
174+
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
175+
152176
To create a database, you need to connect with a tool that can run Transact-SQL statements on the SQL Server. The following steps install the SQL Server command-line tools: [sqlcmd](../tools/sqlcmd-utility.md) and [bcp](../tools/bcp-utility.md).
153177

154178
Use the following steps to install the **mssql-tools** on Ubuntu.
@@ -194,4 +218,56 @@ Use the following steps to install the **mssql-tools** on Ubuntu.
194218
source ~/.bashrc
195219
```
196220
221+
::: moniker-end
222+
223+
<!--SQL Server 2019 on Linux-->
224+
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
225+
226+
To create a database, you need to connect with a tool that can run Transact-SQL statements on the SQL Server. The following steps install the SQL Server command-line tools: [sqlcmd](../tools/sqlcmd-utility.md) and [bcp](../tools/bcp-utility.md).
227+
228+
Use the following steps to install the **mssql-tools** on Ubuntu.
229+
230+
1. Import the public repository GPG keys.
231+
232+
```bash
233+
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
234+
```
235+
236+
1. Register the Microsoft Ubuntu repository.
237+
238+
```bash
239+
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
240+
```
241+
242+
1. Update the sources list and run the installation command with the unixODBC developer package.
243+
244+
```bash
245+
sudo apt-get update
246+
sudo apt-get install mssql-tools unixodbc-dev
247+
```
248+
249+
> [!Note]
250+
> To update to the latest version of **mssql-tools** run the following commands:
251+
> ```bash
252+
> sudo apt-get update
253+
> sudo apt-get install mssql-tools
254+
> ```
255+
256+
1. **Optional**: Add `/opt/mssql-tools/bin/` to your **PATH** environment variable in a bash shell.
257+
258+
To make **sqlcmd/bcp** accessible from the bash shell for login sessions, modify your **PATH** in the **~/.bash_profile** file with the following command:
259+
260+
```bash
261+
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
262+
```
263+
264+
To make **sqlcmd/bcp** accessible from the bash shell for interactive/non-login sessions, modify the **PATH** in the **~/.bashrc** file with the following command:
265+
266+
```bash
267+
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
268+
source ~/.bashrc
269+
```
270+
271+
::: moniker-end
272+
197273
[!INCLUDE [Connect, create, and query data](../includes/sql-linux-quickstart-connect-query.md)]

‎docs/linux/sql-server-linux-change-repo.md‎

Lines changed: 10 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: Configure Linux repositories for SQL Server 2017 and 2019
33
description: Check and configure source repositories for SQL Server 2019 and SQL Server 2017 on Linux. The source repository affects the version of SQL Server that is applied during installation and upgrade.
44
author: VanMSFT
55
ms.author: vanto
6-
ms.date: 01/07/2020
6+
ms.date: 03/12/2020
77
ms.topic: conceptual
88
ms.prod: sql
99
ms.technology: linux
@@ -154,8 +154,8 @@ If necessary, remove the old repository. Use one of the following commands based
154154
| Repository | Command to remove |
155155
|---|---|
156156
| **Preview (2019)** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-preview xenial main'` |
157-
| **2019 CU** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-2019 xenial main'` |
158-
| **2019 GDR** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-2019-gdr xenial main'` |
157+
| **2019 CU** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019 xenial main'` |
158+
| **2019 GDR** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/18.04/mssql-server-2019-gdr xenial main'` |
159159
| **2017 CU** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-2017 xenial main'` |
160160
| **2017 GDR** | `sudo add-apt-repository -r 'deb [arch=amd64] https://packages.microsoft.com/ubuntu/16.04/mssql-server-2017-gdr xenial main'` |
161161

@@ -198,6 +198,11 @@ Configure the new repository to use for SQL Server installations and upgrades. U
198198
::: zone pivot="ld2-ubuntu"
199199
Configure the new repository to use for SQL Server installations and upgrades.
200200

201+
> [!NOTE]
202+
> Starting with SQL Server 2019 CU3, Ubuntu 18.04 is supported. The following commands for SQL Server 2019 points to the Ubuntu 18.04 repository.
203+
>
204+
> If you are using Ubuntu 16.04, change the path below to `/ubuntu/16.04` instead of `/ubuntu/18.04`.
205+
201206
1. Import the public repository GPG keys.
202207

203208
```bash
@@ -208,8 +213,8 @@ Configure the new repository to use for SQL Server installations and upgrades.
208213

209214
| Repository | Version | Command |
210215
|---|---|---|
211-
| **2019 CU** | 2019 | `sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list)"` |
212-
| **2019 GDR** | 2019 | `sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019-gdr.list)"` |
216+
| **2019 CU** | 2019 | `sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"` |
217+
| **2019 GDR** | 2019 | `sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019-gdr.list)"` |
213218
| **2017 CU** | 2017 | `sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"` |
214219
| **2017 GDR** | 2017 | `sudo add-apt-repository "$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017-gdr.list)"` |
215220

0 commit comments

Comments
 (0)