[root@nas ~]# curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 192 100 192 0 0 442 0 --:--:-- --:--:-- --:--:-- 443
yum microsoft repository 설치
[root@nas ~]# yum -y install mssql-tools unixODBC-devel
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.kakao.com
* centos-sclo-rh: mirror.kakao.com
* centos-sclo-sclo: mirror.kakao.com
* epel: ftp.riken.jp
* extras: mirror.kakao.com
* remi-safe: ftp.riken.jp
* updates: mirror.kakao.com
Resolving Dependencies
--> Running transaction check
---> Package mssql-tools.x86_64 0:17.9.1.1-1 will be installed
--> Processing Dependency: msodbcsql17 >= 17.3.0.0 for package: mssql-tools-17.9.1.1-1.x86_64
---> Package unixODBC-devel.x86_64 0:2.3.1-14.el7 will be updated
---> Package unixODBC-devel.x86_64 0:2.3.7-1.rh will be an update
--> Processing Dependency: unixODBC = 2.3.7 for package: unixODBC-devel-2.3.7-1.rh.x86_64
--> Running transaction check
---> Package msodbcsql17.x86_64 0:17.9.1.1-1 will be installed
---> Package unixODBC.x86_64 0:2.3.1-14.el7 will be updated
---> Package unixODBC.x86_64 0:2.3.7-1.rh will be an update
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================================
Installing:
mssql-tools x86_64 17.9.1.1-1 packages-microsoft-com-prod 291 k
Updating:
unixODBC-devel x86_64 2.3.7-1.rh packages-microsoft-com-prod 42 k
Installing for dependencies:
msodbcsql17 x86_64 17.9.1.1-1 packages-microsoft-com-prod 909 k
Updating for dependencies:
unixODBC x86_64 2.3.7-1.rh packages-microsoft-com-prod 213 k
Transaction Summary
====================================================================================================================================================================================
Install 1 Package (+1 Dependent package)
Upgrade 1 Package (+1 Dependent package)
Total download size: 1.4 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
warning: /var/cache/yum/x86_64/7/packages-microsoft-com-prod/packages/mssql-tools-17.9.1.1-1.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID be1229cf: NOKEY 0 B --:--:-- ETA
Public key for mssql-tools-17.9.1.1-1.x86_64.rpm is not installed
(1/4): mssql-tools-17.9.1.1-1.x86_64.rpm | 291 kB 00:00:00
(2/4): unixODBC-2.3.7-1.rh.x86_64.rpm | 213 kB 00:00:00
(3/4): msodbcsql17-17.9.1.1-1.x86_64.rpm | 909 kB 00:00:00
(4/4): unixODBC-devel-2.3.7-1.rh.x86_64.rpm | 42 kB 00:00:00
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.4 MB/s | 1.4 MB 00:00:01
Retrieving key from https://packages.microsoft.com/keys/microsoft.asc
Importing GPG key 0xBE1229CF:
Userid : "Microsoft (Release signing) <gpgsecurity@microsoft.com>"
Fingerprint: bc52 8686 b50d 79e3 39d3 721c eb3e 94ad be12 29cf
From : https://packages.microsoft.com/keys/microsoft.asc
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : unixODBC-2.3.7-1.rh.x86_64 1/6
The license terms for this product can be downloaded from
https://aka.ms/odbc17eula and found in
/usr/share/doc/msodbcsql17/LICENSE.txt . By entering 'YES',
you indicate that you accept the license terms.
Do you accept the license terms? (Enter YES or NO)
YES
Installing : msodbcsql17-17.9.1.1-1.x86_64 2/6
The license terms for this product can be downloaded from
http://go.microsoft.com/fwlink/?LinkId=746949 and found in
/usr/share/doc/mssql-tools/LICENSE.txt . By entering 'YES',
you indicate that you accept the license terms.
Do you accept the license terms? (Enter YES or NO)
YES
Installing : mssql-tools-17.9.1.1-1.x86_64 3/6
Updating : unixODBC-devel-2.3.7-1.rh.x86_64 4/6
Cleanup : unixODBC-devel-2.3.1-14.el7.x86_64 5/6
Cleanup : unixODBC-2.3.1-14.el7.x86_64 6/6
Verifying : unixODBC-devel-2.3.7-1.rh.x86_64 1/6
Verifying : mssql-tools-17.9.1.1-1.x86_64 2/6
Verifying : msodbcsql17-17.9.1.1-1.x86_64 3/6
Verifying : unixODBC-2.3.7-1.rh.x86_64 4/6
Verifying : unixODBC-devel-2.3.1-14.el7.x86_64 5/6
Verifying : unixODBC-2.3.1-14.el7.x86_64 6/6
Installed:
mssql-tools.x86_64 0:17.9.1.1-1
Dependency Installed:
msodbcsql17.x86_64 0:17.9.1.1-1
Updated:
unixODBC-devel.x86_64 0:2.3.7-1.rh
Dependency Updated:
unixODBC.x86_64 0:2.3.7-1.rh
Complete!
mssql-tools (sqlcmd, bcp) 설치
[root@nas ~]# echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
SSH 로그인 후 sqlcmd, bcp 명령어 사용 가능하도록 경로 추가
[root@nas ~]# source ~/.bash_profile
추가한 내용 적용