#1 most frequent
United States of America
71.9%169 installations of 235
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
Top Performing Features
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
Areas for Improvement
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
Who Buys & Uses DbVisualizer
#2 most frequent
Canada
11.1%26 installations of 235
#3 most frequent
Germany
4.7%11 installations of 235
As good as advertised and more! Customer since 2003.
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
That tool replaces your SMSS easy
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
Ol' Reliable
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
Jeremiah's review
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
Very satisfied!
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
Usability
Alternatives Considered
pgAdmin, Oracle Database, MySQL, DBeaver and Oracle SQL Developer
Other Software Used
Notepad++, Nagios Core, IntelliJ IDEA, Microsoft Visual Studio Code, Docker, KeePassXC
