mssql.Dockerfile

FROM ubuntu:20.04
# Install prerequistes since it is needed to get repo config for SQL server
USER root
ENV ACCEPT_EULA=Y \
    DEBIAN_FRONTEND=noninteractive
RUN apt-get update && \
    apt-get install -yq curl apt-transport-https gnupg2 && \
    # Get official Microsoft repository configuration
    curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
    curl https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list | tee /etc/apt/sources.list.d/mssql-server.list && \
    curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | tee /etc/apt/sources.list.d/msprod.list && \
    apt-get update && \
    # Install SQL Server from apt
    apt-get install -y mssql-server && \
    # Install optional packages
    apt-get install -y mssql-server-ha mssql-server-fts mssql-server-polybase && \
    # Install SQL Server Tools from apt
    apt-get install -y mssql-tools unixodbc-dev && \
    # Cleanup the Dockerfile
    apt-get autoremove && \
    apt-get clean && \
    rm -rf /var/lib/apt/lists

ENV PATH="${PATH}:/opt/mssql-tools/bin"

EXPOSE 1433

USER mssql

# Run SQL Server process
CMD ["/opt/mssql/bin/sqlservr"]