What can you tell me about DBeaver?

Question

Post reply

What can you tell me about DBeaver?

Doctor Who 2

SSCrazy Eights

Points: 8177
More actions
October 14, 2017 at 7:27 am

#340755

One of my colleagues at work uses DBeaver for analyzing the databases he needs to work with. I've never heard of it. What experience have you got and what do you think of it?
Rod

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 1

Looks interesting but this is the first I've heard of it, Rod.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Thom A SSC Guru Points: 99126 More actions · Answer 2

I can't tell you a lot either I'm afraid. I do have it, and use it, but that was due to more necessity than choice; SSMS isn't available on Linux and VS Code with the mssql extension is a poor substitute for an administration tool.

It took me a little while to get used to it. Obviously it differs to SSMS, and doesn't have the full functionality, but it's not half bad. No dialogue window for SQL Server Agent for example and it can't connect to SSRS/SSIS, etc. I have no idea how it would handle SSISDB (if at all), and you can't set up or view Extended Events in it. Well, i say these, I can't see how you would, but maybe there are extensions for it out there (it is an opensource product after all).

First thing I had to do was change all the key bindings though. Shift+F3 for a new window, Ctrl+X for execute a SQL Script; it all felt very foreign. every now and then i use a keystroke i don't often use and I'm wondering why it's doing something else.

If you have the option of SSMS with SQL Server, I'd stick with it; it's a tool SQL Server was designed to be used bwith. If you're not on Windows, or using a different service, then I'd say it's worth a look at.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Doctor Who 2 SSCrazy Eights Points: 8177 More actions · Answer 3

@thom-2 A, I do stick to SSMS. I love SSMS, in fact. However, in my co-workers case he's got to help maintain this third party app that's critical. The vendor used some database that I've never heard of before. This other database didn't have any management tools, so my colleague found this DBeaver suite which makes his life much easier. I was thinking DBeaver might be useful for MS Access, too.

Rod

gcleggs SSC Rookie Points: 47 More actions · Answer 4

I use DBeaver testing Oracle queries on a daily basis at my job due to not being allowed to use an Oracle Client like SQL Developer. It is good for testing your queries before embedding them in a tool like SAS EG. I have tested it with SQL SERVER 2014 on my home machine with very few issues, although since I have SSMS, SSMS is my preferred tool for SQL SERVER.