28

I occasionally need to do minor edits to a MS-SQL database running on one of our servers...

I'm using an evaluation of DbVisualizer at the moment to do this (it's Java based and uses something called the jTDS JDBC driver to talk to MS-SQL)... trouble is it's expensive and I'm wondering if there is anything else I can use.

I'm preferably after something which is either a native application (or Java, Python, Perl etc...) but not Windows/Wine/Mono.

Something which has a similar UI to MySQL Workbench or DbVisualizer which I'm currently using.

Any ideas?

47

I use DBeaver. There is a Debian package (.deb) available at their website. It is similar to MySQL Workbench.

To install: download the .deb file from the download page, change to the directory you put the DBWeaver deb in and run sudo dpkg -i dbeaver-*.deb.

4
  • 1
    Might want to include install instructions... – You'reAGitForNotUsingGit Jun 17 '16 at 15:22
  • @AndroidDev done. – Jos Jun 17 '16 at 15:30
  • just installed today and this though open source and free( the CE) seems amazing. Try to import a .bak file( a SQL Server DB but not sure how to) – Carmine Sep 8 '19 at 12:45
  • Awesome! ... take the upvote :) ... finally found a MSSql on Linux .. without a direct local install of Java ... as with the others I have seen as its in Snapcraft. Been avoiding installing java with the other ones I've come across. snapcraft.io/dbeaver-ce ... Still see a java client required, however, it's in a snap as far as I can see and should be isolated. – Hillsie Feb 23 at 0:04
7

Sqlectron is an open-source, cross-platform SQL client with a clean, simple GUI that supports Microsoft SQL Server (along with PostgreSQL, MySQL, Cassandra, and SQLite).

4

The simplest way to install dbeaver in Ubuntu:

sudo add-apt-repository ppa:serge-rider/dbeaver-ce
sudo apt-get update
sudo apt-get install dbeaver-ce

Run the dbeaver:

dbeaver-ce

After to install it, you can create a shortcut in desktop area using the option Create Laucher and typing the "dbeaver-ce" in command field.

3

SQL Operation Studio, runs on Windows, MacOS, and Linux. A great review is here on RedGate website. What is great is that now there is an extension for SQL Profiler, also the intellisense and document format are great.

I quote from their website:

SQLOPS is the new open source, multiplatform tool for working with SQL Server. We began by seeing how easy it is to install, then showed the interface. Next, we looked at some common tasks such as editing queries, then reviewed the cool snippets feature. Finally, we looked at how to ‘peek’ into your database. Although still in preview, SQLOPS already has many features that make it a worthy addition to your toolkit."

2
  1. You can use SQLOps, now also called Azure Data Studio. You should be able to get it here : https://aka.ms/sqlopsstudio : and run it on Windows, Mac, or Linux.
  2. Run SSMS on a completely different machine and connect to the machine and SQL Server instance that you want to control.
  3. Install Oracle's Virtual Box on the server machine, install Windows inside VirtualBox, and SSMS within Windows. Then connect SSMS to your server instance ...
2

For developers who are using Visual Studio Code on Ubuntu, another option would be to install the SQL Server extension:

https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql

This extension allows you to access multiple SQL server databases, run queries and scripts directly from the IDE, as well as perform other operations and tasks.

For simple use cases, I've found this to be a quick and easy option for MS-SQL access on Ubuntu, without the need for installing separate software.

0

Looks like there are a few other too as well as DBeaver..

SQuirreL SQL Client

SQL Workbench/J

Got to say though I do prefer DBeaver as it downloads required drivers for you and has a .deb package ready made.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.