DbVisualizer Reviews & Product Details

Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer. Review collected by and hosted on G2.com.

From a functionality standpoint, I have no dislikes. The only dislike I can think of is from the licensing standpoint of not having the option to purchase a lifetime license. I don't like having to renew/upgrade my license every major release. Review collected by and hosted on G2.com.

The interface for directly editing content of rows to avoid needing to write lengthy SQL is nice. As is the ability to use menus to modify tables. Review collected by and hosted on G2.com.

Somehow it got worse after updating. Some abilities were lost and things were moved around in ways that made them hard to find. I haven't updated since for fear of losing more... Review collected by and hosted on G2.com.

Connect multiple sources and change parameters in UI E.g changing format of dates Review collected by and hosted on G2.com.

UI is not much friendly, sometimes user have to struggle to get to correct place Review collected by and hosted on G2.com.

The management of your sql queries is awesome. This program is so much easier than Visual Studios. You can load all your sql's from a folder and have them to copy and paste into new queries. Review collected by and hosted on G2.com.

No export to Excel button. We always export to Excel and this version does not have a button for it. I hear through the grape vine that it is coming though. Review collected by and hosted on G2.com.

Easy Setup.

Simple tool layout

Good for handling XML in tables Review collected by and hosted on G2.com.

I dint see anything bad as of now. Will update as when I find one Review collected by and hosted on G2.com.

Easy to use, fast to learn, no problems with picking up where you left off after leaving the program. Fast upgrades / updates. Review collected by and hosted on G2.com.

Not entirely intuitive - especially when looking for a specific feature or table. Review collected by and hosted on G2.com.

It is a open source that is very reliable quick and fast Review collected by and hosted on G2.com.

In the free edition CLOB object cannot be viewed directly and you cant export data from a table in sql format Review collected by and hosted on G2.com.

We use this software because it is cheap and good enough I suppose. Review collected by and hosted on G2.com.

The worst thing is they took away the error checking feature where it highlights the line and location of the SQL error. It was available in 9.5 Review collected by and hosted on G2.com.

DB Visualizer has easy setup and while there's a learning curve, I've found it friendlier than some other tools that have limited capability to a single db type. The fact that it can access so many types in one interface with a common toolset/interface is very handy; the upfront learning curve is negated a bit by not having to learn several other apps. Review collected by and hosted on G2.com.

A very seldom crash here and there. I can leave it up for days and sometimes weeks, revisiting every day or so for my needs, and it's steadfast. Some things seem slower than native tools, like pulling up a list of Views, but the rest seems as snappy. Depends on the connection to the database, of course. Review collected by and hosted on G2.com.

DbVisualizer has a free version that is very full-featured. Capabilities are nearly identical with Oracle SQL Developer. The only feature I found that Developer has the DbVisualizer free doesn't is the ability to highlight a section of SQL code to execute on its own. DbVisualizer allows the programmer to set the number of rows to return. This allows one to run the full query by putting a number higher than the expected full return. The query can be reviewed on screen, then exported to CSV if desired. Developer does this differently, as it has a default 100 row limit. More rows are automatically added as one pages down in the results. An export in Developer runs the full query in the background. Review collected by and hosted on G2.com.

There is really nothing I dislike. It would be nice if the free version had the highlight a code section to execute, especially since Oracle's SQL Developer has it and is also free, but other than that, no complaints. Review collected by and hosted on G2.com.