#!/bin/bash

# This script installs SQL Server client utilities for Linux.
# You will be prompted (twice) to accept the Microsoft's EULA agreement

# unixODBC package version
uo_ver=2.3.1-11.el7

# msodbcsql package version
mo_ver=13.1.9.1-1

# mssql-tools package version
mt_ver=14.0.6.0-1

# install unixODBC (required prereq)
sudo yum -y localinstall unixODBC-$uo_ver.x86_64.rpm
sudo yum -y localinstall unixODBC-devel-$uo_ver.x86_64.rpm

# install SQL Server client files
sudo yum -y localinstall msodbcsql-$mo_ver.x86_64.rpm
sudo yum -y localinstall mssql-tools-$mt_ver.x86_64.rpm

# add to default path
sudo ln -sfn /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd 
sudo ln -sfn /opt/mssql-tools/bin/bcp /usr/bin/bcp

# set up ODBC data source for empower
sudo cp /etc/odbcinst.ini /etc/odbcinst.ini.original
sudo cp /home/ec2-user/odbcinst.ini /etc/odbcinst.ini

# install Perl DBD::ODBC module
sudo /usr/local/bin/cpanm -n DBD-ODBC-1.52.tar.gz

