Can I install SQL Server Management Studio on Ubuntu 16.04?

Question

https://www.quora.com/Can-I-install-Microsoft-SQL-management-studio-in-Ubuntu-If-yes-how — John Joe, Jul 19 '18 at 06:58
Microsoft now pushes [Azure Data Studio](https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-2017) with a Linux download link on this page. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built in charting of query result sets and customizable dashboards. — NachoSO, Sep 19 '19 at 00:04

score 19 · Accepted Answer · edited Jun 12 '20 at 14:37

19

No. You can use SQL Server Management Studio on Windows to manage SQL Server on Linux but the software itself needs Windows. The link from Microsoft does have a tip about a new tool that can:

Tip

If you do not have a Windows machine to run SSMS on, consider the new SQL Server Operations Studio. It provides a graphical tool for managing SQL Server and runs on both Linux and Windows.

SQL Server Operations Studio is currently only available as a preview but does have a download to a DEB installer.

Installation after downloading the deb:

cd ~
sudo dpkg -i ./Downloads/sqlops-linux-<version string>.deb    
sqlops

edited Jun 12 '20 at 14:37

Community

1

answered Jul 19 '18 at 08:44

Rinzwind

293,910
41
570
710

12

Now it is called Azure Data Studio – heroin Oct 09 '18 at 12:17
1

link to Azure Data Studio : https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio – Thomasleveil Jul 31 '20 at 09:52

score 6 · Answer 2 · edited Jan 26 '19 at 00:16

6

You can use Visual Studio Code (from Linux, Windows, Mac) to connect to SQL Server.

Here is a tutorial how to connect to SQL Server on Azure.

edited Jan 26 '19 at 00:16

Pablo Bianchi

14,308
4
74
117

answered Jan 25 '19 at 17:50

user2341923

161
1
1

this is great idea, noting to install just use VSSCode. – A_Name_Does_Not_Matter Sep 18 '21 at 04:48

score 1 · Answer 3 · answered Jun 03 '20 at 14:26

1

You can use Beekeeper Studio to manage multiple SQL databases. Beekeeper Studio

answered Jun 03 '20 at 14:26

H. Najafi

83
1
1
8

This works but has very limited features as compared to the SSMS. – Eswar Sep 12 '20 at 11:42

user3784191 · Answer 4 · 2021-03-13T00:40:39.720

1

Microsoft renamed SQL Server Operations Studio to Azure Data Studio. You can read about it and download it on this Microsoft official website:

https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15

edited Mar 13 '21 at 00:40

answered Mar 12 '21 at 23:39

user3784191

11
2

Can I install SQL Server Management Studio on Ubuntu 16.04?

4 Answers4