MSSQL Access under Linux

[James McDonald]

> Hi Guys,
>
> I've been trying to find a way to access a database running on a WindBlows
> server and MS-SQL.  I plan to port the data into my PostgreSQL database
> for reports and archiving.  I am looking for a simple commandline
> interactive client, rather like the psql app for Postgres.  I'll be taking
> the results of some queries and dumping them to flat files that can be
> precessed and loaded into my "Real" database.
>
> Suggestions as to where to look?
>
>
Install UnixODBC on your Linux box.

Create a standard SQL User and password on windows with full access to the
db.

Using that user and UnixODBC connect to the database.


You can use OpenOffice and suck the data out of it.

http://www.unixodbc.org/doc/FreeTDS.html

-- 
James McDonald
Telarah NSW Australia