Managing MS SQL on Linux

[Alex]

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.

Thanks for any suggestions or ideas ...

Alex

[ZeldorBlat]

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.

Thanks for any suggestions or ideas ...

Alex

Using "is" with the -m flag you can query MS SQL Server databases. is
also has a whole bunch of other useful and cool stuff:

<http://gagne.homedns.org/~tgagne/is/>

[tlyczko]

ZeldorBlat wrote:

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

Use RDP or any method like UltraVNC, TightVNC, etc. etc. that allows
you to log in to the SQL server itself and do your stuff...then you can
use SSMS and all its goodness...I RDP all the time to my servers. No
harm done.

HTH tom

[DA Morgan]

tlyczko wrote:

ZeldorBlat wrote:

>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

Why not Oracle Database 10g Express Edition? It is completely free and,
it runs on both Windows and Linux. It is a fully functional Oracle
database engine.

http://www.oracle.com/technology/sof...10g/index.html
--
Daniel Morgan
University of Washington

[Robert Klemme]

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

[timseal]

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.

Try Squirrel SQL http://squirrel-sql.sourceforge.net with jtds that
someone else mentioned. It's the best open source database admin tool
I've found so far.

tim