Redhat Linux 7でSQLServer、SQL Databaseに接続するためのsqlcmd、bcpを使用するにはsqltoolsをインストールする。
インストール
``curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo yum install mssql-tools unixODBC-devel```
# 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 193 100 193 0 0 300 0 --:--:-- --:--:-- --:--:-- 300
# yum install mssql-tools unixODBC-devel
Loaded plugins: fastestmirror, langpacks
Determining fastest mirrors
base | 3.6 kB 00:00:00
extras | 3.4 kB 00:00:00
openlogic | 2.9 kB 00:00:00
packages-microsoft-com-prod | 2.9 kB 00:00:00
updates | 3.4 kB 00:00:00
(1/3): extras/7/x86_64/primary_db | 201 kB 00:00:00
(2/3): updates/7/x86_64/primary_db | 4.2 MB 00:00:00
(3/3): packages-microsoft-com-prod/primary_db | 168 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mssql-tools.x86_64 0:17.3.0.1-1 will be installed
--> Processing Dependency: msodbcsql17 < 17.4.0.0 for package: mssql-tools-17.3.0.1-1.x86_64
--> Processing Dependency: msodbcsql17 >= 17.3.0.0 for package: mssql-tools-17.3.0.1-1.x86_64
---> Package unixODBC-devel.x86_64 0:2.3.7-1.rh will be installed
--> 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.3.1.1-1 will be installed
---> Package unixODBC.x86_64 0:2.3.7-1.rh will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================
Installing:
mssql-tools x86_64 17.3.0.1-1 packages-microsoft-com-prod 254 k
unixODBC-devel x86_64 2.3.7-1.rh packages-microsoft-com-prod 42 k
Installing for dependencies:
msodbcsql17 x86_64 17.3.1.1-1 packages-microsoft-com-prod 769 k
unixODBC x86_64 2.3.7-1.rh packages-microsoft-com-prod 213 k
Transaction Summary
=============================================================================================================================================================
Install 2 Packages (+2 Dependent packages)
＜中略、途中何回か確認が聞かれる＞
Installed:
mssql-tools.x86_64 0:17.3.0.1-1 unixODBC-devel.x86_64 0:2.3.7-1.rh
Dependency Installed:
msodbcsql17.x86_64 0:17.3.1.1-1 unixODBC.x86_64 0:2.3.7-1.rh
Complete!
確認
# ll /opt/mssql-tools/bin/
total 760
-rwxr-xr-x. 1 root root 245464 Sep 18 2018 bcp
-rwxr-xr-x. 1 root root 531984 Sep 18 2018 sqlcmd
# /opt/mssql-tools/bin/sqlcmd -S tcp:xxxxxxxxxx-srv.database.windows.net,1433 -d tpcc -U user -P pass -N -l 30
1> SELECT name, database_id, create_date
2> FROM sys.databases ;
3> GO
name database_id create_date
-------------------------------------------------------------------------------------------------------------------------------- ----------- -----------------------
master 1 2019-05-05 01:02:23.183
tpcc 6 2019-05-12 12:19:35.517
(2 rows affected)
1>
参考
Sqlcmd および bcp、SQL Server コマンド ライン ツールを Linux にインストールします。
https://docs.microsoft.com/ja-jp/sql/linux/sql-server-linux-setup-tools?view=sql-server-2017