MSSQL Access under Linux

[Michael Hipp]

Shawn Tayler wrote:
> 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?

Yes. Python can be used from the command line. I use it often where the 
calculations or data structures needed don't play well in bash.

Michael