Ubuntu 24.04 repo: sqlcmd not available

[scara]

Hello @stuartpa , kind-of as in https://github.com/microsoft/go-sqlcmd/issues/528: sqlcmd is missing in 24.04 repo i.e no https://packages.microsoft.com/ubuntu/24.04/prod/pool/main/s/sqlcmd/ folder.

TIA, Matteo

[perlun]

I am seeing similar issues on Debian Bookworm; the sqlcmd package simply isn't there. For some use cases, apt-get install mssql-tools (the ODBC sqlcmd package) can be a replacement (but it is more restrictively licensed).

[jbauerrfid]

The sqlcmd is still missing in the repo.

I found this workaround:

wget https://packages.microsoft.com/ubuntu/22.04/prod/pool/main/s/sqlcmd/sqlcmd_1.5.0-1_jammy_all.deb
sudo dpkg -i sqlcmd_1.5.0-1_jammy_all.deb

It is not pretty because sideloading sqlcmd from a deb does not allow auto updates, but at least I got a working sqlcmd quickly. Apparently the sqlcmd tool for jammy works on noble as well.

[ghelyar]

Instead of trying to install sqlcmd, install mssql-tools18 https://packages.microsoft.com/ubuntu/24.04/prod/pool/main/m/mssql-tools18/

This installs to /opt/mssql-tools18/bin/sqlcmd

The documentation works but is missing 24.04 so needs adjusting slightly.

[matthetherington]

@ghelyar that will be the non-Go version of sqlcmd though