How to add sqlcmd into ARM azure-sql-edge?

[d4vidsha]

Our setup is similar to what is shown here and works for x86 processors only.

But we would like to extend this Docker implementation so that it works for ARM-based processors. The build will succeed, but since SQL client tools aren't available on the ARM64 platform, we are stuck and unable to run sqlcmd to initialize our database. The obvious error we get in Docker is:

/opt/mssql-tools/bin/sqlcmd: No such file or directory

which is supposedly coming from this line of code.

We are relatively new to MSSQL and Docker, so my simple question is, how can I use go-sqlcmd so that it replaces the one from mssql-tools? Not sure if this is the right approach, but I got the idea from this StackOverflow post as well as a previous discussion post #36 (comment).

Additional resources

• https://learn.microsoft.com/en-gb/sql/tools/sqlcmd/sqlcmd-utility
• https://hub.docker.com/_/microsoft-azure-sql-edge

[apoorvdeshmukh]

We regularly release arm64 binary of sqlcmd under releases.
As a part of your script, could you try fetching this binary and run the intended sqlcmd command?
You may have to change your code to ensure that you are invoking the downloaded sqlcmd instead of the one found under /opt/mssql-tools/

[d4vidsha]

Cheers @apoorvdeshmukh 👍

[d4vidsha]

After some further digging, I'm downloading the go-sqlcmd binaries directly into our Dockerfile, utilising the convention outlined here.

An example Dockerfile:

FROM mcr.microsoft.com/azure-sql-edge:latest

USER root

# add sqlcmd from https://github.com/microsoft/go-sqlcmd
# we add this to /opt/mssql-tools/bin which completely overrides the
# sqlcmd from the base image. Read up on why we do this here:
# https://github.com/microsoft/go-sqlcmd/discussions/501#discussion-6088877
WORKDIR /opt/mssql-tools/bin
ENV GOSQLCMD_VERSION=v1.5.0
ARG TARGETPLATFORM
RUN case ${TARGETPLATFORM} in \
    "linux/amd64")  GOSQLCMD_ARCH=amd64 ;; \
    "linux/arm64")  GOSQLCMD_ARCH=arm64 ;; \
    *) echo "Unsupported platform: ${TARGETPLATFORM}"; exit 1 ;; \
    esac \
 && wget https://github.com/microsoft/go-sqlcmd/releases/download/${GOSQLCMD_VERSION}/sqlcmd-${GOSQLCMD_VERSION}-linux-${GOSQLCMD_ARCH}.tar.bz2 \
 && tar -xjf sqlcmd-${GOSQLCMD_VERSION}-linux-${GOSQLCMD_ARCH}.tar.bz2

# now we set up the usual
WORKDIR /app
COPY setup.sql setup.sql
COPY entrypoint.sh entrypoint.sh
COPY init_db.sh init_db.sh
RUN chmod +x entrypoint.sh
RUN chmod +x init_db.sh

CMD ./entrypoint.sh