DbVisualizer

Score8.8 out of 10

86 Reviews and Ratings

What is DbVisualizer?

DbVisualizer is a multi-database tool for developers, analysts and database administrators, providing a single interface across a wide variety of operating systems. Boasting an easy-to-use and clean interface, DbVisualizer runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.

Categories & Use Cases

Media

1 / 6

Schema maintenance
Maintaining schema integrity via regular maintenance
Category average: 8.7
Performance optimization tools
Performance optimization tools measure and maintain overall responsiveness and efficiency of queries, database structures, etc.
Category average: 8.4
User management
Tools to help manage user and role administration
Category average: 8.6

Database security
Security maintenance such as authorization management, log analysis, database auditing
Category average: 8.6
Database status reporting
Detailed reports on database performance, configuration, security, vulnerabilities, etc.
Category average: 8.6

Joseph Pesce View profile

CEO in Engineering at TECASSURED llc (11-50 employees employees)

Use Cases and Deployment Scope

@ TECASSURED we are a software plateform provider - our ADMIN system solution provides each client with 2 database priority to their instance. We manage 1000's of database with this DbVisualizer - awesome solution - happy customer for over 20 years. ;)

Pros

Manage multi database connection
drag and drop SQL statements
reporting

Cons

Quicker start up
scheduler to run Monitors/Files
Email from application

Return on Investment

very satisfied with Pro version solution and pricing
Free version for team members that only look at data is cost effective
annual updates and support are cost effective and useful

Usability

Other Software Used

Notepad++, Excel Chart Animation

Bernhard Reiter

Software Developer in Engineering at CrossVault GmbH (1-10 employees employees)

Use Cases and Deployment Scope

We are using DbVisualizer to manage easy access to a lot of different database systems for fast query and database manipulations.

Pros

Multiple Database Systems
Alter and Modify Database Structure
Mass Import and Export from Data

Cons

MSSql Server /Azure Driver connection timeouts/restort
Intellisense like behavior (autocomplete)

Return on Investment

One program instead of multiple
Plattform independed
Time saving performant bulk imports

Usability

Verified User

Consultant in Finance and Accounting (10,001+ employees employees)

Use Cases and Deployment Scope

The product I am in charge of requires data from 6 different sources across a handful of different driver types to run monthly processes. DbVis allows my analysts & me to have access to all sources in one convenient program.

Pros

Supports numerous drivers (Snowflake, SQL Server, Teradata, Hive, DB2, etc.)
Allows for full data set to be extracted (no forced row limits/"sample data" pull before the actual pull)
Customizable settings for font colors, processing capacity

Cons

Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
(I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)

Return on Investment

The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"

Usability

Alternatives Considered

DBeaver and SQL Server Management Studio (SSMS)

Other Software Used

SQL Server Management Studio (SSMS), SAS Enterprise Guide, DBeaver

Verified User

Project Manager in Information Technology (11-50 employees employees)

Use Cases and Deployment Scope

We use it to request our ERP, select and update, for reporting and error correction, daily with 11 users. As an insurance broker, our data are a critical thing, we also use DbVisualizer to planify requests during the night, we hope DbVisualizer will contain a scheduler in a later version.

Pros

batch
interactive

Cons

integrated scheduler
impossible to close other tabs in the actual version !!

Return on Investment

Facility for errors correction and reporting

Usability

Verified User

Administrator in Corporate (11-50 employees employees)

Use Cases and Deployment Scope

DbVisualizer allows me to much more efficiently perform my duties as a DBA. For example providing an overview of database structure, allowing me to easily view procedure and table definitions, enabling easy export of result set data for report generation, and the fact that I can keep several SQL Commander tabs open at once allows me to multitask well. I have tried many other similar products, but DbVisualizer is the only one I actually enjoy using.

Pros

Overview of and easy grouping of database connections
Wide variety of export options for result set data
Ability to view procedure definitions in an easy way
Per-connection customizable UI to for example give a visual cue of what kind of database one is connected to.

Cons

Being able to change the maximium heap space from within DbVisualizer would be very useful
There is a popup that appears when I hover over tabs for a moment, but after I move the cursor away and it disappears, it reappears immediately after I hover over the tab again which can get very annoying as it blocks whatever is behind it
The autofill feature is a little annoying as it will sometimes autofill every single column of a table when I press enter to make a new line in a query. It is still useful but I wish there was a way to more easily choose when or when not to autofill

Return on Investment

DbVisualizer allows me to work much more efficiently, making any tasks I have to perform take much less time, effort and work. I cannot provide any hard numbers for this, only my own experience