Graphical MS-SQL Clients for a Ubuntu Desktop
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?
Solution 1:
I use DBeaver. There is a Debian package (.deb) available on 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
or run sudo snap install dbeaver-ce
for snap users and run sudo flatpak install flathub io.dbeaver.DBeaverCommunity
for flatpak users.
Solution 2:
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).
Solution 3:
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.
Solution 4:
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."