Search code examples
sqlsql-servershellsqlcmd

Need to run shell script on linux machine which uses sqlcmd but machine doesn't have SQL Server 2008 installed?

We have a scenario where we need to run a shell script on a Linux machine. This shell script internally uses sqlcmd but the machine doesn't have SQL Server 2008 installed.

Can anyone help me which tools/scripts/commmands that are required so that I can install/copy paste that client to run this script?

It would be helpful to provide link of such client so that i can download and give a try.

Shell script contains :

sqlcmd -S $Server -U $USER -P $PASSWORD  -i AggregateChannels.sql

Thanks.

Solution

  • A simple Google gives me this:

    The sqlcmd utility is available in the Microsoft ODBC Driver for SQL Server on Linux.

    See here for installation info.