21

Can I install SQL Server Management Studio on Ubuntu 16.04?

Patrick Hofman
  • 103
  • 5
Anas Shamsi
  • 313

4 Answers4

22

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
Community
  • 1
Rinzwind
  • 309,379
7

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.

Pablo Bianchi
  • 17,371
user2341923
  • 171
1

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

H. Najafi
  • 83
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

user3784191
  • 11