Skip to content

Commit c1e1f8a

Browse files
rothjarothja
committed
Replacing SQL Server 2017 wiih SQL Server where applicable
1 parent a6fae53 commit c1e1f8a

21 files changed

Lines changed: 93 additions & 54 deletions

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

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
2-
title: Get started with SQL Server 2017 in the Cloud | Microsoft Docs
3-
description: This quickstart shows how to run the SQL Server 2017 on Linux in the cloud of your choice.
2+
title: Get started with SQL Server in the Cloud | Microsoft Docs
3+
description: This quickstart shows how to run the SQL Server on Linux in the cloud of your choice.
44
author: annashres
55
ms.author: annashres
66
manager: craigg
@@ -12,11 +12,11 @@ ms.custom: "sql-linux"
1212
ms.technology: linux
1313
ms.assetid:
1414
---
15-
# Quickstart: Run the SQL Server 2017 in the cloud
15+
# Quickstart: Run the SQL Server in the cloud
1616

1717
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-linuxonly](../includes/appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md)]
1818

19-
In this quickstart, you will install SQL Server 2017 on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), or Ubuntu in the cloud of your choice. Go to [Provision a Linux SQL Server virtual machine in the Azure portal](https://docs.microsoft.com/azure/virtual-machines/linux/sql/provision-sql-server-linux-virtual-machine?toc=%2fsql%2flinux%2ftoc.json) to run SQL Server on Linux in Azure.
19+
In this quickstart, you will install SQL Server on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), or Ubuntu in the cloud of your choice. Go to [Provision a Linux SQL Server virtual machine in the Azure portal](https://docs.microsoft.com/azure/virtual-machines/linux/sql/provision-sql-server-linux-virtual-machine?toc=%2fsql%2flinux%2ftoc.json) to run SQL Server on Linux in Azure.
2020

2121
> [!NOTE]
2222
> If you choose to run a paid edition of SQL Server then you need to bring your own license (BYOL)

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

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -331,7 +331,7 @@ Other common tools to connect to SQL Server include:
331331

332332
- [Visual Studio Code](sql-server-linux-develop-use-vscode.md)
333333
- [SQL Server Management Studio (SSMS) on Windows](sql-server-linux-manage-ssms.md)
334-
- [SQL Server Operations Studio (Preview)](../sql-operations-studio/what-is.md)
334+
- [Azure Data Studio (Preview)](../azure-data-studio/what-is.md)
335335
- [mssql-cli (Preview)](https://blogs.technet.microsoft.com/dataplatforminsider/2017/12/12/try-mssql-cli-a-new-interactive-command-line-tool-for-sql-server/)
336336

337337
## Remove your container

‎docs/linux/sql-server-linux-configure-environment-variables.md‎

Lines changed: 40 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -17,8 +17,19 @@ ms.assetid:
1717

1818
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-linuxonly](../includes/appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md)]
1919

20+
<!--SQL Server 2017 on Linux-->
21+
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
22+
2023
You can use several different environment variables to configure SQL Server 2017 on Linux. These variables are used in two scenarios:
2124

25+
::: moniker-end
26+
<!--SQL Server 2019 on Linux-->
27+
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
28+
29+
You can use several different environment variables to configure SQL Server 2019 CTP 2.0 on Linux. These variables are used in two scenarios:
30+
31+
::: moniker-end
32+
2233
- To configure initial setup with the `mssql-conf setup` command.
2334
- To configure a new [SQL Server container in Docker](quickstart-install-connect-docker.md).
2435

@@ -27,6 +38,33 @@ You can use several different environment variables to configure SQL Server 2017
2738
2839
## Environment variables
2940

