How to download data from SQL Server in UNIX

Question

How to download data from SQL Server in UNIX

savingfunda

SSC Enthusiast

Points: 121
More actions
December 6, 2014 at 6:40 am

#293146

I know that SQL Server runs on Windows Server, is it possible to download data in UNIX using shell script? does SQL Server has any binary or command line client for any operating system other than Windows?
My Blog

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Conor.Lillis SSC Veteran Points: 222 More actions · Answer 1

In the absence of any additional information on your requirement, there are plenty of options for you.

For example PERL has the DBI connectivity libraries which work just fine for connecting to a SQL Server host from PERL scripts which are supported on Unix.

savingfunda SSC Enthusiast Points: 121 More actions · Answer 2

Thanks, I actually want to do it using shell script, without using Perl, Python or Java, if at all possible.

My Blog

Conor.Lillis SSC Veteran Points: 222 More actions · Answer 3

Have you thought about putting an SSH server onto your SQL Server and call it from the UNIX box.

You can then initiate SQL exports / BCP / whatever you're having yourself, and SFTP / SCP / FTP the data to your unix host.

savingfunda SSC Enthusiast Points: 121 More actions · Answer 4

This sounds like a good solution, do you know any SSH Server for Windows?

My Blog

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 5

Quick thought, while the SSH will work it is not a perfect solution, relatively slow, increased attack surface etc.. Why not use ODBC connection from the UX? Or schedule a job on the SQL box to dump a file on a share (SAMBA)? Or use the command line tools from the Microsoft ODBC Driver 11 for SQL Server on Linux?

😎