Tag | Product | Version | Release date |
---|---|---|---|
latest | Azure SQL Edge PowerShell SqlServer (module) sqlcmd-arm64 mssql-tools18 |
15.0.2000.1574 7.4.2 22.2.0 0.2.0 18.2.1.1-1 |
2023-02-09 2024-04-11 2024-01-16 2023-05-04 2023-02-10 |
Unfortunatelly sqlcmd
tool is not available inside the ARM64 version of Azure SQL Edge container1, that is why this image contains installed PowerShell2 with SqlServer3 module and custom version of sqlcmd-arm64
4.
Now you can use:
Invoke-SqlCmd
frompwsh
or
/opt/mssql-tools/bin/sqlcmd
inside ARM64 version of Azure SQL Edge container, tadam.
Following Microsoft's announcement5, Azure SQL Edge based on ARM64 architecture is retired. Alternatively, it is possible to run SQL 2017/2019/2022 and Azure SQL Edge AMD64 containers on Apple Silicon using Docker Desktop for macOS v4.16+.
According to the article6 "Install the SQL Server command-line tools sqlcmd and bcp on Linux" there are both x64
and arm64
architectures of sqlcmd
and bcp
. These tools are bundled in the mssql-tools18
package (not mssql-tools) and are installed on this image.
Now you can use:
/opt/mssql-tools18/bin/sqlcmd
and
/opt/mssql-tools18/bin/bcp
Requires the following environment flags:
ACCEPT_EULA=Y
MSSQL_SA_PASSWORD=
1) https://hub.docker.com/_/microsoft-azure-sql-edge
3) https://docs.microsoft.com/en-us/sql/powershell/download-sql-server-ps-module?view=sql-server-ver15