41+
<!--SQL Server 2017 on Linux-->
42+
::: moniker range="= sql-server-linux-2017 || = sql-server-2017"
43+
44+
| Environment variable | Description |
45+
|-----|-----|
46+
| **ACCEPT_EULA** | Accept the SQL Server license agreement when set to any value (for example, 'Y'). |
47+
| **MSSQL_SA_PASSWORD** | Configure the SA user password. |
48+
| **MSSQL_PID** | Set the SQL Server edition or product key. Possible values include: </br></br>**Evaluation**</br>**Developer**</br>**Express**</br>**Web**</br>**Standard**</br>**Enterprise**</br>**A product key**</br></br>If specifying a product key, it must be in the form of #####-#####-#####-#####-#####, where '#' is a number or a letter.|
49+
| **MSSQL_LCID** | Sets the language ID to use for SQL Server. For example 1036 is French. |
50+
| **MSSQL_COLLATION** | Sets the default collation for SQL Server. This overrides the default mapping of language id (LCID) to collation. |
51+
| **MSSQL_MEMORY_LIMIT_MB** | Sets the maximum amount of memory (in MB) that SQL Server can use. By default it is 80% of the total physical memory. |
52+
| **MSSQL_TCP_PORT** | Configure the TCP port that SQL Server listens on (default 1433). |
53+
| **MSSQL_IP_ADDRESS** | Set the IP address. Currently, the IP address must be IPv4 style (0.0.0.0). |
54+
| **MSSQL_BACKUP_DIR** | Set the Default backup directory location. |
55+
| **MSSQL_DATA_DIR** | Change the directory where the new SQL Server database data files (.mdf) are created. |
56+
| **MSSQL_LOG_DIR** | Change the directory where the new SQL Server database log (.ldf) files are created. |
57+
| **MSSQL_DUMP_DIR** | Change the directory where SQL Server will deposit the memory dumps and other troubleshooting files by default. |
58+
| **MSSQL_ENABLE_HADR** | Enable Availability Group. For example, '1' is enabled, and '0' is disabled |
59+
| **MSSQL_AGENT_ENABLED** | Enable SQL Server Agent. For example, 'true' is enabled and 'false' is disabled. By default, agent is disabled. |
60+
| **MSSQL_MASTER_DATA_FILE** | Sets the location of the master database data file. |
61+
| **MSSQL_MASTER_LOG_FILE** | Sets the location of the master database log file. |
62+
| **MSSQL_ERROR_LOG_FILE** | Sets the location of the errorlog files. |
63+
64+
::: moniker-end
65+
<!--SQL Server 2019 on Linux-->
66+
::: moniker range=">= sql-server-linux-ver15 || >= sql-server-ver15 || =sqlallproducts-allversions"
67+
3068
| Environment variable | Description |
3169
|-----|-----|
3270
| **ACCEPT_EULA** | Accept the SQL Server license agreement when set to any value (for example, 'Y'). |
@@ -47,6 +85,7 @@ You can use several different environment variables to configure SQL Server 2017
4785
| **MSSQL_MASTER_LOG_FILE** | Sets the location of the master database log file. |
4886
| **MSSQL_ERROR_LOG_FILE** | Sets the location of the errorlog files. |
4987

88+
::: moniker-end
5089

5190
## Example: initial setup
5291

@@ -63,7 +102,7 @@ sudo ACCEPT_EULA='Y' MSSQL_PID='Developer' MSSQL_SA_PASSWORD='<YourStrong!Passw0
63102

64103
## Example: Docker
65104

66-
This example docker command uses the following environment variables to create a new SQL Server 2017 container:
105+
This example docker command uses the following environment variables to create a new SQL Server container:
67106

68107
- **ACCEPT_EULA** accepts the end user license agreement.
69108
- **MSSSQL_PID** specifies the freely licensed Developer Edition of SQL Server for non-production use.

‎docs/linux/sql-server-linux-develop-overview.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ ms.assetid: 758cb738-b018-465b-9ab0-59a24b892e66
1717

1818
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-linuxonly](../includes/appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md)]
1919

20-
You can create applications that connect to and use SQL Server 2017 on Linux from a variety of programming languages, such as C#, Java, Node.js, PHP, Python, Ruby, and C++. You can also use popular web frameworks and Object Relational Mapping (ORM) frameworks.
20+
You can create applications that connect to and use SQL Server on Linux from a variety of programming languages, such as C#, Java, Node.js, PHP, Python, Ruby, and C++. You can also use popular web frameworks and Object Relational Mapping (ORM) frameworks.
2121

