Welcome to the Linux Foundation Forum!

App to access Microsoft SQL database on Linux?

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).




  • Are you wanting a command line tool or a gui tool?
  • A GUI tool really. Something equivalent to pgAdmin III, but for MSSQL.
  • gomer
    gomer Posts: 158
    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!
  • 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.

  • woboyle
    woboyle Posts: 501
    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.


Upcoming Training