Item: DbVisualizer
Rating: 10
Author: Verified User

Use Cases and Deployment Scope

I access Databases for personal and professional purposes, across different system. I am a software engineer to use DbVisualizer to create, maintain and query schemas.

Pros and Cons

Export all table Schemas with one operation
Search a result set for a string value quickly
Export entire schema table data to a single file with a single command
Export data options very detailed and comprehensive - CSV, text, excel - all are handled
Ability to quickly edit and rename tables and fields
generate DDL and SQL scripts from a table easily

code formatting in SQL Editor would be nice
Basic autocomplete in SQL editor
Ability to create text shortcuts/macros to fill commonly used strings eg. create a shortcut/macro so that typing 'sel' then hitting TAB key will insert 'select'

Return on Investment

No specific ROI data for software engineering

Alternatives Considered

Oracle SQL Developer, DBeaver and pgAdmin

Oracle product - clunky UI, no mass DDL or data export. Bad editor
DBeaver - setting JDBC drivers manually is a pain. Clunky UI.
pgAdmin - good for pure DB admin, but SQL and table management is clunky.

Key Insights

Do you think DbVisualizer delivers good value for the price?

Yes

Are you happy with DbVisualizer's feature set?

Yes

Did DbVisualizer live up to sales and marketing promises?

Yes

Did implementation of DbVisualizer go as expected?

Yes

Would you buy DbVisualizer again?

Yes

Other Software Used

IntelliJ IDEA, GitHub, Sourcetree

Likelihood to Recommend

Really good tool for accessing a new DB schema to understanding e.g. DB schemas in big organisations with zero documentation. I can dump entire DDL to a single file and the data as well, so I can search entire database using grep for a string occurrences, and then figure out the data model in this bottom-up fashion.

It's less well suited for writing/designing large SQL and DDL files because of lack of formatting, autocompletion - I need to use an IDE to create all my big scripts, then test them in the tool.

Great all-round DB Client with strong bulk schema and data manipulation capability

Overall Satisfaction with DbVisualizer