2222
> [!VIDEO https://channel9.msdn.com/events/Connect/2017/T153/player]
2323
@@ -33,19 +33,19 @@ The best way to get started and build applications with SQL Server is to try it
3333
- Try the code samples.
3434

3535
> [!TIP]
36-
> If you want to develop for SQL Server 2017 on Docker, take a look at the **macOS** tutorials.
36+
> If you want to develop for SQL Server on Docker, take a look at the **macOS** tutorials.
3737
3838
## Create new applications
3939

4040
If you're creating a new application, take a look at a list of the [Connectivity libraries](sql-server-linux-develop-connectivity-libraries.md) for a summary of the connectors and popular frameworks available for various programming languages.
4141

4242
## Use existing applications
4343

44-
If you have an existing database application, you can simply change its connection string to target SQL Server 2017 on Linux. Make sure to read about the [Known Issues](sql-server-linux-release-notes.md) in SQL Server 2017 on Linux.
44+
If you have an existing database application, you can simply change its connection string to target SQL Server on Linux. Make sure to read about the [Known Issues](sql-server-linux-release-notes.md) in SQL Server on Linux.
4545

4646
## Use existing SQL tools on Windows with SQL Server on Linux
4747

48-
Tools that currently run on Windows such as SSMS, SSDT, and PowerShell, also work with SQL Server 2017 on Linux. Although they do not run natively on Linux, you can still manage remote SQL Server instances on Linux.
48+
Tools that currently run on Windows such as SSMS, SSDT, and PowerShell, also work with SQL Server on Linux. Although they do not run natively on Linux, you can still manage remote SQL Server instances on Linux.
4949

5050
See the following topics for more information:
5151

‎docs/linux/sql-server-linux-develop-use-ssdt.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -34,7 +34,7 @@ SQL Server Data Tools (SSDT) turns Visual Studio into a powerful development and
3434

3535
## Upgrade SQL Server Data Tools to SSDT 17.0 RC release
3636

37-
SQL Server 2017 on Linux is supported by SSDT version 17.0 RC or later.
37+
SQL Server on Linux is supported by SSDT version 17.0 RC or later.
3838

3939
* [Download and Install SSDT 17.0 RC2](https://go.microsoft.com/fwlink/?linkid=837939).
4040

@@ -74,13 +74,13 @@ SQL Server 2017 on Linux is supported by SSDT version 17.0 RC or later.
7474

7575
## Build and validate the database
7676

77-
1. Open the database project menu on **TutorialDB** and select **Build**. SSDT compiles .sql source code files in your project and builds a Data-tier Application package (dacpac) file. This can be used to publish a database to your SQL Server 2017 instance on Linux.
77+
1. Open the database project menu on **TutorialDB** and select **Build**. SSDT compiles .sql source code files in your project and builds a Data-tier Application package (dacpac) file. This can be used to publish a database to your SQL Server instance on Linux.
7878

7979
<img src="./media/sql-server-linux-develop-use-ssdt/build.png" alt="add columns" style="width: 400px;"/>
8080

8181
2. Check the build success message in **Output** window in Visual Studio.
8282

83-
## Publish the database to SQL Server 2017 instance on Linux
83+
## Publish the database to SQL Server instance on Linux
8484

8585
1. Open the database project menu on **TutorialDB** and select **Publish**.
8686

‎docs/linux/sql-server-linux-faq.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -55,7 +55,7 @@ The following sections provide common questions and answers for SQL Server runni
5555

5656
No. Linux running on Windows 10 is currently not a supported platform for SQL Server and related tools.
5757

58-
1. **Which Linux file systems can SQL Server 2017 use for data files?**
58+
1. **Which Linux file systems can SQL Server use for data files?**
5959

6060
Currently SQL Server on Linux supports ext4 and XFS. Support for other file systems will be added as needed in the future.
6161

@@ -120,7 +120,7 @@ The following sections provide common questions and answers for SQL Server runni
120120

121121
1. **Can I migrate my data from Oracle and other database engines to SQL Server on Linux?**
122122

123-
Yes. SSMA supports migration from several types of database engines: Microsoft Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE). For an example of how to use SSMA, see [Migrate an Oracle schema to SQL Server 2017 on Linux with the SQL Server Migration Assistant](../ssma/oracle/sql-server-linux-convert-from-oracle.md?toc=%2fsql%2flinux%2ftoc.json).
123+
Yes. SSMA supports migration from several types of database engines: Microsoft Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE). For an example of how to use SSMA, see [Migrate an Oracle schema to SQL Server on Linux with the SQL Server Migration Assistant](../ssma/oracle/sql-server-linux-convert-from-oracle.md?toc=%2fsql%2flinux%2ftoc.json).
124124

125125
1. **What permissions are required for SQL Server files?**
126126

‎docs/linux/sql-server-linux-manage-powershell.md‎

Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -17,15 +17,15 @@ ms.assetid: a3492ce1-5d55-4505-983c-d6da8d1a94ad
1717

1818
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-linuxonly](../includes/appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md)]
1919

