SQL Server in Docker
This GitHub repository aims to provide a centralized location for community engagement. In here you will find documentation, Dockerfiles and additional developer resources.
SQL Server in Docker comes in two different flavors:
- Linux-based containers: This Docker image uses SQL Server 2017 Developer Edition on Linux on top of an Ubuntu 16.04 base image. This is meant to be run on Docker Engine on its multiple platforms. There are also Dockerfiles here for building RHEL & CentOS based images.
- Windows-based containers: These Docker images use SQL Server 2017 Express Edition and SQL Server 2017 Developer Edition. Both images are based on Windows Container technology and can only be run using Docker Engine for Windows Containers. You can currently sign-up for SQL Server 2019 on Windows Containers available in our Early Adopter Preview program.
Before choosing to run a SQL Server container for production use cases, please review our support policy for SQL Server Containers to ensure that you are running on a supported configuration.
SQL Server Command Line Tools(sqlcmd,bcp) are also available as a Docker Image. You can now deliver SQL Server management payload using this as a base image for your CI/CD scenarios. Check out the mssql-tools Docker Image to get started.
Visit the Microsoft Docker Hub page for more information and additional images.
Documentation
Take our survey
Let us know more about how you would like to use SQL containers by taking our survey.
Issues
For any issues with the repo, please file under this GitHub project on the Issues section.
If you require support with a production related issue, then please raise a support incident with Microsoft here.
There is also a Gitter channel for SQL Server in DevOps that you can join and discuss interesting topics with other container, SQL Server, and DevOps enthusiasts.
Troubleshooting & Frequently Asked Questions
"Unknown blob" error code: You are probably trying to run the Windows Containers-based Docker image on a Linux-based Docker Engine. If you want to continue running the Windows Container-based image, we recommend reading the following community article: Run Linux and Windows Containers on Windows 10.
When using the Windows Docker CLI you must use double quotes instead of single ticks for the environment variables, else the mssql-server-linux image won't find the
ACCEPT_EULAorSA_PASSWORDvariables which are required to start the container.The 'sa' password has a minimum complexity requirement (8 characters, uppercase, lowercase, alphanumerical and/or non-alphanumerical)
Licensing for SQL Server in Docker: Regardless of where you run it - VM, Docker, physical, cloud, on prem - the licensing model is the same and it depends on which edition of SQL Server you are using. The Express and Developer Editions are free. Standard and Enterprise have a cost. More information here: https://www.microsoft.com/en-us/sql-server/sql-server-2016-editions
License
The Docker resource files for SQL Server are licensed under the MIT license. See the LICENSE file for more details.
-
docker search mssql 查找mssql镜像 docker pull microsoft/mssql-server-linux 拉去mssql镜像 docker images 查看镜像 docker run -e ‘ACCEPT_EULA=Y‘ -e ‘SA_PASSWORD=Abcabc2020‘ --privileged=true -v D:\Docker\data\db:/ms
-
使用Docker快速搭建MSSQL实验环境（持久化） 前置章节 CentOS 快速安装Docker 使用Docker快速搭建MSSQL实验环境 拉取镜像 docker pull mcr.microsoft.com/mssql/server:2019-latest 准备持久化目录，准备挂在进目录卷的内容 mkdir -p mssql/sql1data cd mssql # docker creat
-
1、下载sqlserver镜像 sudo docker pull mcr.microsoft.com/mssql/server:2017-latest 2、创建挂载点目录 mkdir /etc/sqlserver_data 3、启动容器 sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=P@ssw0rd," \ -p 1433:1433 --na
-
一.搭建mssql数据库 1.使用docker搭建mssql docker run -d --name mssql -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=ydt123456_' -p 1433:1433 -v /docker/mssql:/var/opt/mssql --restart always mcr.microsoft.com/mssql/ser
-
使用Docker快速搭建MSSQL实验环境 前置章节 CentOS 快速安装Docker 1. 运行及配置 拉取镜像 docker pull mcr.microsoft.com/mssql/server:2019-latest 运行容器 docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=93i7f5^#Wpe98G6$" \ --restart=a
-
docker search mssql 查找mssql镜像 docker pull microsoft/mssql-server-linux 拉去mssql镜像 docker images 查看镜像 docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=SQLOnLinux123' --privileged=true -v /mnt/mssql/data -
-
正常使用docker运行 docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=sa@12345" -p 1433:1433 --name sql-server2019 -h sql-server2019 -d mcr.microsoft.com/mssql/server:2019-latest /n/n/n/n/n/n/n/n/n/n/n/n/n/n/n/
-
mssql-cli mssql-cli is an interactive command line query tool for SQL Server. This open source tool works cross-platform and proud to be a part of the dbcli community. mssql-cli supports a rich intera
-
问题内容： 我正在研究一个Web项目，该项目将部署在运行IIS 7.5和PHP 5.3.8的64位Windows 2008 Server计算机上。系统上的数据库是Microsoft SQL Server 2008 R2。我正在CodeIgniter 2.1.0框架上开发应用程序，但对于将其连接到SQL Server感到有些困惑。 我已经尝试过同时使用MSSQL，ODBC和SQLSRV数据库驱动程序
-
问题内容： 我有一个存储过程，该过程返回数据库中数据类型为datetime2以及Java文件中Date为数据的列。当我尝试在从数据库获取的时间上调用getTime（）时。它返回的19994321211毫秒等于IST 2015年5月4日星期一。理想情况下，它应该返回2015-05-04 15:21:52的毫秒，因为这是直接执行过程时数据库中显示的时间。 由于我是Hibernate的新手，所以我无法理
-
MSSQL Query Tool for Linux 是 Linux 下一个简单的 SQL Server 数据库管理工具。
-
本文向大家介绍PHP MSSQL 分页实例，包括了PHP MSSQL 分页实例的使用技巧和注意事项，需要的朋友参考一下 本文实例为大家分享了PHP MSSQL可刷新分页实例，具体内容如下 下面为大家分享了PHP+MSSQL通用分页公式，供大家参考，具体内容如下 以上就是本文的全部内容，希望对大家学习php程序设计有所帮助。
-
我正在将我的数据库从MSSQL迁移到MySQL。在版本8之前，MySQL不支持。我应该如何为下面的查询进行迁移。 部分应该可以在MySQL8+中开箱即用，但我目前使用的是5.7，最好的替代方案是什么？ 多谢了。