DbVisualizer
Your rating: Now say why...

(2) 4.5

Cross-platform database visualization and management tool.   Demo ($179.00)
Add to my Watch List
Email me when discounted
DbVisualizer is a feature-rich, intuitive, cross-platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections; it lets you explore and manage database objects, execute SQL queries, visualize information, and a lot more. Free of charge for commercial and non-commercial use. This edition provides basic level features useful for most users.
What's New
Version 9.1.8:

Enhancement:

  • Command Line Support (dbviscmd): Make it possible to execute a large script specified by -sqlfile
  • DB Support: NuoDB: Add support for NuoDB domains and sequences
  • DB Support: Sybase ASE: Add support for CLUSTERED keyword in CREATE INDEX DDL
  • Database Search: Add button to select target database objects in the Databases tab from the Database Search result list
  • Key Bindings: Add Alt-Backspace as binding for Delete to Word Start and Cmd-Backspace as binding for Delete Preceding Characters in Line for Mac OS X. Also add Meta+Shift+A for Select None in SQL editors for all platforms
  • Query Builder: Automatically set a table alias if a table is added multiple times
Bug:
  • Chart: Bar/Stacked Bar charts doesn't display
  • Create/Alter Table: Regression in copy/paste of column details (paste does nothing)
  • DB Support: DB2 LUW: The "Empty Table" action to truncate a table doesn't work with DB2 10 and later
  • DB Support: DB2 LUW: DDL generation fails for a View if there is no whitespace between the AS keyword and the left parenthesis
  • DB Support: Informix: Synonyms cannot be dropped in Query Builder
  • DB Support: Oracle: Column order is not preserved in DDL for UNIQUE constraints
  • DB Support: SQL Server: DATETIME2, UNIQUEIDENTIFIER, GEOGRAPHY and GEOMETRY types are not handled correctly in DDL and Alter Table
  • DB Support: SQL Server: Add support for synonyms
  • DB Support: Sybase ASE: Columns tab for System Table shows columns for all tables in the schema
  • DB Support: Vertica: Vertica: Loosing DB connection while working in the SQL Commander doesn't prompt for reconnect at next execute
  • Database Search: Database Search list should show object paths of found objects by default
  • Export: Exporting to XLSX with appendFile="clear/true" may result in errors on Mac OS X
  • Grid Component: Incorrect handling of database when saving grid updates for a query with a fully qualified table for Informix, Sybase ASE and SQL Server
  • Monitor: Settings in a monitor may be cleared or lost from the Monitors window
  • Monitor: An IllegalStateException may be reported while reloading monitors
  • Monitor: Series and category drop-down menus may not reflect the columns in the underlying result set
  • Performance/Stability: Clicking Create Heap Dump in the High Memory Usage dialog when one exists causes an error
  • SQL Commander: Script files executed with the @run command should be closed directly at the end of execution
  • SQL Commander: File->Revert to Saved and Compare with Saved should always be available when file is loaded

Version 9.1.8:

Enhancement:

  • Command Line Support (dbviscmd): Make it possible to execute a large script specified by -sqlfile
  • DB Support: NuoDB: Add support for NuoDB domains and sequences
  • DB Support: Sybase ASE: Add support for CLUSTERED keyword in CREATE INDEX DDL
  • Database Search: Add button to select target database objects in the Databases more...
Requirements
  • Intel
  • OS X 10.7.5 or later
  • Oracle Java 7 (1.7.0_40 or later to resolve blurry fonts on Retina displays) [for Apple Java 6 support, see Related Links]





MacUpdate - DbVisualizer



DbVisualizer User Discussion (Write a Review)
ver. 9.x:
(2)
Your rating: Now say why...
Overall:
(8)

sort: smiles | time
burypromote

+5

jmrx reviewed on 10 Sep 2013
I've been using DbVisualizer since 2006 and have been a happy customer ever since. Updates appear on a regular basis and customer support is quick and helpful.

Yes, the program is written in Java and it does not look 100% native. But still it looks and feels great. I have seen native Cocoa Apps which feel sluggish and unpolished in comparison.

The SQL editor is fast and comes with syntax highlighting, auto-completion and all sorts of (configurable!) keyboard shortcuts. It is lacking a vi-mode though.

What makes DbVisualizer really shine is its graphing feature. Similar products can create visualizations of a database schema as well, but only DbVisualizer produces a layout that does not look like a knot of spaghetti.