20-
This article introduces [SQL Server PowerShell](https://msdn.microsoft.com/library/mt740629.aspx) and walks you through a couple of examples on how to use it with SQL Server 2017 on Linux. PowerShell support for SQL Server is currently available on Windows, so you can use it when you have a Windows machine that can connect to a remote SQL Server instance on Linux.
20+
This article introduces [SQL Server PowerShell](https://msdn.microsoft.com/library/mt740629.aspx) and walks you through a couple of examples on how to use it with SQL Server on Linux. PowerShell support for SQL Server is currently available on Windows, so you can use it when you have a Windows machine that can connect to a remote SQL Server instance on Linux.
2121

2222
## Install the newest version of SQL PowerShell on Windows
2323

24-
[SQL PowerShell](https://msdn.microsoft.com/library/mt740629.aspx) on Windows is included with [SQL Server Management Studio (SSMS)](../ssms/sql-server-management-studio-ssms.md). When working with SQL Server, you should always use the most recent version of SSMS and SQL PowerShell. The latest version of SSMS is continually updated and optimized and currently works with SQL Server 2017 on Linux. To download and install the latest version, see [Download SQL Server Management Studio](../ssms/download-sql-server-management-studio-ssms.md). To stay up-to-date, the latest version of SSMS prompts you when there is a new version available to download.
24+
[SQL PowerShell](https://msdn.microsoft.com/library/mt740629.aspx) on Windows is included with [SQL Server Management Studio (SSMS)](../ssms/sql-server-management-studio-ssms.md). When working with SQL Server, you should always use the most recent version of SSMS and SQL PowerShell. The latest version of SSMS is continually updated and optimized and currently works with SQL Server on Linux. To download and install the latest version, see [Download SQL Server Management Studio](../ssms/download-sql-server-management-studio-ssms.md). To stay up-to-date, the latest version of SSMS prompts you when there is a new version available to download.
2525

2626
## Before you begin
2727

28-
Read the [Known Issues](sql-server-linux-release-notes.md) for SQL Server 2017 on Linux.
28+
Read the [Known Issues](sql-server-linux-release-notes.md) for SQL Server on Linux.
2929

3030
## Launch PowerShell and import the *sqlserver* module
3131

@@ -60,15 +60,15 @@ Manifest 20.0 SqlServer {Add-SqlAvailabilityDatabase, Add-SqlAvailab
6060

6161
## Connect to SQL Server and get server information
6262

63-
Let's use PowerShell on Windows to connect to your SQL Server 2017 instance on Linux and display a couple of server properties.
63+
Let's use PowerShell on Windows to connect to your SQL Server instance on Linux and display a couple of server properties.
6464

6565
Copy and paste the following commands at the PowerShell prompt. When you run these commands, PowerShell will:
66-
- Display the *Windows PowerShell credential request* dialog that prompts you for the credentials (*SQL username* and *SQL password*) to connect to your SQL Server 2017 instance on Linux
66+
- Display the *Windows PowerShell credential request* dialog that prompts you for the credentials (*SQL username* and *SQL password*) to connect to your SQL Server instance on Linux
6767
- Load the SQL Server Management Objects (SMO) assembly
6868
- Create an instance of the [Server](https://msdn.microsoft.com/library/microsoft.sqlserver.management.smo.server.aspx) object
6969
- Connect to the **Server** and display a few properties
7070

71-
Remember to replace **\<your_server_instance\>** with the IP address or the hostname of your SQL Server 2017 instance on Linux.
71+
Remember to replace **\<your_server_instance\>** with the IP address or the hostname of your SQL Server instance on Linux.
7272

7373
```powershell
7474
# Prompt for credentials to login into SQL Server
@@ -101,14 +101,14 @@ HostDistribution : Ubuntu
101101
102102
## Examine SQL Server error logs
103103

104-
Let's use PowerShell on Windows to examine error logs connect on your SQL Server 2017 instance on Linux. We will also use the **Out-GridView** cmdlet to show information from the error logs in a grid view display.
104+
Let's use PowerShell on Windows to examine error logs connect on your SQL Server instance on Linux. We will also use the **Out-GridView** cmdlet to show information from the error logs in a grid view display.
105105

106106
Copy and paste the following commands at the PowerShell prompt. They might take a few minutes to run. These commands do the following:
107-
- Display the *Windows PowerShell credential request* dialog that prompts you for the credentials (*SQL username* and *SQL password*) to connect to your SQL Server 2017 instance on Linux
108-
- Use the **Get-SqlErrorLog** cmdlet to connect to the SQL Server 2017 instance on Linux and retrieve error logs since **Yesterday**
107+
- Display the *Windows PowerShell credential request* dialog that prompts you for the credentials (*SQL username* and *SQL password*) to connect to your SQL Server instance on Linux
108+
- Use the **Get-SqlErrorLog** cmdlet to connect to the SQL Server instance on Linux and retrieve error logs since **Yesterday**
109109
- Pipe the output to the **Out-GridView** cmdlet
110110

111-
Remember to replace **\<your_server_instance\>** with the IP address or the hostname of your SQL Server 2017 instance on Linux.
111+
Remember to replace **\<your_server_instance\>** with the IP address or the hostname of your SQL Server instance on Linux.
112112

113113
```powershell
114114
# Prompt for credentials to login into SQL Server

0 commit comments

Comments
 (0)