microsoft/mssql-tools repository overview

⁠Featured Tags

docker pull mcr.microsoft.com/mssql-tools

• latest (dockerfile⁠)

⁠About this Image

Official image for Microsoft SQL Server command line tools (sqlcmd/bcp) in a Linux container.

⁠How to Use this Image

Pull the Docker image: docker pull mcr.microsoft.com/mssql-tools

Run a container in interactive mode: docker run -it mcr.microsoft.com/mssql-tools

Try out sqlcmd/bcp: root@1396d2e50672:/# sqlcmd

Microsoft (R) SQL Server Command Line Tool Version 13.1.0007.0 Linux Copyright (c) 2012 Microsoft. All rights reserved.

usage: sqlcmd [-U login id] [-P password] [-S server or Dsn if -D is provided] [-H hostname] [-E trusted connection] [-N Encrypt Connection][-C Trust Server Certificate] [-d use database name] [-l login timeout] [-t query timeout] [-h headers] [-s colseparator] [-w screen width] [-a packetsize] [-e echo input] [-I Enable Quoted Identifiers] [-c cmdend] [-q "cmdline query"] [-Q "cmdline query" and exit] [-m errorlevel] [-V severitylevel] [-W remove trailing spaces] [-u unicode output] [-r[0|1] msgs to stderr] [-i inputfile] [-o outputfile] [-k[1|2] remove[replace] control characters] [-y variable length type display width] [-Y fixed length type display width] [-p[1] print statistics[colon format]] [-R use client regional setting] [-K application intent] [-M multisubnet failover] [-b On error batch abort] [-D Dsn flag, indicate -S is Dsn] [-X[1] disable commands, startup script, environment variables [and exit]] [-x disable variable substitution] [-? show syntax summary]

Example: # sqlcmd -S 127.0.0.1 -U sa -P MyPassword100 > select @@version > go

#Related Microsoft SQL Server docker images SQL Server for Linux Containers: microsoft/mssql-server-linux⁠ SQL Server Developer Edition for Windows Containers: microsoft/mssql-server-windows-developer⁠ SQL Server Express Edition for Windows Containers: microsoft/mssql-server-windows-express⁠

#Dockerfile Check out the Dockerfile⁠ on GitHub. Help us maintain/extend it by sending in your pull requests.

#Support For support or general questions, please post in our Uservoice forum⁠.

#User feedback To learn more about sqlcmd and bcp, check out sqlcmd⁠ bcp⁠

For issues with or questions about this image, please contact us through a GitHub issue.

#License By using this Docker image, I confirm that I agree to the SQL Server Command Line Utilities license terms located here⁠.

⁠Full Tag Listing

You can retrieve a list of all available tags for mssql/tools at https://mcr.microsoft.com/v2/mssql/tools/tags/list⁠

⁠Support

For more information, go to https://support.microsoft.com/⁠

⁠License

• Legal Notice: Container License Information⁠