sqlcmd command not found on Ubuntu
Hi friends, in this post we will discuss about a error which comes when we installed MSSQL TOOLS on Ubuntu. Error is: sqlcmd command not found on Ubuntu. I installed MSSQL Tools as told by microsoft blog step by step, but sqlcmd is not working and gives error. I googled about this and found a solution on Microsoft blog itself, someone also faced this issue and one of blog member posted this. I have tried and tested it, it’s working fine.
Earlier we had discussed about Install MSSQL Tools on Ubuntu, Install SQL Server on Ubuntu, Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?, and How To Install Linux.
Create symbolic link for BCP and SQLCMD. To do this open terminal and run below commands to create symbolic links for BCP and SQLCMD.
sudo ln -sfn /opt/mssql-tools/bin/sqlcmd* /usr/local/bin/sqlcmd sudo ln -sfn /opt/mssql-tools/bin/bcp* /usr/local/bin/bcp