Nova days many systems and solutions based on Docker. Sometime main issue is collaborating several solutions into one docker-file for running it.
My situation was similar and required to deploy solution which us using SQL Server PHP and Apache, unusual case :) Thats why was decided to implement two docker containers where in first will be executed SQL Server and on second PHP/Apache.
Below you can find steps:
1) Install Docker in your linux system.
yum install docker
2) Install SQL Server container into your docker system
sudo docker pull mcr.microsoft.com/mssql/server:2022-latest
3) Need to create docker-file (nano Dockerfile.base in /usr/src)
FROM php:8.2-apache-buster
RUN apt update && apt install -y unixodbc-dev gpg libzip-dev \
&& curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - \
&& curl https://packages.microsoft.com/config/debian/10/prod.list > /etc/apt/sources.list.d/mssql-release.list \
&& apt update \
&& ACCEPT_EULA=Y apt-get install -y msodbcsql18 \
&& pecl install sqlsrv \
&& pecl install pdo_sqlsrv \
&& docker-php-ext-install pdo opcache bcmath zip \
&& mv "$PHP_INI_DIR/php.ini-production" "$PHP_INI_DIR/php.ini" \
&& echo 'extension=sqlsrv.so' >> "$PHP_INI_DIR/php.ini" \
&& echo 'extension=pdo_sqlsrv.so' >> "$PHP_INI_DIR/php.ini" \
&& a2enmod rewrite
-------------------------------------------------------------------------------------
For building new container from your docker file need to use below command
docker build . -f Dockerfile.base -t 3cp-web