DBeaver vs. SQL Server Management Studio (SSMS)

If you are connecting to Snowflake and want to query from your laptop, I find that this is much easier to use than Snowflake's IDE. It allows us as a business intelligence team to more easily connect to our servers, and code with much less hassle. It would be less appropriate if you are only on an on-premises SQL server, in that case, I would just use SSMS.

Incentivized

The tool is excellent for managing virtually all aspects of SQL Server - multiple servers, databases, hundreds of tables and procedures, dozens of SQL Agent jobs. We have not encountered any situations where it is not appropriate.

Incentivized

• Identify types of DB connections by color code: development, testing and production.
• Predictive typing, it is incredibly accurate and saves me a lot of time.
• Jump between different simultaneous DB connections.
• Navigate through the schema object tree.
• Provide all the tools I need in one window.

• Database queries
• Database management
• Table design

Incentivized

• Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
• Sorting and filtering in data is nice, but buried in long right-click menus.
• Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.

Incentivized

• Sorting of executed queries not available
• Quality of life improvements on folders and managment
• Some outdated tools that need revamping

Incentivized

It's perfectly easy to use. Not super new and shiny with lots of accessibility tailored tools, but does the job

Incentivized

It's very user friendly. If you know T-SQL then you can use this. Really even if you don't it's not that hard to figure out. You can create things visually as well.

Incentivized

Not a lot of users have DBeaver so fewer resources are available online to help you if you have any issues. When I was trying to figure out how to create my own ER diagrams, it was a little tough to find resources

Incentivized

MySQL workbench from MySQL only supports MySQL databases and it only provides basic functionality. On top of that, the user experience could be quite confusing for first-time users. SSMS from SQL server doesn't support inline editing nicely. The view for inline editing and view data is different, making it uncomfortable to use. All in all, DBeaver is the best tool when you manage a lot of databases with different types.

Incentivized

SSMS is very efficient and aids to do multiple tabs easily

Incentivized

• Positive Ability to manage DBeaver and query ad-hoc quickly
• By having the queries saved it has saved developer time and thereby increased the ROI on the investment on the tool
• This has made firefighting quicker and freed up resources for more development work.

Incentivized

• SQL Server Management Studio is our go-to tool for almost everything we do with SQL Server. Highly efficient and flexible.
• Compared to other alternatives, I would say we save at least 25% of the overall time we need to spend working in SQL Server.

Incentivized