(3)
Your rating: Now say why...
DbVisualizer is a feature rich, intuitive and 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.
What's New
Version 8.0.7:
Improvement
- DB Support: DB2:Support multiple result sets generated by stored procedure for DB2 iSeries
- SQL Commander: Should be possible to force presentation of the real column name even if column alias is used in queries
- SQL Editor: Make it possible to have Find scroll match to center of editor rather than just enough to show the match
- SQL Editor: Make it possible to turn off the caret blinking
- DB Support Informix: Default value is missing in the DDL for NOT NULL character type columns
- DB Support SQL Server: An NVARCHAR(MAX) column is generated as NVARCHAR(0) in DDL
- DB Support SQL Server: No code is shown for procedures, functions and triggers if the database name contains a space or other special character
- DB Support SQLite:Column nullability and default value should be disabled in Alter Table
- DDL Generato: The primary key column order may be incorrect when using the Generic, H2, SQLite, Oracle or Mimer database types
- Export:Excel OOXML export may output special characters in wrong encoding
- Navigator:Related Table is not enabled when using Show in Navigator in the Data tab even when cells are selected
- OS Support: Mac OS XAdd workaround for the memory leak introduced in Java 1.6.0_29 on Mac OS X
- SQL Commander: Opening a non-existing file with File->Open Recent show truncated error and the file is then kept in the recent files list
- SQL Editor: Find All does not scroll to make the first match visible
- SQL Editor: Find Next does not use criteria set up by Find All
- SQL Editor:When pasting really fast after typing, Undo undoes both the typing and the pasting
- SQL Editor: Find does not reset highlighted matches made by Find All
- SQL Editor: Problem with special characters in the search string for Quick File Load
- Table DataEditor: Mime type for ZIP archives is wrong
- Table Data Editor: Unrecognized binary data is marked as modified just by opening it in the cell editing window
- Table Data Editor: Using column alias in selects may disable data editing for some databases
Version 8.0.7:
Improvement
- DB Support: DB2:Support multiple result sets generated by stored procedure for DB2 iSeries
- SQL Commander: Should be possible to force presentation of the real column name even if column alias is used in queries
- SQL Editor: Make it possible to have Find scroll more...
Requirements
- PPC / Intel
- Mac OS X 10.6 or later
- Java 1.6
- Mac OS X 10.7 users will need to download and install Java, if they have not already done so.
DbVisualizer User Discussion (Write a Review)
Overall:
(4)
(4)
| Downloads:17,776 |
| Version Downloads:189 |
| Type:Development : Java |
| License:Demo |
| Date:22 Dec 2011 |
| Platform:PPC / Intel |
| Price: $179.00 |
Overall (Version 8.x): |
Features: |
| Ease of Use: |
| Value: |
| Stability: |
-
-
-
DbVisualizer is a feature rich, intuitive and 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.
Copyright © 2012 MacUpdate LLC
- -
+1
+40
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.
-1
+18
http://www.tandb.com.au/sqlite/compare/
+1
+18
barefeettom reviewed on 12 Mar 2008
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.
Radoslav Bogdanovic rated on 22 Nov 2011
Bobthevisitor rated on 04 Nov 2011
Rogerbj rated on 07 Aug 2011