Using bash script to connect to remote SQL Server

Question

Our company has a db (SQL Server) in another country. I have the host name, username and the password of the db. I want to extract data from the database through bash shell and put them into local file. How can I do that?

Answer 1

Install FreeTDS. Once configured you'll be able to use tsql to query SQL Server from bash.