The other day I was trying to connect a Laravel application with a SQL Server database. I have been working in ubuntu and at the beginning I thought I have to install a Windows Virtual Machine to accomplish that but, after google a little bit I found that Microsoft has a version of the SQL Server for linux. The process is simple, just run the following lines in your ubuntu shell:
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql
sudo apt-get install unixodbc-dev gcc g++ build-essential
sudo pecl install sqlsrv pdo_sqlsrv
sudo echo "extension= pdo_sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
sudo echo "extension= sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`After this process you are going to have a trial version of the database in your ubuntu.
