An all-in-one monitoring solution, that helps IT & DevOps break down the complexity between their IT infrastructure, customers & businesses.

  • You can also connect to the SQL Server instance on your Docker machine from any external Linux, Windows, or macOS tool that supports SQL connections. The following steps use sqlcmd outside of your container to connect to SQL Server running in the container.
  • SQL Server 2017 in a Docker Container running on a Mac – Tips and Tricks Posted on February 22, 2018 by AnupWarrier I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017 running on a docker container, and run it locally within the Mac.
  • In this quickstart, you use Docker to pull and run the SQL Server 2017 container image, mssql-server-linux. Then connect with sqlcmd to create your first database and run queries. In this quickstart, you use Docker to pull and run the SQL Server 2019 container image, mssql-server. Then connect with.
  • Jul 16, 2019  Launching our SQL Server container. To launch our SQL Server container, we are going to first create a docker-compose.yml file in the root of our project. Inside of that file, we are going to define a sql-server-db resource that uses the SQL Server 2017 image that Microsoft provides. Here is what our docker-compose.yml file looks like.

This Dockerfile helps developers to get started using SQL Server vNext in Windows Containers. The file downloads and installs SQL Server vNext with the default setup parameters.

Contents

About this sample
Before you begin
Run this sample
Sample details
Disclaimers
Related links

About this sample

  1. Applies to: SQL Server vNext, Windows Server 2016, Windows 10
  2. Authors: Perry Skountrianos [perrysk-msft]

Before you begin

To run this sample, you need the following prerequisites.

Software prerequisites:

