469,133 Members | 1,203 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

Managing MS SQL on Linux

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

Sep 12 '06 #1
5 16970

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/>

Sep 12 '06 #2

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

Sep 16 '06 #3
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
Sep 16 '06 #4
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
Sep 18 '06 #5
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

Sep 18 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by student | last post: by
10 posts views Thread by Gerald | last post: by
1 post views Thread by sphinx.moro | last post: by
4 posts views Thread by Gary Hasler | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.