DBeaver is used by me to work with SQL Server databases.
Pros
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.
Cons
Some icons are kinda small and difficult to understand what they do
The spanish translation could be better
I think there are many functions that could be useful for me but I don't know what they do
Likelihood to Recommend
It is the perfect sidekick for every day's database work with SQL Server (I guess with other databases as well). Whether you need to browse data, import/export, alter database objects, compare objects, view automatically generated database diagramas, and so on. I regret every day I spent using SSMS without knowing this tool existed.
I use DBeaver as a graphical interface for accessing databases locally and remotely for testing and data analysis. It allows easy access to viewing data and running SQL Queries against the data as well as updating test data locally.
Pros
Running SQL Queries
Displaying data
Sorting data
Viewing multiple tables
Cons
UI can be cumbersome and confusing
Constant updates creates multiple reminders
Likelihood to Recommend
DBeaver does a lot and has a lot of features, especially for free. Sometimes this amount of features makes the UI tricky to navigate and sometimes it will take more time to get to the place you want to get to. I wouldn't recommend DBeaver for beginners as it may overwhelm them. Still, you can't beat how much control it gives you.
DBeaver is used by both software developers and people who are responsible of support services for a web application with large user base. It allows developers to quickly view and modify database as they are developing the application and testing features. For support people it helps to solve customer queries which need to get information from the database. They also use it to modify database when configuration options for the application needs to be changed.
Pros
Easy to make and restore backups.
Good UI for viewing table data & schema. No more command line ever again!
Overall has a large feature set for all database related tasks (users, events etc...)
Cons
The UI is not very modern and looks dated.
A barely noticeable delay when changing views.
Likelihood to Recommend
It's really suited for any scenario related to database management. That includes both viewing the database and making changes. It beats doing things from the command line in every way and helps to avoid doing mistakes because doing things from UI is much more intuitive. Supports large amount of different database vendors.
VU
Verified User
Employee in Information Technology (1001-5000 employees)
Our development staff uses DBeaver for editing database/table schema (when needed) and for creating production deployment scripts. We are using the free community edition and it is extremely stable and works very well. Since it supports multiple databases, we can also use it for Microsoft's SQL Server, but we currently only use it for PostgreSQL. Compared to other products on the market, it did what we needed to do, even though sometimes the UI can be a little unintuitive compared to what we are used to with SQL Management Studio.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
Pros
Data import/export and SQL Script generation are quick and simple to do.
Fairly intuitive when viewing/editing table data.
Ability to save SQL scripts per server and recall them easily.
Handy intelligence when writing queries, functions, and stored procs.
Cons
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.
Likelihood to Recommend
Great tool for developers to use to dive into their databases. Not so great if you are a die-hard Windows user with expectations of a SQL Management studio replacement. This is the less suited tool for people looking to just view and edit data. If you need to generate any scripts or import and export data, this is the tool to use.
