InstallSqlServerDriverUbuntu1604.sh

#! /bin/bash

echo "Start sql driver install script"
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
echo "update apt-get sources"
sudo apt-get update
echo "updated apt-get sources"
sudo ACCEPT_EULA=Y apt-get install msodbcsql
echo "installed driver"
# sudo cp /usr/share/java/sqljdbc_4.1 $JAVA_HOME/jre/lib/ext/sqljdbc_4.1 
sudo cp /usr/share/java/sqljdbc41.jar $JAVA_HOME/jre/lib/ext/sqljdbc41.jar
echo "copied driver"

# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc