如何在SQL Server docker映像上安装PowerShell Core？

Question

我希望能够在SQL服务器Docker实例中运行一些交互式命令。因为我不熟悉bash，而且我有一些PowerShell知识，所以我会使用PowerShell Core。

如何在SQL Server docker映像上安装PowerShell Core？

Answer 1

创建以下Dockerfile（SQL Server 2019映像示例，大部分内容来自此处）：

FROM mcr.microsoft.com/mssql/server:2019-latest AS base
# This is required since the instance uses mssql user and the following command require root or sudo
# This is used to avoid installing sudo
USER root

# Download the Microsoft repository GPG keys
RUN wget -q https://packages.microsoft.com/config/ubuntu/16.04/packages-microsoft-prod.deb

# Register the Microsoft repository GPG keys
RUN dpkg -i packages-microsoft-prod.deb

# Update the list of products
RUN apt-get update

# Install PowerShell
RUN apt-get install -y powershell

# Revert back to default user used by SQL instance
USER mssql 

要以交互方式使用docker实例，请显式使用root用户（源代码）：

docker exec -u 0 -it mssqlcontainer pwsh
PowerShell 7.0.0
Copyright (c) Microsoft Corporation. All rights reserved.

https://aka.ms/powershell
Type 'help' to get help.

PS /> $PSVersionTable.PSVersion

Major  Minor  Patch  PreReleaseLabel BuildLabel
-----  -----  -----  --------------- ----------
7      0      0