Microsoft SQL Server command line tools (sqlcmd/bcp) in a Linux container.
86
docker pull mcr.microsoft.com/mssql-tools
Official image for Microsoft SQL Server command line tools (sqlcmd/bcp) in a Linux container.
Pull the Docker image: docker pull adordm/microsoft-sql-server-tools
Run a container in interactive mode: docker run -it adordm/microsoft-sql-server-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
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
Check out the Dockerfile on GitHub. Help us maintain/extend it by sending in your pull requests.
For support or general questions, please post in our Uservoice forum.
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.
By using this Docker image, I confirm that I agree to the SQL Server Command Line Utilities license terms located here.
Content type
Image
Digest
Size
93.3 MB
Last updated
about 7 years ago
docker pull adordm/microsoft-sql-server-tools:v1