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 ...
AlexAlex wrote:
Quote:
Originally Posted by
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/>|||ZeldorBlat wrote:
Quote:
Originally Posted by
Alex wrote:
Quote:
Originally Posted by
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|||tlyczko wrote:
Quote:
Originally Posted by
ZeldorBlat wrote:
Quote:
Originally Posted by
>Alex wrote:
Quote:
Originally Posted by
>>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/so...e10g/index.html
--
Daniel Morgan
University of Washington|||Alex wrote:
Quote:
Originally Posted by
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|||I'm looking into moving my desktop system at work to Linux from Windows
Quote:
Originally Posted by
Quote:
Originally Posted by
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
No comments:
Post a Comment