Even after installing SQL Server on Ubuntu you can’t run sqlcmd commands in Ubuntu without installing mssql-tools
First of all, make sure that mssql-tools installed. If you are not sure you can simply try to install Using following command
$ sudo apt-get install mssql-tools
if mssql-tools already installed it will show the following
Reading package lists... Done
Building dependency tree
Reading state information... Done
mssql-tools is already the newest version (17.4.1.1-1).
If it not install command will install the mssql-tools into your ubuntu machine
Even after install mssql-tools, if you get "sqlcmd: command not found" error it because you have no proper symlinks created in /user/bin directory.
Check you have sqlcmd in /opt/mssql-tools/bin/ directory
run following command
$ sudo ls /opt/mssql-tools/bin/sqlcmd*
After you get the name of the tool you can create a symlink by following command
$ sudo ln -sfn /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd
