php7-sqlsrv.sh

#!/bin/bash

# Add Microsoft's APT Repository
curl -s https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo bash -c "curl -s https://packages.microsoft.com/config/ubuntu/18.04/prod.list > /etc/apt/sources.list.d/mssql-release.list"

# Get the packages
sudo apt update
sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
sudo apt -y install unixodbc-dev

# Install the php extension
sudo apt -y install gcc g++ make autoconf libc-dev pkg-config php7.2-dev
sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv

# Enable extension for PHP
# For CLI usage:
sudo bash -c "echo extension=sqlsrv.so > /etc/php/7.2/cli/conf.d/20-sqlsrv.ini"
sudo bash -c "echo extension=pdo_sqlsrv.so > /etc/php/7.2/cli/conf.d/20-pdo_sqlsrv.ini"
# For FPM (aka Web) usage:
sudo bash -c "echo extension=sqlsrv.so > /etc/php/7.2/fpm/conf.d/20-sqlsrv.ini"
sudo bash -c "echo extension=pdo_sqlsrv.so > /etc/php/7.2/fpm/conf.d/20-pdo_sqlsrv.ini"

sudo service php7.2-fpm restart