DbVisualizer project is a cross-platform database tool for all major relational databases. DbVisualizer enables simultaneous connections to many different databases through JDBC drivers.
Just point and click to browse the database structure, view detailed characteristics of database objects, edit table data graphically, execute arbitrary SQL statements or SQL scripts, reverse engineer primary/foreign key mappings graphically or why not let DbVisualizer chart your database with its advanced charting options.
The user friendly graphical interface in combination with the unique collection of features makes DbVisualizer the ideal choice for database administrators and developers.
Here are some key features of "DbVisualizer":
General
· The Database Objects Tree is now always visible in the main window
· The Monitor main tab has been moved to a separate window (launch it via Tools->Monitor)
· Now with support for Java 1.5
· Support for Oracle XMLType data type
· Now displays User Defined Types (UDT)
· Support for MySQL 5+
Connection
· Variables can now be used in the Connection details
· New tool properties, Require Userid and Require Password
SQL Commander
· Auto Completion support used to ease the editing of SQL statements by automatically displaying list of table and column names
· The new Execute Current operation is used to execute the statement at the cursor position
Grid Enhancements
· Quick Filter is used to easily limit the number of rows in a grid by showing only those matching a search word
· Calulate Selection is used to perform simple calculations on the selected cells. Useful primarly for integer data
· Column visibility feature enabling persistent save of column changes such as horizontal location and visible state
Product's homepage
Requirements:
· Java 2 Standard Edition Runtime Environment
What's New in This Release: [ read full changelog ]
· Navigator
· Handle large list of Related Tables in a better way, e.g. make the list scrollable
· [http://www.dbvis.com/forum/thread.jspa?threadID=3594 ]
· SQL Editor
· Restore the 7.1 behavior for Insertion Point to End of Line
· [http://www.dbvis.com/forum/thread.jspa?messageID=12788 ]
· SQL Editor
· Add option to show non-printable characters (tab, whitespace, etc) in the editor
· [http://www.dbvis.com/forum/thread.jspa?messageID=12581 ]
· Table Data Editor
· Table data editor need to save edits in the following order: 1) deletes, 2) updates, 3) inserts to prevent triggering constraint rules
· [http://www.dbvis.com/forum/thread.jspa?threadID=3588 ]
· Bug
· Chart
· Range of Y-axis is erroneous if the max value in a serie is negative
· Database Objects Tree
· The objects tree right click menu may render some actions as disabled
· [http://www.dbvis.com/forum/thread.jspa?messageID=12868 ]
· DB Support: PostgreSQL
· Select composite type column gives exception
· DB Support: PostgreSQL
· Exception or incomplete info when getting column info for DDL
· DB Support: SQL Server
· The default schema cannot be determined for some database configurations
· [http://www.dbvis.com/forum/thread.jspa?messageID=12827 ]
· References
· Not possible to open references graph GML files in yED
· References
· A NullPointerException occur when exporting references graph in SVG or PDF formats
· SQL Editor
· Selection not cleared by Move Caret o Next/Previous Word
· [http://www.dbvis.com/forum/thread.jspa?messageID=12563 ]
· SQL Editor
· Triple-clicking a line to select it and then extending the selection by dragging the mouse down deselects the first line
· SQL Editor
· Delete Line clears all text but does not remove the line break
· [http://www.dbvis.com/forum/thread.jspa?threadID=3564 ]
· SQL Editor
· The action for moving/selecting to the previous word places the caret at the end of the target word instead of at the beginning
· [http://www.dbvis.com/forum/thread.jspa?threadID=3487 ]
· SQL Editor
· The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
· [http://www.dbvis.com/forum/thread.jspa?threadID=3420 ]
· SQL Editor
· "Invalid location" warning when deleting all text as the first edit action
· SQL Editor
· The caret placement may be off when the font specified in the settings file does not exist on the current platform
· [http://www.dbvis.com/forum/thread.jspa?threadID=3585 ]
· SQL Editor
· Copy of multiple lines and pasting them over the selection may lose indentation
· [http://www.dbvis.com/forum/thread.jspa?threadID=3493 ]
· SQL Editor
· Horizontal scroll with wheel/trackpad scrolls vertically
· [http://www.dbvis.com/forum/thread.jspa?threadID=3468 ]
· SQL Editor
· Extending the selection by dragging the mouse up in the row number area stops suddenly
· SQL Editor
· The action for moving/selecting to the previous word places the caret one character to the left of the target when caret is at the beginning of a line
· [http://www.dbvis.com/forum/thread.jspa?threadID=3462 ]
· Table Data Editor
· After saving in data editor, edited cells may still show old value
· [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
· Table Data Editor
· While saving in the data editor, edited cells flicker and show the old value
· [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
· Table Data Editor
· Fix so that when editing a cell value (for duplicated rows) to the same value it currently have, should preserve the edited state
· [http://www.dbvis.com/forum/thread.jspa?messageID=12961 ]
Find us on Google+
