According to Microsoft document, there is a sqlcmd utility which can be used on Windows server/system that can execute sql statement and bcp operation in command-line. Reference: https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16
There also a guide to install the SQL Server command-line tools sqlcmd and bcp on Linux. Reference: https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools?view=sql-server-ver16&tabs=redhat-install%2Credhat-offline
However, I am maintaining a Unix (Solaris11) server which want to execute sql statement and bcp operation in shell script that connect to Azure SQL Managed Instance. I cannot find out any Microsoft document to SQL Server command-line tools on Unix.
How can I install a command-line tools that can connect to Azure SQL MI and then execute sql statement and bcp operation within a shell script, to finish some business requirement.
SQLCMD is one of the SQL Server command line tools that Microsoft is making open source and built on GO language to make it portable. SQLCMD can be used to connect to Azure SQL and Azure SQL Managed instance and execute queries and SQL scripts. Based on this information Go supports Solaris 11 on amd64 architecture but not on SPARC. However, here I found a very promising article on porting GO to Sparc Solaris as well.