LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 03-22-2007, 08:08 PM   #1
fukawi2
Member
 
Registered: Oct 2006
Location: Melbourne, Australia
Distribution: ArchLinux, ArchServer, Fedora, CentOS
Posts: 449

Rep: Reputation: 34
Linux Client for MS SQL 2005


I'm after an equivalent to what I believe is the 'sqlcmd' that comes with MS SQL 2005...

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
 
Old 03-24-2007, 11:54 AM   #2
dustymugs
LQ Newbie
 
Registered: Dec 2005
Distribution: slackware, lfs
Posts: 13

Rep: Reputation: 0
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.
 
Old 03-25-2007, 02:00 AM   #3
d@@b
LQ Newbie
 
Registered: Sep 2005
Location: Baltimore, MD
Posts: 12

Rep: Reputation: 0
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.
 
Old 03-25-2007, 07:02 PM   #4
fukawi2
Member
 
Registered: Oct 2006
Location: Melbourne, Australia
Distribution: ArchLinux, ArchServer, Fedora, CentOS
Posts: 449

Original Poster
Rep: Reputation: 34
Thanks guys - Will have a look
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Live communication server 2005 client for linux? alem2k5 Linux - Enterprise 9 07-24-2008 01:24 AM
[SOLVED] Managing Microsoft SQL Server 2005 on linux Blue_Ice Linux - Enterprise 1 10-03-2006 11:48 AM
LXer: Sql - stored procedures, views, and dynamic sql generation LXer Syndicated Linux News 0 08-17-2006 07:33 AM
freetds to access SQL server from linux client sailu_mvn Linux - Software 2 12-06-2005 11:19 PM
sql text client pao Linux - Newbie 2 07-28-2004 08:50 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:59 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration