App to access Microsoft SQL database on Linux?

darkixion

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

altNull

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

darkixion

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

gomer

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!

Canownueasy

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

woboyle

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.