Chart
Replace the outdated charting component with a modern one (see related improvements below)
Connection Setup
Add support for SSH tunneling
See the
discussion here
Redesign the Connect tab to enable SSH tunneling, more prominent placement of common properties, etc.
DB Support: H2
Add extended support for the H2 database
DB Support: JavaDB/Derby
Add Sequence support for JavaDB/Derby
DB Support: Mimer SQL
Add Explain Plan support for Mimer SQL
DB Support: SQLite
Add extended support for the SQLite database
DDL Generator
Add DDL generator and application support for CREATE INDEX
Export
Add Export actions for individual object, i.e. View, Procedure, Function, Package, Package Body, and Trigger
See the
discussion here
Add support for export in OOXML (xlsx) format. Enables export of more than 65K rows in a single sheet
Add TXT export format used to export fixed width columns output (grid export only)
General
Add support for the -connection, -userid and -password arguments for the DbVisualizer GUI. When passed as arguments then automatically connect the database connection at startup
Adapt DbVisualizer for the upcoming Java 1.7 version
Grid Component
Add "Copy Selection as Text (With Column Header)" in the grid right-click menu
Navigator
Allow editing in the Navigator grid
See the
discussion here
Add Quick Filter for the Navigator grid
See the
discussion here
SQL Commander
Add "Show Object at Cursor" feature that will locate the object at the cursor position and show its details in window
See the
discussion here
SQL Editor
Replace the SQL/text editor component to allow for various improvements (see below)
Workspace
Optimize screen estate usage. Allow for configuring visibility of certain components
Auto Completion
Auto completion doesn't work if command is "WITH"
Add the supported client side commands to the auto completion popup
Auto Completion should show database specific reserved words
Chart
Support date/time/timestamp columns in X axis with proper scaling
See the
discussion here
A monitor script with manually adjusted chart settings are not used if re-executing the monitor in the SQL Commander
See the
discussion here
Chart setting changes made in the SQL Commander should be used automatically for new charts
See the
discussion here
Make more chart settings persistent
Automatically setup serie in chart at first display
Support GIF export format for Charts
A bookmark in SQL Commander should apply any chart settings from the bookmark
Command Line Support (dbviscmd)
Use a better error message when the specified connection does not exist
See the
discussion here
Connection Setup
Using the connection wizard to create a connection should insert the new connection based on the current object tree selection
Change the controls to make it clear that Save Password and Clear Password at Disconnect are mutually exclusive
See the
discussion here
Create/Alter Table
Include table name in constraint name suggestions
Data tab
The data filtering feature automatically add WHERE first making it impossible to manually add for example "with (NOLOCK)". Fix by allowing !WHERE to be specified first in the filter
Database Objects Tree
The cache with primary keys and unique indexes need to be reset when reloading the objects tree (and also implicitly at reconnect)
Database Profile: Actions
The object action window need to be bigger for some actions such as "Create Tablespace" in Oracle
Unsaved edits in the object action window should be confirmed when user request canceling the action
DB Support: Oracle
The list of TNS names for Oracle should be sorted
See the
discussion here
Use the temporary table SYS.PLAN_TABLE$ for explain plan in Oracle 9+
See the
discussion here
Better support for "Object Type" objects in Oracle
Add "resize datafile" and "add datafile" actions for UNDO and TEMP tablespaces
Support for Oracle rules, /*+rule */, without need for special configuration
See the
discussion here
DB Support: PostgreSQL
Support for array types in DDL
See the
discussion here
DB Support: SQL Server
Show computed column expression in DDL
See the
discussion here
DB Support: Sybase ASE
Order objects based on schema and name, as opposed to just name without regard for the schema
Explain Plan
Add copy to clipboard functionality for explain plan result set
The tree view in explain plan should be exportable
Copy Selection as Text and Export Grid (TXT and HTML formats) in Explain Plan grid should indent the tree column accordingly
Export
Make it possible to select how to delimit SQL blocks for procedure DDL
See the
discussion here
Option to control position of SQL statement in export output (above/below result set)
Favorites
Add Replace action for a favorite that references a database object. This should replace the information for the favorite with the data for the selected database object
General
Quitting DbVisualizer should wait for all active connections to properly disconnect
Menubar items are not anti aliased when running DbVisualizer in Linux
See the
discussion here
Import
Optionally drop an existing table with the same name when using Import to New Table
See the
discussion here
Add copy/paste support in "New Database Table" and in the "Map Table Columns with File Columns" import table data grids
Installation
Allow command line flag to the installer that disable file associations when installing in silent mode
See the
discussion here
Monitor
Should be possible to hide the toolbar for each monitor window/tab
Save chart font, colors and other settings with monitor
Auto started monitors need to run the connect prompter
Navigator
Add possibility to select a row in the Data tab grid and use it as start for the Data Navigator
See the
discussion here
OS Support: Mac OS X
Mac OS X: Option to add newly installed version in the Dock
Print
Print text in the SQL Editor as text instead of as a screenshot
Query Builder
Improve the support for CASE clauses in a query
References
Add option to control whether compound references should be rendered only with one link
Add an option to control auto zooming when searching in the references graph
See the
discussion here
Scripts
Loading a file from the Scripts tab should use the Default File Encoding in Tool Properties if encoding for the file is not set
Minimize file access operations to increase performance when accessing files on remote hard drives
See the
discussion here
SQL Commander
Should be possible to open a .sql file and load it into a running instance of DbVisualizer
Connections with same alias aren't visibly differentiated in for example the Connection drop down in the SQL Editor
Path errors in the @run and @cd command should be handled just like other errors instead of showing an alert dialog and stopping the execution
Allow for relative paths to be used with the @cd command
Caret position and focus in SQL editors should be preserved when jumping between editor tabs using mouse
See the
discussion here
Add support for ${dbvis-pwd} that will be replaced with the current directory
See the
discussion here
Add new setting to control whether result sets produced in the SQL Commander always should be read-only
SQL Editor
Allow change of background color in the SQL editor and foreground color for text
See the
discussion here
Support for code folding in the SQL editor
See the
discussion here
Must be possible to change colors in the editor
Color-coding should not interpret backslash as an escape character other than for MySQL databases
See the
discussion here
Underline should not be considered a separator between two words on double click i.e. both words and the underline should be selected
When opening a new SQL Editor the settings for Max Rows/Max Chars should pick their values from the previously displayed editor
See the
discussion here
Should be possible to disable bold for keywords in the SQL Editor
Add database specific highlighting of reserved words
Insertion "Point to Next/Previous Word" should ignore underscore characters
Add a "Search Scope" in the SQL Editor Find feature
See the
discussion here
Support regular expression in Find
SQL Editor shall have focus when going to SQL Commander directly after start-up of DbVisualizer
SQL editor should support anti-aliased fonts
See the
discussion here
Make it possible to change the selection color
See the
discussion here
Show position of caret based on current statement
Add support for editing macro recording and playback
Add support for Paste from previous clipboard content
SQL History
Quick filter in the SQL History should support searching the SQL script content
See the
discussion here
Table Data Editor
Table data editor should keep focus when saving or reloading the data
Save and undo buttons in table data editor are not activated when editing a single cell or when using functions to fill a single cell
See the
discussion here
Add Enable/Disable All buttons in the key column chooser
See the
discussion here
Table Data editing should not rely on the variable identifier/delimiter specified in Tool Properties
Tool Properties
The settings for proxy should automatically be picked from the system
Workspace
Support drag and drop of bookmark, monitor and favorite files between DbVisualizer and external tools such as Windows Explorer, Finder (Mac) and File Browser (Linux)
See the
discussion here
Adjust all windows so that they are no bigger than 1280x800