This week there was an update of SQL Server vNext, the new version is 14.0.200.24. Also the mssql-tools package was updated to version 14.0.2.0-1. This update resulted in me losing the sqlcmd and bcp utilities.
In my previous post, I mentioned that the packages you need to install are mssql-server and mssql-tools.
To find out which files are installed with the sqlserver packages I executed the dpkg-query command (on ubuntu):
dpkg-query -L mssql-tools
This returned the following list:
/opt/mssql-tools/share/resources/en_US/BatchParserGrammar.llr
/opt/mssql-tools/share/resources/en_US/BatchParserGrammar.dfa
/opt/mssql-tools/share/resources/en_US/SQLCMD.rll
/opt/mssql-tools/share/resources/en_US/bcp.rll
/opt/mssql-tools/bin/sqlcmd-13.0.1.0
/opt/mssql-tools/bin/bcp-13.0.1.0
/usr/share/doc/mssql-tools/THIRDPARTYNOTICES.txt
/usr/share/doc/mssql-tools/LICENSE.txt
So… there is a file called sqlcmd-13.0.1.0, but no symlink to it from /usr/bin.
To manually create the missing links:
sudo ln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd sudo ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp
This information is documented here, however instead of just documenting I would rather that the installation took care of this step.