SQL Server Management Studio Alternatives
SQL Server Management Studio is described as 'SSMS is a software application that is used for configuring, managing, and administering all components within Microsoft SQL Server. It includes both script editors and graphical tools which work with objects and features of the server' and is a database manager in the development category. There are more than 25 alternatives to SQL Server Management Studio for a variety of platforms, including Windows, Linux, Mac, Online / Web-based and Android. The best alternative is DBeaver, which is both free and Open Source. Other great apps like SQL Server Management Studio are dbForge Studio for SQL Server, Azure Data Studio, HeidiSQL and DataGrip.
SQL Server Management Studio alternatives are mainly Database Managers but may also be Business Intelligence Tools or Relational Databases. Filter by these if you want a narrower list of alternatives or looking for a specific functionality of SQL Server Management Studio.- Free • Proprietary
- Database Manager
- Windows
DBeaver
Do you think this is a good alternative?YesNo- Freemium • Open Source
- Database Manager
149 alternatives to DBeaver- Mac
- Windows
- Linux
- Eclipse
- Java
DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source universal database tool for developers and database administrators.
DBeaver Features
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
5Installs SQL Server plugin automatically and works fine.
0Connected without much effort. Always a must in IT for FAST solutions.
0dbForge Studio for SQL Server
Do you think this is a good alternative?YesNo- Paid • Proprietary
- Database Manager
45 alternatives to dbForge Studio for SQL Server- Mac
- Windows
- Linux
dbForge Studio for SQL Server is an integrated environment for SQL Server development, management, administration, data reporting, analysis, version-control database changes and test data generation.
dbForge Studio for SQL Server Features
dbForge Studio for SQL Server vs SQL Server Management Studio opinions
scottcate59Great MS SQL tools for everyday use
1OVKPerfect code completion and source control
3Automate frequently-used database tasks via the command-line interface
0zompIf you are a SQL Server DBA then this is a fantastic tool. It's worth the money.
0adarshmadrechaSuperb GUI just like SSMS
0Azure Data Studio
Do you think this is a good alternative?YesNo- Free • Open Source
- Database Manager
31 alternatives to Azure Data Studio- Mac
- Windows
- Linux
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 Features
Azure Data Studio vs SQL Server Management Studio opinions
kurotsukiIt's look promising. It still in in early stage of preview (maybe late alpha or early beta), but it can do basic needs to access sql server. the UI also quite neat. No clutters visible at the moment. Hopefully, it can have more advance features SSMS has in the future. What surprise me is that this app is based on electronjs, a javascript framework for desktop apps which leave small footprint on my system.
2This 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.
0Don't allow schema diagrams
0It runs on the Mac. I have not tested the other ones.
0It'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.
1HeidiSQL
Do you think this is a good alternative?YesNo96 alternatives to HeidiSQL- Free • Open Source
- Database Manager
- Windows
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 Features
HeidiSQL vs SQL Server Management Studio opinions
is resolved my problem with SSMS
0Can generate DB creation scripts with data and schema
-1gabrielepettenoEasy light and simple to use!
0DataGrip
Do you think this is a good alternative?YesNo- Paid • Proprietary
- Database Manager
68 alternatives to DataGrip- Mac
- Windows
- Linux
DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
DataGrip Features
DataGrip vs SQL Server Management Studio opinions
Beekeeper studio
Do you think this is a good alternative?YesNo- Free Personal • Open Source
- Database Manager
75 alternatives to Beekeeper studio- Mac
- Windows
- Linux
- MySQL Community Edition
- MariaDB
- Microsoft SQL Server
- CockroachDB
- Amazon Redshift
- PostgreSQL
Open Source SQL Editor and Database Manager for MySQL, SQL Server, Postgres, Redshift, Sqlite and more.
Beekeeper studio Features
Valentina Studio
Do you think this is a good alternative?YesNo- Freemium • Proprietary
- Database Manager
76 alternatives to Valentina Studio- Mac
- Windows
- Linux
FREE native database manager for SQLite, MySQL, PostgreSQL, SQL Server and Valentina DB. PRO Edition adds Report Editor and Form Editor with JavaScripting and dozen features.
Valentina Studio Features
Valentina Studio vs SQL Server Management Studio opinions
Graphics query designer. Option to import data to a table directly from *.CSV file.
1uniphonicThere is one of the few free Mac clients with a nice graphical UI.
0SQuirreL SQL
Do you think this is a good alternative?YesNo- Free • Open Source
- Database Manager
73 alternatives to SQuirreL SQL- Mac
- Windows
- Linux
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 Features
SQuirreL SQL vs SQL Server Management Studio opinions
It works perfectly on Linux. Nice and comfortable to work with.
1DbGate
Do you think this is a good alternative?YesNo- Free • Open Source
- Database Manager
- Relational Database
145 alternatives to DbGate- Mac
- Windows
- Linux
- Online
DbGate is cross-platform database manager. Simple and effective, allowing to work with many various databases simultaneously - SQL and NoSQL.
DbGate Features
Tableplus
Do you think this is a good alternative?YesNo- Paid • Proprietary
- Database Manager
74 alternatives to Tableplus- Mac
- Windows
TablePlus is a native app which helps you easily edit database data and structure. TablePlus includes many security features to protect your database, including native libssh and TLS to encrypt your connection.
Tableplus Features
Tableplus vs SQL Server Management Studio opinions
Too basic, too few admin features
0