3 ms·
SSMS is a really good free database management IDE/GUI/tool for MS SQL Server. It can do graphical live query profiling, index management, management of views/s
by wenc 8y ago
SSMS is a really good free database management IDE/GUI/tool for MS SQL Server. It can do graphical live query profiling, index management, management of views/stored procedures/triggers/constraints/functions etc.
Postgres currently has nothing comparable. DataGrip, though proprietary, is the closest in terms of functionality, but even it doesn't have the tight integration with the database that SSMS has.
If you've used SSMS, other database GUIs feel underpowered. (Oracle SQL Developer is ugh)
- atonse 8y agoAgreed, I actually really like SQL server especially because of SSMS.
- wenc 8y agoOne of SSMS's strengths, as opposed to a generic database GUI IDE, is that it only works with one database: SQL Server (and variants like Azure SQL). This is important for accessing the specific features that distinguish that database from others, e.g. indexed views, clustered columnar indices, user-defined types, functions, linked servers, replication, HA, etc. There are so many cool and interesting features in MS SQL Server. I don't go for Microsoft products in general, Microsoft really got SQL Server right.
- AlfeG 8y agoI use Dbeaver. Its not a ssms, but very handy tool
- wenc 8y agoI've used it too. It's one of the best free tools of its ilk. But yes, it's not SSMS.