[MacOS] MSSQL ODBC 설치

Microsoft ODBC Driver 17 for SQL Server

Windows

x64 <https://go.microsoft.com/fwlink/?linkid=2137027>
x86 <https://go.microsoft.com/fwlink/?linkid=2137028>

MAC

brew tap microsoft/mssql-release <https://github.com/Microsoft/homebrew-mssql-release>
brew update
HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools

Ubuntu

sudo su
curl <https://packages.microsoft.com/keys/microsoft.asc> | apt-key add -

#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version

#Ubuntu 16.04
curl <https://packages.microsoft.com/config/ubuntu/16.04/prod.list> > /etc/apt/sources.list.d/mssql-release.list
#Ubuntu 18.04
curl <https://packages.microsoft.com/config/ubuntu/18.04/prod.list> > /etc/apt/sources.list.d/mssql-release.list
#Ubuntu 20.04
curl <https://packages.microsoft.com/config/ubuntu/20.04/prod.list> > /etc/apt/sources.list.d/mssql-release.list

exit

sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17

# 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

# optional: for unixODBC development headers
sudo apt-get install unixodbc-dev

Red Hat Enterprise Server 및 Oracle Linux

sudo su

#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version

#RedHat Enterprise Server 6
curl <https://packages.microsoft.com/config/rhel/6/prod.repo> > /etc/yum.repos.d/mssql-release.repo
#RedHat Enterprise Server 7
curl <https://packages.microsoft.com/config/rhel/7/prod.repo> > /etc/yum.repos.d/mssql-release.repo
#RedHat Enterprise Server 8 and Oracle Linux 8
curl <https://packages.microsoft.com/config/rhel/8/prod.repo> > /etc/yum.repos.d/mssql-release.repo

exit

sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql17

# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y yum install mssql-tools

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

# optional: for unixODBC development headers
sudo yum install unixODBC-devel

SUSE Linux Enterprise Server

sudo su

curl -O <https://packages.microsoft.com/keys/microsoft.asc>

rpm --import microsoft.asc

#Download appropriate package for the OS version
#Choose only ONE of the following, corresponding to your OS version

#SUSE Linux Enterprise Server 11 SP4
#Ensure SUSE Linux Enterprise 11 Security Module has been installed
zypper ar <https://packages.microsoft.com/config/sles/11/prod.repo>
#SUSE Linux Enterprise Server 12
zypper ar <https://packages.microsoft.com/config/sles/12/prod.repo>
#SUSE Linux Enterprise Server 15
zypper ar <https://packages.microsoft.com/config/sles/15/prod.repo>
#(Only for driver 17.3 and below)
SUSEConnect -p sle-module-legacy/15/x86_64

exit

sudo ACCEPT_EULA=Y zypper install msodbcsql17

# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y zypper install mssql-tools

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

# optional: for unixODBC development headers
sudo zypper install unixODBC-devel