You can run the container with the following command.(Note the you'll need Windows Server 2016 or Windows 10)

Microsoft Sql Server Docker Image

  • -p HostPort:containerPort is for port-mapping a container network port to a host port.

  • -v HostPath:containerPath is for mounting a folder from the host inside the container.

    This can be used for saving database outside of the container.

  • -it can be used to show the verbose output of the SQL startup script.

    Use this to debug the container in case of issues.

Run this sample

The image provides two environment variables to optionally set:

  • accept_eula: Confirms acceptance of the end user licensing agreement found here

  • sa_password: Sets the sa password and enables the sa login

  • attach_dbs: The configuration for attaching custom DBs (.mdf, .ldf files).

    This should be a JSON string, in the following format (note the use of SINGLE quotes!)

    This is an array of databases, which can have zero to N databases.

    Each consisting of:

    • dbName: The name of the database

    • dbFiles: An array of one or many absolute paths to the .MDF and .LDF files.

      Note:The path has double backslashes for escaping!The path refers to files within the container. So make sure to include them in the image or mount them via -v!

This example shows all parameters in action:

Sample details

The Dockerfile downloads and installs SQL Server 2016 Express with the following default setup parameters that could be changed (if needed) after the image is installed.

Sep 25, 2017  The issue is with Microsoft's software which does not have the right access permissions set up on Mac OS X. Microsoft has to update their software for this set of devices and make it compatible with Mac OS X El Captain (10.11.1) in order for the Sculpt ergonomic desktop set to work. Microsoft sculpt mouse driver windows 10.

Microsoft Sql Server For Mac

  • Collation: SQL_Latin1_General_CP1_CI_AS
  • SQL Instance Name: SQLEXPRESS
  • Root Directory: C:Program FilesMicrosoft SQL ServerMSSQL12.SQLEXPRESSMSSQL
  • Language: English (United Stated)

Disclaimers

The code included in this sample is not intended to be a set of best practices on how to build scalable enterprise grade applications. This is beyond the scope of this quick start sample.

Related Links

For more information, see these articles:

-->

APPLIES TO: SQL Server (Linux only) Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

This tutorial demonstrates how to move and restore a SQL Server backup file into a SQL Server 2017 Linux container image running on Docker.

This tutorial demonstrates how to move and restore a SQL Server backup file into a SQL Server 2019 Linux container image running on Docker.

  • Pull and run the latest SQL Server Linux container image.
  • Copy the Wide World Importers database file into the container.
  • Restore the database in the container.
  • Run Transact-SQL statements to view and modify the database.
  • Backup the modified database.

Prerequisites

  • Docker Engine 1.8+ on any supported Linux distribution or Docker for Mac/Windows. For more information, see Install Docker.
  • Minimum of 2 GB of disk space
  • Minimum of 2 GB of RAM
  • System requirements for SQL Server on Linux.

Pull and run the container image

  1. Open a bash terminal on Linux/Mac or an elevated PowerShell session on Windows.

  2. Pull the SQL Server 2017 Linux container image from Docker Hub.

    Tip

    Throughout this tutorial, docker command examples are given for both the bash shell (Linux/Mac) and PowerShell (Windows).

  3. To run the container image with Docker, you can use the following command:

    This command creates a SQL Server 2017 container with the Developer edition (default). SQL Server port 1433 is exposed on the host as port 1401. The optional -v sql1data:/var/opt/mssql parameter creates a data volume container named sql1ddata. This is used to persist the data created by SQL Server.

    Important

    This example uses a data volume container within Docker. If you instead chose to map a host directory, note that there are limitations for this approach on Docker for Mac and Windows. For more information, see Configure SQL Server container images on Docker.

  4. To view your Docker containers, use the docker ps command.

  5. If the STATUS column shows a status of Up, then SQL Server is running in the container and listening on the port specified in the PORTS column. If the STATUS column for your SQL Server container shows Exited, see the Troubleshooting section of the configuration guide.

  1. Open a bash terminal on Linux/Mac or an elevated PowerShell session on Windows.

  2. Pull the SQL Server 2019 Linux container image from Docker Hub.

    Tip

    Throughout this tutorial, docker command examples are given for both the bash shell (Linux/Mac) and PowerShell (Windows).

  3. To run the container image with Docker, you can use the following command:

    This command creates a SQL Server 2019 container with the Developer edition (default). SQL Server port 1433 is exposed on the host as port 1401. The optional -v sql1data:/var/opt/mssql parameter creates a data volume container named sql1ddata. This is used to persist the data created by SQL Server.

  4. To view your Docker containers, use the docker ps command.

  5. If the STATUS column shows a status of Up, then SQL Server is running in the container and listening on the port specified in the PORTS column. If the STATUS column for your SQL Server container shows Exited, see the Troubleshooting section of the configuration guide.

Change the SA password

The SA account is a system administrator on the SQL Server instance that's created during setup. After you create your SQL Server container, the MSSQL_SA_PASSWORD environment variable you specified is discoverable by running echo $MSSQL_SA_PASSWORD in the container. For security purposes, change your SA password:

  1. Choose a strong password to use for the SA user.

  2. Use docker exec to run the sqlcmd utility to change the password through a Transact-SQL statement. Replace <YourStrong!Passw0rd> and <YourNewStrong!Passw0rd> with your own password values:

Copy a backup file into the container

This tutorial uses the Wide World Importers sample database. Use the following steps to download and copy the Wide World Importers database backup file into your SQL Server container.

  1. First, use docker exec to create a backup folder. The following command creates a /var/opt/mssql/backup directory inside the SQL Server container.

  2. Next, download the WideWorldImporters-Full.bak file to your host machine. The following commands navigate to the home/user directory and downloads the backup file as wwi.bak.

  3. Use docker cp to copy the backup file into the container in the /var/opt/mssql/backup directory.

    Seamless Outlook calendar integration. Microsoft teams outlook add in mac.

Restore the database

Microsoft Sql Server Mac Docker 10

The backup file is now located inside the container. Before restoring the backup, it is important to know the logical file names and file types inside the backup. The following Transact-SQL commands inspect the backup and perform the restore using sqlcmd in the container.

Tip

Docker Sql Server Mac

This tutorial uses sqlcmd inside the container, because the container comes with this tool pre-installed. However, you can also run Transact-SQL statements with other client tools outside of the container, such as Visual Studio Code or SQL Server Management Studio. To connect, use the host port that was mapped to port 1433 in the container. In this example, that is localhost,1401 on the host machine and Host_IP_Address,1401 remotely.

  1. Run sqlcmd inside the container to list out logical file names and paths inside the backup. This is done with the RESTORE FILELISTONLY Transact-SQL statement.

    You should see output similar to the following:

  2. Call the RESTORE DATABASE command to restore the database inside the container. Specify new paths for each of the files in the previous step.

    You should see output similar to the following:

Verify the restored database

Run the following query to display a list of database names in your container:

You should see WideWorldImporters in the list of databases.

Make a change

The following steps make a change in the database.

Microsoft Sql Server Mac Docker Version

  1. Run a query to view the top 10 items in the Warehouse.StockItems table.

    You should see a list of item identifiers and names:

  2. Update the description of the first item with the following UPDATE statement:

    You should see output similar to the following text:

Create a new backup

After you've restored your database into a container, you might also want to regularly create database backups inside the running container. The steps follow a similar pattern to the previous steps but in reverse.

  1. Use the BACKUP DATABASE Transact-SQL command to create a database backup in the container. This tutorial creates a new backup file, wwi_2.bak, in the previously created /var/opt/mssql/backup directory.

    You should see output similar to the following:

  2. Next, copy the backup file out of the container and onto your host machine.

Use the persisted data

In addition to taking database backups for protecting your data, you can also use data volume containers. The beginning of this tutorial created the sql1 container with the -v sql1data:/var/opt/mssql parameter. The sql1data data volume container persists the /var/opt/mssql data even after the container is removed. The following steps completely remove the sql1 container and then create a new container, sql2, with the persisted data.

  1. Stop the sql1 container.

  2. Remove the container. This does not delete the previously created sql1data data volume container and the persisted data in it.

  3. Create a new container, sql2, and reuse the sql1data data volume container.

  4. The Wide World Importers database is now in the new container. Run a query to verify the previous change you made.

    Note

    The SA password is not the password you specified for the sql2 container, MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>. All of the SQL Server data was restored from sql1, including the changed password from earlier in the tutorial. In effect, some options like this are ignored due to restoring the data in /var/opt/mssql. For this reason, the password is <YourNewStrong!Passw0rd> as shown here.

  1. Stop the sql1 container.

  2. Remove the container. This does not delete the previously created sql1data data volume container and the persisted data in it.

  3. Create a new container, sql2, and reuse the sql1data data volume container.

  4. The Wide World Importers database is now in the new container. Run a query to verify the previous change you made.

    Note

    The SA password is not the password you specified for the sql2 container, MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>. All of the SQL Server data was restored from sql1, including the changed password from earlier in the tutorial. In effect, some options like this are ignored due to restoring the data in /var/opt/mssql. For this reason, the password is <YourNewStrong!Passw0rd> as shown here.

Next steps

In this tutorial, you learned how to back up a database on Windows and move it to a Linux server running SQL Server 2017. You learned how to:

In this tutorial, you learned how to back up a database on Windows and move it to a Linux server running SQL Server 2019. You learned how to:

  • Create SQL Server Linux container images.
  • Copy SQL Server database backups into a container.
  • Run Transact-SQL statements inside the container with sqlcmd.
  • Create and extract backup files from a container.
  • Use data volume containers in Docker to persist SQL Server data.

Next, review other Docker configuration and troubleshooting scenarios: