MSSQL Access under Linux

Shawn Tayler stayler
Mon Mar 26 06:14:36 PDT 2007


On Fri, 16 Mar 2007 09:23:20 -0700 Bill Campbell <linux-sxs at celestial.com>
exclaimed:

> On Fri, Mar 16, 2007, Shawn Tayler wrote:
> >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. 
> 
> There are some connectors available for python to allow access to M$SQL,
> and I think the latest versions of sqlobject (an object based python
> system for accessing SQL databases) has M$SQL support.
> 
> Bill
> --


Interesting,

Not being at all familiar with Python, is this something that could be
scripted and run as a cron job with  the output dumping to a file or
stdout?

Shawn



More information about the Linux-users mailing list