Posted by Robert Klemme on 06/15/56 11:58

Alex wrote:
> Hi everyone,
>
> I'm looking into moving my desktop system at work to Linux from Windows
> XP, and one tool I've yet to find a suitable replacement for is MS SQL
> Enterprise Manager. I mainly need to query MS SQL databases from
> Linux, and management tasks (monitor backups, services, etc) can be
> done on the MS SQL servers themselves. THere was an application I used
> to use on OSX which would connect to a variety of databases, including
> MS SQL, and they had a Linux version of the client .. but can't
> remember the name. But really any Sybase client that can connect to MS
> SQL with some ease will work.

If you are mainly querying SQL you can use FreeTDS which comes with a
command line query tool aka osql IIRC. Other than that there are some
free Java based tools around that can execute SQL on any DB with a JDBC
driver and some of them are even capable of displaying meta data. One
of them is http://www.sql-workbench.net/ - you may find more here:
http://www.databaseanswers.com/modelling_tools.htm
http://www.javaskyline.com/database.html

Kind regards

robert

[Back to original message]