ITPub博客

首页 > IT职业 > IT职场 > 如何在Linux/MacOS系统上安装Microsoft SQL Se

如何在Linux/MacOS系统上安装Microsoft SQL Se

IT职场 作者:lenghuo 时间:2021-09-09 10:14:53 0 删除 编辑

转载来源:https://hub.docker.com/_/mssql-server-linux

 

https://hub.docker.com/r/microsoft/mssql-server Learn more about Microsoft Container Registry at https://azure.microsoft.com/en-us/blog/microsoft-syndicates-container-catalog

(Dockerfile) - the latest CU of the latest GA release

  • 2017-latest (Dockerfile) - the latest CU of the SQL Server 2017 release

  • 2017-CU12 (Dockerfile) - CU12 of SQL Server 2017

  • 2017-CU11 (Dockerfile) - CU11 of SQL Server 2017

  • 2017-CU10 (Dockerfile) - CU10 of SQL Server 2017

  • 2017-CU9 (Dockerfile) - CU9 of SQL Server 2017

  • 2017-CU8 (Dockerfile) - CU8 of SQL Server 2017

  • 2017-CU7 (Dockerfile) - CU7 of SQL Server 2017

  • 2017-CU6 (Dockerfile) - CU6 of SQL Server 2017

  • 2017-CU5 (Dockerfile) - CU5 of SQL Server 2017

  • 2017-CU4 (Dockerfile) - CU4 of SQL Server 2017

  • 2017-CU3 (Dockerfile) - CU3 of SQL Server 2017

  • 2017-CU2 (Dockerfile) - CU2 of SQL Server 2017

  • 2017-CU1 (Dockerfile) - CU1 of SQL Server 2017

  • 2017-GDR (Dockerfile) - the most recent version of a SECURITY fixes ONLY release for SQL Server 2017

  • 2017-GA (Dockerfile) - the original GA release version of SQL Server 2017

  • Notes: GA = General Availability - when the version is officially available and supported. CU = Cumulative Update - a periodic release that includes bug fixes, security fixes, and occasionally a small feature. CTP = Community Technology Preview - a preview release that precedes the GA of an upcoming new version. GDR = General Distribution Release - a release that contains ONLY security fixes.


    here.

    mssql-docker GitHub Project.

    Microsoft SQL Server on Linux for Docker Engine. Learn more about the latest release of SQL Server on Linux here.

    their supported platforms.

  • At least 2GB of RAM (3.25 GB prior to 2017-CU2). Make sure to assign enough memory to the Docker VM if you're running on Docker for Mac or Windows.

  • Requires the following environment flags

    • ACCEPT_EULA=Y

    • SA_PASSWORD=<your_strong_password>

    • MSSQL_PID=<your_product_id | edition_name> (default: Developer)

  • A strong system administrator (SA) password: At least 8 characters including uppercase, lowercase letters, base-10 digits and/or non-alphanumeric symbols.


  • using an entrypoint.sh script to create a database and schema and bcp in some data.

    You can connect to the SQL Server instance in the container from outside the container by using various command line and GUI tools on the host or remote computers. See the Connect and Query topic in the SQL Server on Linux documentation.

    Environment Variables

    ACCEPT_EULA confirms your acceptance of the End-User Licensing Agreement.

    SA_PASSWORD is the database system administrator (userid = 'sa') password used to connect to SQL Server once the container is running. Important note: This password needs to include at least 8 characters of at least three of these four categories: uppercase letters, lowercase letters, numbers and non-alphanumeric symbols.

    MSSQL_PID is the Product ID (PID) or Edition that the container will run with. Acceptable values:

    • Developer : This will run the container using the Developer Edition (this is the default if no MSSQL_PID environment variable is supplied)

    • Express : This will run the container using the Express Edition

    • Standard : This will run the container using the Standard Edition

    • Enterprise : This will run the container using the Enterprise Edition

    • EnterpriseCore : This will run the container using the Enterprise Edition Core

    • <valid product id> : This will run the container with the edition that is associated with the PID

    For a complete list of environment variables that can be used, refer to the documentation here.


    GitHub issue.

    microsoft/mssql-server-windows-developer

  • SQL Server Express for Windows Containers: microsoft/mssql-server-windows-express

  • SQL Server Command Line Tools for Linux: microsoft/mssql-tools


  • 来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2989/viewspace-2818895/ ,如需转载,请注明出处,否则将追究法律责任。

    上一篇: Spark 之RDD
    请登录后发表评论 登录
    全部评论

    注册时间:2019-08-13

    • 博文量
      68
    • 访问量
      807