Exibir código-fonte para PHP SQL Server driver

== Sobre ==
Olá! Visitante, reunimos aqui, informações sobre como instalar o PHP SQL Server driver (PDO_SQLSRV).

== Requisitos == 

== Debian 8 ==
* Microsoft ODBC Driver for SQL Server no Linux

=== Instalando ODBC Driver ===

 sudo apt -y install gnupg curl
 curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
 curl https://packages.microsoft.com/config/debian/8/prod.list > /etc/apt/sources.list.d/mssql-release.list
 sudo apt -y update
 sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
 source ~/.bashrc
 sudo apt -y install unixodbc-dev

=== Habilitar Módulos no Apache ===

 # PHP 7.0
 printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.0/mods-available/sqlsrv.ini
 printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.0/mods-available/pdo_sqlsrv.ini
 phpenmod -v 7.0 sqlsrv pdo_sqlsrv
 
 # PHP 7.1
 printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.1/mods-available/sqlsrv.ini
 printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.1/mods-available/pdo_sqlsrv.ini
 phpenmod -v 7.1 sqlsrv pdo_sqlsrv

* Reiniciar o Serviço  
 /etc/init.d/apache2 reload


== Debian 9 ==
* Microsoft ODBC Driver for SQL Server no Linux

=== Instalando ODBC Driver ===

 apt update && apt install curl apt-transport-https
 curl https://packages.Microsoft.com/keys/Microsoft.asc | apt-key add -
 curl https://packages.Microsoft.com/config/debian/9/prod.list > /etc/apt/sources.list.d/mssql-release.list
 apt update
 ACCEPT_EULA=Y apt install msodbcsql17 mssql-tools unixodbc-dev php-pear php7.0-dev
 pecl install sqlsrv
 pecl install pdo_sqlsrv
 # Se falhar a instalação por meio do repositório pecl fazer de modo manual conforme linhas comentadas abaixo:
 #wget http://pecl.php.net/get/sqlsrv-5.2.0.tgz
 #wget http://pecl.php.net/get/pdo_sqlsrv-5.2.0.tgz
 #pecl install sqlsrv-5.2.0.tgz
 #pecl install pdo_sqlsrv-5.2.0.tgz
 
=== Habilitar Módulos no Apache ===

 cat <<EOF > /etc/php/7.0/cli/conf.d/99-sqlsrv.ini  
 extension=sqlsrv.so
 extension=pdo_sqlsrv.so
 EOF
 
 cat <<EOF > /etc/php/7.0/Apache2/conf.d/99-sqlsrv.ini  
 extension=sqlsrv.so
 extension=pdo_sqlsrv.so
 EOF


* Reiniciar o Serviço  
 /etc/init.d/apache2 reload

== Debian 10 ==
* Microsoft ODBC Driver for SQL Server no Linux

=== Instalando ODBC Driver ===


 sudo apt -y install gnupg curl
 curl -s https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
 sudo bash -c "curl -s https://packages.microsoft.com/config/debian/10/prod.list > /etc/apt/sources.list.d/mssql-release.list"
 sudo apt -y update
 sudo ACCEPT_EULA=Y apt -y install msodbcsql17 mssql-tools
 sudo apt -y install unixodbc-dev


=== Compilando e instalando os drivers ===


 sudo apt -y install gcc g++ make autoconf libc-dev pkg-config
 sudo apt -y install php-pear php-dev
 sudo pecl install sqlsrv
 sudo pecl install pdo_sqlsrv


=== Habilitar Módulos no Apache ===

 echo "extension=sqlsrv.so" | sudo tee /etc/php/7.3/mods-available/sqlsrv.ini
 echo "extension=pdo_sqlsrv.so" | sudo tee /etc/php/7.3/mods-available/pdo_sqlsrv.ini
 sudo phpenmod sqlsrv pdo_sqlsrv


* Reiniciar o Serviço  
 /etc/init.d/apache2 reload

== Reiniciando os serviços ==

 systemctl apache2 restart

ou 

 /etc/init.d/apache2 restart