LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Linux Client for MS SQL 2005 (https://www.linuxquestions.org/questions/linux-server-73/linux-client-for-ms-sql-2005-a-539779/)

fukawi2 03-22-2007 08:08 PM

Linux Client for MS SQL 2005
 
I'm after an equivalent to what I believe is the 'sqlcmd' that comes with MS SQL 2005...:scratch:

Essentially, I want to run a script on a Linux machine, that will connect to the MS SQL server on a Windows machine, dump a table to a text flat file on the Linux machine, then import that table to a PostgreSQL database on the local Linux machine...

MSSQL Table -> Text File -> PGSQL Table

At the moment, I'm doing this PostgreSQL to PostgreSQL but due to management it will soon need to be MS SQL 2005 to PostgreSQL :(

Any pointers would be great - keeping in mind I've never used MS SQL before :)

dustymugs 03-24-2007 11:54 AM

possible solutions
 
Well, you'll probably be using the FreeTDS (www.freetds.org) driver. If you're doing java, jTDS (http://jtds.sourceforge.net/) will do. Beyond that, maybe checkout something like... http://www.freetds.org/software.html. Seems like there is a method to call mssql from the command line.

d@@b 03-25-2007 02:00 AM

Freetds will be the way to go. I used it for one my project a while back when I needed to connect to mssql with php to retreive some data and worked fine for my needs.

fukawi2 03-25-2007 07:02 PM

Thanks guys - Will have a look :)


All times are GMT -5. The time now is 07:02 AM.