다음을 통해 공유

SQL SSIS: installation and uninstall on Centos (Linux)

  • 아티클

Download Integration Package

https://packages.microsoft.com/keys/microsoft.asc

Copy files

 Copy microsoft.asc file to Copy file in /etc/yum.repos.d/firectory 

Installation Steps for Integration services**:**

1. check package information of mssql

YUM (Yellowdog Updater Modified) is an open source command-line .It allows users and system administrator to easily install, update, remove or search software packages on a systems.

# yum install mssql-server -y

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

 * base: centos.mirror.net.in

 * epel: kartolo.sby.datautama.net.id

 * extras: centos.excellmedia.net

 * updates: centos.excellmedia.net

Installed Packages

Name  : mssql-server

Arch  : x86_64

Version  : 14.0.900.75

Release  : 1

Size  : 870 M

Repo  : installed

From repo  : packages-microsoft-com-mssql-server

Summary  : Microsoft SQL Server Relational Database Engine

License  : Commercial

Description : The mssql-server package contains the Microsoft SQL Server Relational Database Engine.

 If you want to install packages automatically without asking any confirmation, use option -y .

#

2.Install Integration services package.

yum install mssql-server -y

Loaded plugins: fastestmirror

HDP-2.4   | 2.9 kB  00:00

HDP-UTILS-1.1.0.20   | 2.9 kB  00:00

Updates-ambari-2.4.0.1   | 2.9 kB  00:00

base   | 3.6 kB  00:00

epel/x86_64/metalink   | 7.1 kB  00:00

extras   | 3.4 kB  00:00

mongodb-enterprise   | 2.5 kB  00:00

https://repo.mongodb.org/yum/redhat/7/mongodb-org/3.4/x86_64/repodata/repomd.xml ;    : [Errno 14] curl#6 - "Could not resolve host: repo.mongodb.org; Name or service    not known"

Trying other mirror.

http://repo.mysql.com/yum/mysql-5.7-community/el/6/x86_64/repodata/repomd.xml: [    Errno 14] curl#6 - "Could not resolve host: repo.mysql.com; Name or service not    known"

Trying other mirror.

https://packages.microsoft.com/rhel/7/mssql-server/repodata/repomd.xml: [Errno 1    4] curl#6 - "Could not resolve host: packages.microsoft.com; Name or service not    known"

Trying other mirror.

packages-microsoft-com-prod  | 2.9 kB  00:00

updates   | 3.4 kB  00:00

Loading mirror speeds from cached hostfile

 * base: centos.mirror.net.in

 * epel: kartolo.sby.datautama.net.id

 * extras: centos.excellmedia.net

 * updates: centos.excellmedia.net

Resolving Dependencies

There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and"yum history    redo last", first to finish them. If those don't work you'll have to try removin    g/installing packages by hand (maybe package-cleanup can help).

The program yum-complete-transaction is found in the yum-utils package.

--> Running transaction check

---> Package mssql-server-is.x86_64 0:14.0.900.75-1 will be installed

--> Finished Dependency Resolution

 `` 

Dependencies Resolved

  

================================================================================

 Package  Arch  Version  Repository  Size

================================================================================

Installing:

 mssql-server-is x86_64 14.0.900.75-1 packages-microsoft-com-mssql-server 175 M

  

Transaction Summary

================================================================================

Install  1 Package

  

Total download size: 175 M

Installed size: 836 M

Downloading packages:

Delta RPMs disabled because /usr/bin/applydeltarpm not installed.

mssql-server-is-14.0.900.75-1.x86_64.rpm  | 175 MB  01:04

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

 Installing : mssql-server-is-14.0.900.75-1.x86_64  1/1

 Verifying  : mssql-server-is-14.0.900.75-1.x86_64  1/1

  

Installed:

 mssql-server-is.x86_64 0:14.0.900.75-1

  

Complete!

3. check progress Integration services install

# rpm -qa | grep mssql

mssql-tools-14.0.6.0-1.x86_64

mssql-server-14.0.900.75-1.x86_64

mssql-server-fts-14.0.900.75-1.x86_64

mssql-server-is-14.0.900.75-1.x86_64       ---Integration services is install

mssql-server-agent-14.0.900.75-1.x86_64

4.Configuration Integration services

#sudo /opt/ssis/bin/ssis-conf setup

Do you accept the license terms? [Yes/No]:y

  

Choose an edition of

SSIS:

 1) Evaluation (free, no production use rights, 180-day limit)

 2) Developer (free, no production use rights)

 3) Express (free)

 4) Web (PAID)

 5) Standard (PAID)

 6) Enterprise (PAID)

 7) I bought a license through a retail sales channel and have a product key to

**  **

Details about editions can be found at

https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409

  

Use of PAID editions of this software requires separate licensing through a

Microsoft Volume Licensing program.

By choosing a PAID edition, you are verifying that you have the appropriate

number of licenses in place to install and run this software.

  

Enter your edition(1-7): 1

Only userin 'ssis'group can run 'dtexec' onLinux. Do you want to add current

Please logout to reload the group information.

SSIS telemetry service is now running.

Setup has completed successfully.

5.Set path for Integration services

export PATH=/opt/ssis/bin:$PATH

6. Remove Integration services

sudo yum remove package-->To uninstall a particular package

# sudo yum remove mssql-server-is

Loaded plugins: fastestmirror

Resolving Dependencies

There are unfinished transactions remaining. You might consider running yum-complete-transaction, or"yum-complete-transaction --cleanup-only" and"yum history redo last", first tofinish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).

The program yum-complete-transaction is found inthe yum-utils package.

--> Running transaction check

---> Package mssql-server-is.x86_64 0:14.0.900.75-1 will be erased

--> Finished Dependency Resolution

 

Dependencies Resolved

 

=======================================================================================

 Package  Arch  Version  Repository   Size

=======================================================================================

Removing:

 mssql-server-is  x86_64  14.0.900.75-1  @packages-microsoft-com-mssql-server  836 M

 

Transaction Summary

===============

Remove  1 Package

 

Installed size: 836 M

Is this ok [y/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

 Erasing  : mssql-server-is-14.0.900.75-1.x86_64     1/1

 Verifying  : mssql-server-is-14.0.900.75-1.x86_64     1/1

 

Removed:

 mssql-server-is.x86_64 0:14.0.900.75-1

 Complete!

7.Check Integration uninstall completed

RPMs can be used to,

  • Install packages  sudo rpm –i sample_file.rpm
     Remove packages  sudo rpm –e sample_file.rpm
     Upgrade packages  rpm -Uvh sample_file.rpm
     Verify packages  
     Check RPM Dependencies  sudo rpm –qpR sample_file.rpm

# rpm -qa | grep mssql --Verify if the package is installed or not

mssql-tools-14.0.6.0-1.x86_64

mssql-server-14.0.900.75-1.x86_64

mssql-server-fts-14.0.900.75-1.x86_64

mssql-server-agent-14.0.900.75-1.x86_64

Reference

Suggested Readings