DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source universal database tool for developers and database administrators.
DBeaver vs SQL Server Management Studio opinions
Connect to "MS SQL 2017 for Linux" - Out of the box (server and DBeaver - linux- Archlinux), clean look, nice, cool
Installs SQL Server plugin automatically and works fine.
Connected without much effort. Always a must in IT for FAST solutions.
Azure Data Studio (formerly SQL Operations Studio) is a free, light-weight tool, that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they're running.
Azure Data Studio vs SQL Server Management Studio opinions
This seems a really promising project. Now just a "preview" (alpha i guess? version 0.24). Hopefully this will evolve in a truly great SSMS alternative for Linux.
Don't allow schema diagrams
It runs on the Mac. I have not tested the other ones.
It's still in its infancy, but it does the basics. I can't picture myself actually developing in ADS, but that could change as time goes on. I already prefer to store my dev databases on Azure so that they are always available.
There are a number of extensions available for AzureOperationsstudio that help with managing the SQL server.
Preview for Windows has functionality of SSMS + better look-and-feel. For folks unaccustomed to writing/comprehending VS Code, some configuration tasks like adjusting interface settings may be a challenge.
HeidiSQL is a useful tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.
HeidiSQL vs SQL Server Management Studio opinions
is resolved my problem with SSMS
Can generate DB creation scripts with data and schema
Easy light and simple to use!
Open Source SQL Editor and Database Manager for MySQL, SQL Server, Postgres, Redshift, Sqlite and more.
SQuirreL SQL is an open-source Java SQL Client program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
SQuirreL SQL vs SQL Server Management Studio opinions
It works perfectly on Linux. Nice and comfortable to work with.
A Visual Studio Code extension for developing Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere with a rich set of functionalities, including:
mssql for Visual Studio Code vs SQL Server Management Studio opinions
Open Sqlite databases and explore the internal organisation of various objects such as schema, tables and indices. To understand how Sqlite3 data is organised, please see Database file format from Sqlite website.