You have already explored the installation of SQL Server and SQL Server tools on CentOs. In this post, we will see what all the packages and files get installed during the SQL Server installation on Linux (CentOs) using rpm package manager but before let’s first understand;

What is RPM?

RPM originally stands for Red Hat Package Manager. It has five basic modes of operation (not counting package building): installing, uninstalling, upgrading, querying, and verifying. For more details, you can follow the link – RedHat RMP

Let’s check out what all the SQL packages have been installed on your CentOs system by running the following command.

Syntax: yum list installed | grep mssql

Now, let’s figure out what all the files get installed by each package.

mssql-server package

• Execute the below command to list down the files which were installed by mssql-server package

Syntax: rpm -ql mssql-server

[root@localhost sachit]# rpm -ql mssql-server
/opt/mssql/bin
/opt/mssql/bin/compress-dump.sh
/opt/mssql/bin/generate-core.sh
/opt/mssql/bin/mssql-conf
/opt/mssql/bin/sqlpackage
/opt/mssql/bin/sqlservr
/opt/mssql/bin/sqlservr-setup
/opt/mssql/bin/sqlservr-telemetry
/opt/mssql/lib
/opt/mssql/lib/libc++.so.1
/opt/mssql/lib/libc++abi.so.1
/opt/mssql/lib/libjemalloc.so.1
/opt/mssql/lib/libsqltelemetry.so
/opt/mssql/lib/libunwind.so.8
/opt/mssql/lib/mssql-conf
/opt/mssql/lib/mssql-conf/collations.txt
/opt/mssql/lib/mssql-conf/mssql-conf.py
/opt/mssql/lib/mssql-conf/mssqlconfhelper.py
/opt/mssql/lib/mssql-conf/mssqlsettings.py
/opt/mssql/lib/mssql-conf/mssqlsettingsmanager.py
/opt/mssql/lib/mssql-conf/sapassword.sh
/opt/mssql/lib/mssql-conf/set-collation.sh
/opt/mssql/lib/sqlpackage.sfp
/opt/mssql/lib/sqlservr.sfp
/opt/mssql/lib/system.certificates.sfp
/opt/mssql/lib/system.common.sfp
/opt/mssql/lib/system.netfx.sfp
/opt/mssql/lib/system.sfp
/usr/lib/systemd/system/mssql-server-telemetry.service
/usr/lib/systemd/system/mssql-server.service
/usr/share/doc/mssql-server/LICENSE.TXT
/usr/share/doc/mssql-server/THIRDPARTYNOTICES.TXT
/usr/share/man/man1/mssql-conf.1.gz
/usr/share/man/man1/sqlpackage.1.gz
/usr/share/man/man1/sqlservr.1.gz
[root@localhost sachit]#

mssql-tools package

• To list down the files which were installed by mssql-tool package, kindly run the following command;

Syntax: rpm -ql mssql-tools

[root@localhost sachit]# rpm -ql mssql-tools
/opt/mssql-tools/bin
/opt/mssql-tools/bin/bcp-14.0.1.246
/opt/mssql-tools/bin/sqlcmd-14.0.1.246
/opt/mssql-tools/share
/opt/mssql-tools/share/resources
/opt/mssql-tools/share/resources/en_US
/opt/mssql-tools/share/resources/en_US/BatchParserGrammar.dfa
/opt/mssql-tools/share/resources/en_US/BatchParserGrammar.llr
/opt/mssql-tools/share/resources/en_US/SQLCMD.rll
/opt/mssql-tools/share/resources/en_US/bcp.rll
/usr/share/doc/mssql-tools
/usr/share/doc/mssql-tools/LICENSE.txt
/usr/share/doc/mssql-tools/THIRDPARTYNOTICES.txt
[root@localhost sachit]#

msodbcsql package

• The same way execute the below mentioned command to list down the files which were installed by msodbcsql package

Syntax: rpm -ql msodbcsql

[root@localhost sachit]# rpm -ql msodbcsql
/opt/microsoft
/opt/microsoft/msodbcsql
/opt/microsoft/msodbcsql/etc
/opt/microsoft/msodbcsql/etc/odbcinst.ini
/opt/microsoft/msodbcsql/include
/opt/microsoft/msodbcsql/include/msodbcsql.h
/opt/microsoft/msodbcsql/lib64
/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0
/opt/microsoft/msodbcsql/share
/opt/microsoft/msodbcsql/share/resources
/opt/microsoft/msodbcsql/share/resources/en_US
/opt/microsoft/msodbcsql/share/resources/en_US/msodbcsqlr13.rll
/usr/share/doc/msodbcsql
/usr/share/doc/msodbcsql/LICENSE.txt
[root@localhost sachit]#

Knowing all the installed files by the SQL packages can give you a better understanding of SQL Server on Linux (CentOs). I hope you relish it!