Linux.com

Home Linux Community Forums Software Desktop App to access Microsoft SQL database on Linux?

App to access Microsoft SQL database on Linux?

Link to this post 17 Feb 10

Does anyone know if a native client app for Linux for connecting to an MSSQL database server and viewing it like Enterprise Manager does, or even the awful Management Studio Express? Failing that, are there any free Windows apps that can do this which will work under Wine?

This is for work, so I'm not using MSSQL through choice, but at the moment I'm dependent on Windows for accessing such systems. Everything else I can do in Linux (or Ubuntu to be specific).

Thanks

Thom

Link to this post 18 Feb 10

Are you wanting a command line tool or a gui tool?

Link to this post 18 Feb 10

A GUI tool really. Something equivalent to pgAdmin III, but for MSSQL.

Link to this post 18 Feb 10

I've had luck in the past using FreeTDS (http://www.freetds.org/) and UnixODBC (http://www.unixodbc.org/) and UnixODBC comes with some GUI tools, but generally, I do most of my work on the CLI, so I used SQSH (meant for sybase, but MS-SQL is a re-write of Sybase anyway). I've never used it, but you can SybSQL (http://www.warmi.net/sybsql/index.shtml), too.

Good Luck!

Link to this post 21 Mar 10

You may also use VirtualBox, it provides you with automated virtualization - in which works properly on any processor.

VirtualBox is available for Windows (200x, XP, Vista, 7), Mac (OS X), and all Linux-based operating systems.

I have created a tutorial on it a while ago.

http://www.youtube.com/watch?v=eLRD5x1vDwE

Link to this post 24 Mar 10

I'd either use ODBC (second choice), or T-SQL (first choice). For T-SQL support on Linux see this: http://linux.die.net/man/1/tsql - you can install the FreeTDS package on your system and directly access Sybase/MS-SQL databases using Transact-SQL.

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board