You can append the path to sqlcmd
to your .bashrc
file as part of your Dockerfile. Try adding this line to it:
RUN echo "export PATH=/opt/mssql-tools/bin/sqlcmd:${PATH}" >> /your_home_directory/.bashrc
You'd have to replace /your_home_directory
with the path to your home directory within the container.