docker安装sqlserver

àì夳堔傛蜴生んèń 2022-10-09 00:43 217阅读 0赞

1.查看镜像源

  1. docker search mssql
  3. NAME                                                  DESCRIPTION                                     STARS               OFFICIAL            AUTOMATED
  4. microsoft/mssql-server-linux                          Deprecated SQL Server on Linux Container Rep…   1240                                    
  5. microsoft/mssql-server-windows-developer              Official Microsoft SQL Server Developer Edit…   467                                     
  6. microsoft/mssql-server-windows-express                Official Microsoft SQL Server Express Editio…   383                                     
  7. microsoft/mssql-tools                                 Official images for Microsoft SQL Server Com…   51                                      
  8. rsmoorthy/mssql                                       MSSQL Database (version SQL2000)                13                                      [OK]
  9. datagrip/mssql-server-linux                           SQL Server and SQL Server tools on Linux(201…   11                                      [OK]
  10. bitwarden/mssql                                       The Bitwarden database.                         9                                       
  11. mcmoe/mssqldocker                                     Builds on microsoft/mssql-server-linux and a…   5                                       [OK]
  12. gantrior/mssql-server-2014-express-windows-with-iis   mssql 2014 + IIS                                5                                       
  13. liaisonintl/mssql-server-linux                        mssql-server-linux                              4                                       [OK]
  14. microsoft/mssql-monitoring-influxdb                   Sample Image for Influxdb, This image is des…   3                                       
  15. tsgkadot/mssql-tools                                  SQL Server tools on Linux (sqlcmd)              3                                       [OK]
  16. ansibleplaybookbundle/mssql-apb                       MS SQL Server on Linux (APB)                    2                                       [OK]
  17. ansibleplaybookbundle/mssql-remote-apb                An APB that deploys Microsoft SQL Server        1                                       [OK]
  18. christianacca/mssql-server-windows-express            Fork of official microsoft/mssql-server-wind…   1                                       
  19. microsoft/mssql-monitoring-collectd                   This Sample image is designed to work with t…   1                                       
  20. sammiechan/mssqlubuntuwithfulltextsearch              MSSQL Ubuntu Docker Image with Full-Text Sea…   0                                       
  21. octopusdeploy/mssql-server-windows-express            Fork of official microsoft/mssql-server-wind…   0                                       
  22. tchughesiv/mssql-server-linux                         CentOS build                                    0                                       [OK]
  23. iconviet/mssql                                                                                        0                                       
  24. softwareplant/mssql                                   SQL Server test database                        0                                       [OK]
  25. uwthalesians/mssql                                    Mssql Database Server for Perceptia             0                                       
  26. danieloliver/mssql_exporter                           MSSQL Exporter for Prometheus                   0                                       
  27. hdemirkale/mssql                                                                                      0                                       
  28. agiper/mssql

2.拉取镜像

  1. docker pull microsoft/mssql-server-linux
  3. Using default tag: latest
  4. latest: Pulling from microsoft/mssql-server-linux
  5. 59ab41dd721a: Pull complete 
  6. 57da90bec92c: Pull complete 
  7. 06fe57530625: Pull complete 
  8. 5a6315cba1ff: Pull complete 
  9. 739f58768b3f: Pull complete 
  10. 0b751601bca3: Pull complete 
  11. bcf04a22644a: Pull complete 
  12. 6b5009e4f470: Pull complete 
  13. a9dca2f6722a: Pull complete 
  14. Digest: sha256:9b700672670bb3db4b212e8aef841ca79eb2fce7d5975a5ce35b7129a9b90ec0
  15. Status: Downloaded newer image for microsoft/mssql-server-linux:latest
  16. docker.io/microsoft/mssql-server-linux:latest
  18. docker images
  20. REPOSITORY                     TAG                 IMAGE ID            CREATED             SIZE
  21. feisky/app                     mem-leak-fix        88b9a8aaeffa        11 months ago       73.9MB
  22. feisky/app                     mem-leak            8949a3c07284        11 months ago       73.9MB
  23. feisky/app                     io-cached           6a465f6f0be7        11 months ago       73.9MB
  24. feisky/app                     io-direct           da0f397bc71e        11 months ago       73.9MB
  25. ubuntu                         latest              adafef2e596e        11 months ago       73.9MB
  26. mysql                          5.7.30              9cfcce23593a        12 months ago       448MB
  27. microsoft/mssql-server-linux   latest              314918ddaedf        2 years ago         1.35GB

3.运行sqlserver容器

  1. #开通端口
  2. firewall-cmd --zone=public --add-port=11433/tcp --permanent
  3. firewall-cmd --reload
  5. #创建容器
  6. docker run -d \
  7. -v /docker/mssql:/var/opt/mssql \
  8. -e 'ACCEPT_EULA=Y' \
  9. -e 'SA_PASSWORD=E6gps@1234' \
  10. -e 'MSSQL_PID=Enterprise' \
  11. -e 'MSSQL_LCID=2052' \
  12. -e TZ='Asia/Shanghai' \
  13. -p 11433:1433 \
  14. --name sqlserver \
  15. -d microsoft/mssql-server-linux

4.参数说明:

  1. -e 'ACCEPT_EULA=Y'             设置此参数说明同意 SQL SERVER 使用条款 , 否则无法使用
  2. -e 'SA_PASSWORD=密码'             此处设置 SQL SERVER 数据库 SA 账号的密码
  3. -p 11433:1433                     将宿主机 11433端口映射到容器的 1433 端口
  4. --name sqlserver             设置容器名为 mssql
  5. -v /docker/mssql:/var/opt/mssql  将linux宿主机目录/docker/mssql 映射到容器 /var/opt/mssql , 方便备份数据
  6. -d                             在后台运行

5.连接数据库

  1. #先进入容器
  2. docker exec -it sqlserver bash
  4. #使用命令在内部连接，在容器内部使用 sqlcmd 进行本地连接。 默认情况下，sqlcmd 不在路径之中，因此需要指定完整路径。
  5. /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P E6gps@1234
  7. #创建数据库
  8. CREATE DATABASE MyDB;
  9. SELECT Name from sys.Databases;
  10. GO
  12. #退出
  13. quit

6.启动代理

  1. #进入docker
  2. docker exec -it sqlserver bash
  4. #启动SQL server代理
  5. /opt/mssql/bin/mssql-conf set sqlagent.enabled true
  7. SQL Server needs to be restarted in order to apply this setting. Please run
  8. 'systemctl restart mssql-server.service'.
  10. #退出并重启容器
  11. docker stop sqlserver
  12. docker start sqlserver
  14. #重新连接客户端

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RlbW9uc29u_size_16_color_FFFFFF_t_70

7.外部连接

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RlbW9uc29u_size_16_color_FFFFFF_t_70 1

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RlbW9uc29u_size_16_color_FFFFFF_t_70 2

版本

20210623091753463.png

创建数据库

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RlbW9uc29u_size_16_color_FFFFFF_t_70 3

本地数据库目录

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RlbW9uc29u_size_16_color_FFFFFF_t_70 4

8.docker命令

  1. docker images
  2. docker ps -a
  3. docker ps
  4. docker stop XXX
  5. docker rm XXX
  6. docker rmi XXX

发表评论

表情：
评论列表 （有 0 条评论，217人围观）

还没有评论，来说两句吧...

相关阅读