[sllug-members]: Microsoft SQL Server

[Doran L. Barton]

Not long ago, Jackman proclaimed...
> 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.

It should be fairly straight forward to connect to a M$-SQL server from
Perl (using the DBI module) or Java (using JDBC and/or Hibernate). The
UnixODBC folks < http://www.unixodbc.org/ > can probably provide some more
information about command-line utilities for more generic interaction, but
if you're looking for the ability to automate/script queries and other
database operations, I would highly recommend Perl+DBI.

-- 
Doran L. Barton <fozz at xmission.com> - Linux, Perl, Web, good fun, and more!
 "Auto Repair Service. Free Pick-up and delivery.  Try us once, you'll
  never go anywhere again."
    -- Classified ad in newspaper
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://sllug.org/pipermail/sllug-members/attachments/20080401/f3bd19b4/attachment.pgp