DbVisualizer is an excellent product for a very reasonable price.
[Version 9.1]


burypromote
-1

-1

Bobthevisitor reviewed on 05 Mar 2013
This is a really professional tool to query every possible database accessible by JDBC. I use it daily and professionally and albeit the UI is not Mac-like (Java) it's power features are hard to find anywhere else. Import and Export is highy configurable, syntax highlighting and completion as you would expect. I use it mainly for Informix, Oracle and MySQL Databases without any problems so far (started with version 7 and currently 8) - I highly recommend taking a look at it. Well worth the money if you are a pro.
[Version 9.0.5]


burypromote
+1

+51
Mutant commented on 15 Feb 2010
Draconian install, very un-userfriendly. First thing that pops up is a "buy me" dialog. It's listed as free, so I assume it's for support only.
SQLite access didn't work. mysql over ssh worked fine, would be nice to have a httptunnel, but I won't complain. postgresql worked, MSSql seemed to work fine.

In all however, I didn't see the use in this over a dedicated tool like phpMyAdmin, Mysql studio, or MSSQL Studio. This brought nothing more to the table than an interface to type in sql commands and view data. No typeahead hints, no autotable completion, nothing special in any way. I suppose it's a decent way to keep all your databases in one spot, but without even an SSH tunnel manager, it's more work to create the connections than to manage the tool.
[Version 7.0.2]

3 Replies

burypromote
Dbvis Software (developer) replied on 29 May 2012
Can you please tell where this "buy me" dialog pops up? SSH is built-in and no external tunneling is needed. Auto completion has been supported since version 4. DbVisualizer is available in two editions the "Free" and the commercial "Personal" edition. Some of the features you mention are available only in the commercial edition which is a quite common setup.
burypromote

+51
Mutant replied on 29 May 2012
Wow.. I wrote that 2 years ago. I'm sorry I can't recall the specifics.
burypromote
Dbvis Software (developer) replied on 29 May 2012
No problem :-) Just browsed the comments and thought it would be a good idea replying.
burypromote
-1

+18
barefeettom commented on 19 Apr 2008
Here's a detailed comparison of DbVisualizer with alternative SQLite GUI programs:
http://www.tandb.com.au/sqlite/compare/
[Version 6.0.10]


burypromote
+1

+18

barefeettom reviewed on 12 Mar 2008
DB Visualizer seems to be the most full featured SQL GUI tool out there. It has some data entry aids that really make it viable, such as automatic form view (on record per screen), adjustable grid views and filters for everything from table listing to rows of data. Some of the tools and options aren't immediately obvious but very impressive once you find them.

It's a Java app which limits a lot of Mac OS X integration (eg all the windows move in Spaces together) and some controls (such as tabbed panes) don't work in the standard Mac way. It's "Mac Look and Feel" setting makes DbVisualizer more palatable than most Java apps, but it's still a bit ugly and non-intuitive for Mac users.

DbVisualizer, uses JBDC drivers to connect to the database. That takes a bit of fiddling which would scare off most users. I've tried two available JDBC drivers with SQLite (the most prolific database on the Mac) and only get limited functionality. For instance, I can't get DbVisualizer to show me the source of a selected table or view, I can't see triggers in the list. Every time I make changes to data, DbVisualizer complains that "no rows were affected by this edit", but the changes were actually made.

Overall it's a great program that I can't yet use until SQLite access is fixed.
[Version 6.0.8]


There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.


Rogerbj rated on 29 May 2012

[Version 8.0.9]



+1

sferrazzi rated on 15 Feb 2012

[Version 8.0.8]



Radoslav Bogdanovic rated on 22 Nov 2011

[Version 8.0.6]



-1

Bobthevisitor rated on 04 Nov 2011

[Version 8.0.5]



Rogerbj rated on 07 Aug 2011

[Version 8.0.2]


Downloads:21,789
Version Downloads:49
Type:Development : Java
License:Demo
Date:16 Apr 2014
Platform:Intel 64 / Intel 32 / OS X
Price: $179.00
Overall (Version 9.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-5 of 5
Displaying 1-5 of 5
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
DbVisualizer is a feature-rich, intuitive, cross-platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections; it lets you explore and manage database objects, execute SQL queries, visualize information, and a lot more. Free of charge for commercial and non-commercial use. This edition provides basic level features useful for most users.


- -