[sllug-members]: Microsoft SQL Server

[John M. Anderson]

On Tue, Apr 01, 2008 at 05:45:55PM -0600, Jackman wrote:
> Ladies and Gentlemen,
> 
> Where I work, everything revolves around a row of very large servers
> with MS Windows NT running Microsoft SQL Server.  To connect to this
> server, I use primarily Microsoft SQL Query Analyzer and Microsoft
> Enterprise Manager.  My work is generally very tedious, mostly because
> MS software doesn't script very well.  I can bring my laptop into
> work, however, or install cygwin and work from those machines if I so
> desired.  Scripting and collecting data would be so much easier on a
> linux box.  Still, I know that MySQL is the SQL database preference on
> Linux systems and so I am having a difficult time finding anything
> that advertises itself being compatible with Microsoft SQL Server.
> Does it even matter?  Thank you for your help and I look forward to
> your input.

You can use UnixODBC with FreeTDS or Monodevelop... Monodevelop has a 
nice gui, but if you are looking for scripting support I'd just use
UnixODBC. Any tool that supports ODBC should be able to connect to MSSQL.