| General |
Major:
- GUI changes
- Restructured the main window menu
bar:
- Database
menu now contains all operations
that are used to control the database objects tree
- Edit menu
contains edit operations for the
current SQL Editor
- SQL contains
all SQL related operations
for the current SQL Editor
- View menu
contains general appearance
operations
- Key binding editor allowing full
customization of all
operations (including the SQL Editor. Several key bindings can be
assigned to a single operation, each key binding can be composed of
multiple key strokes. (Key binding now also appear in tool tips).
- Installer now supports Mac
OS X on Intel
Minor:
- Added Connection
Properties for Database
Connection Hooks.
Use to specify commands that will be executed at database connect and
disconnect (ex: session inits and database cleanups).
- Removed borders for some tabbed
panes to make the GUI
less cluttered
- All text fields now have a right
click menu with
common operations such as Cut, Copy, Paste, Delete and Select All
- Key bindings now listed in the
right click menus
- Main tool bar
commands for Execute, Execute
Current, Previous History statement, Next History statement, Commit and
Rollback moved to SQL Editor tool bar
- Main window header now shows the
name of the file
loaded in the active SQL editor. (Listing of settings XML file is
removed from main window header and instead listed in the Tool
Properties).
- Main Window and Monitor Window now
preserve the window
maximum state between invocations
- Load Recent
added to File menu. It lists the
last loaded SQL files. (The limit setting can be modified in Tool
Properties->SQL Editor).
- Recommended file name
extensions now listed
in file choosers
- Now possible to set a database
connection to be any
of Development, Test or Production. Depending on
mode some
features will be rendered differently to caught the attention of the
user
- Reconnect All
added to Database main menu
- Size and position of Tool
Properties dialog now
preserved between invocations.
- Escape keyboard
button can now be used to
close all dialogs and windows that have no menu bar
- Using Ctrl-W in
application windows other
then the main window closes the window (was previously Ctrl-Q)
- Database Objects tree
filtering feature
re-designed.
- Object tree filter
now accepts the "*"
wildcard character in addition to "%"
- Support for drag
& drop of nodes from the
object tree to most input fields including the SQL Commander editor
- Added support for "choices=" option
in variables
allowing list of choices in parameterized queries and connection
settings. Read more in: http://www.dbvis.com/forum/thread.jspa?threadID=1461
Bugs:
|
| Database Objects |
Minor:
- Right click menu now only lists
those operations
valid for the currently selected node
- Right click menu for table objects
now contain Script
Object to SQL Window
- New Selected
Object in the Database main
menu now lists the valid operations for the currently selected node
- The objects tree expansion state
now preserved
between reconnects
- Fixed Connection
Properties->Driver Properties and
the way "Use" worked. "Use" has also been renamed to "Edited".
- New connection property, Object
Tree Labels.
It is used to override how nodes will be named in the objects tree.
Bugs:
- Faster scrolling
in the objects tree
- Great improvements
expanding tree objects
having thousands of childs
- Fixed a bug in the objects tree
filter preventing
multiple column filters to work
- Enhanced performance showing object
view when
selecting an object in the objects tree
Data Tab - Minor:
- The Script:
UPDATE WHERE now shows a
dialog if the table have a primary key or at least one unique index
asking whether the generated SQL should use the keys as the where
clause or all selected values
- Using IN
operator in the Where Filter
has changed. Text data is automatically quoted for the individual
elements. Example: red,green,yellow -> 'red','green','yellow'
|
| Data Editing |
Minor:
- Support to display TIFF
and BMP image
formats
|
| Export |
Minor:
- Support for export in DbUnit
XML formats
- Support for export in Excel
format
|
| Import |
Minor:
- Skip Empty Rows
now enabled by default
|
| SQL Commander |
Major:
- Restructered the SQL Commander
appearance to make it
less cluttered
- SQL Editor tool bar
added with related
operations
- New Properties
pane for the SQL
Commander is used to control editor and the appearance. These were
earlier available in the SQL Commander status bar.
- New right click menu on the SQL
Commander tab
- New right click menu on the
Editor tab
- New right click menu on the
Editor desktop (windows
mode)
- New right click menu on the
Result Set tab
- New right click menu on the
Result Set desktop
(windows mode)
- Log properties now moved to right
click menu
- Result sets are
now presented/managed per
SQL Editor instead of globally for all SQL Editors.
- New editor commands:
- Execute Buffer (sends the
complete editor buffer
for execution as one statement)
- SQL Formatter including a
collection of properties
used to control the formatter
Minor:
- The log/result set
is now automatically restored
after execution if the editor was maximized (View->Show/Hide SQL
Editor Ctrl-8)
- File name of the active SQL Editor
now listed in main
window header
- Variable dialog now executes
when enter key
is pressed in a field instead of adding a line break in the active
field. (Use Shift-Enter to insert a line break).
- Now possible to use $$ variables in
files loaded with
the @run client side command
- The
parameterization dialog now ignores
variables with the noshow option
- Number of Result Sets now listed in
the Result
Set tab header
- Now possible to run anonymous
SQL blocks
in DbVisualizer Free
Bugs:
- Executing update
x set y='4----' where
xid=12345; resulted in everything behind the first
4 to appear
as comment.
- The following comment was
terminated at the / which
it shouldn't
- /* a b c d e/f
g h i j k
*/
- Quoted data is now in red color
- Issuing @export
and then executing a non
result set statement resulted in an error being reported in the log
even though the exec were fine
- It wasn't possible to enter special
characters
requiring the ALT key combination on Mac
OS X. Some
examples of chars that couldn't be typed were: @#[]{}.
- Enhanced performance during
rendering of the Text
result set tab
|
| Charts |
Minor:
- Show Point Labels
setting added to chart
settings. It will when enabled show X/Y value when hovering the mouse
on a point in the chart
|
| References Graph |
Minor:
- Enhanced graphing support with
referenced columns
being indicated in the graph
- Manual layout adjustments can now
auto reroute edges
between nodes
- Enhanced rendering performance
- Find feature
added, used to search and
higlight table nodes
- References graph
settings now saved
between sessions
- New option Bridge
Links. Useful when
links cross each other
- Arcs/Edges
renamed to Links in the
references graph
Bugs:
- Nothing happened when
pressing Reload
while tables were presented in "List" format
|
| Bookmark Editor |
Minor:
- Added Execute
Bookmark in the Bookmarks
menu
- Added Copy to SQL
Commander added in
Bookmark Editor.
- Changed behavior of Execute
Bookmark. It
now copies the bookmark into the SQL Commander and then executes it
|
| Explain Plan |
Major:
- Explain Plan support for Oracle,
DB2 and SQL Server
added
|
| Grid |
Minor:
- Support to browse cell value based
on value type
- BMP, GIF, JPG, TIFF, PNG
- XML (as text or document tree)
- ASCII
- HEX
- Formatting Output.
Vänta... replaced
with the more universal Formatting Output. Wait... ;-)
Bugs:
- Grid column header size now adjusts
its height based
on current font
|
| Oracle |
Major:
- Support for object actions:
- Table
- Create, Drop, Rename, Copy,
Comment, Truncate,
Import Table Data, Script Object to SQL Editor
- View
- Drop, Rename, Compile, Comment,
Script Object to
SQL Editor
- Synonym
- Index
- Create, Drop, Rename, Rebuild,
Compute Statistics
- Sequence
- Materialized View
- Function
- Procedure
- Package
- Package Body
- Trigger
- Drop, Rename, Enable, Disable,
Compile
- Recycle Bin
(Oracle 10g and later)
- Flashback to Before Drop, Purge
from Recycle Bin
- User
- Create, Drop, Lock, Unlock,
Change Password,
Expire Password
- Session
Minor:
- New DBMS Output
tab in the SQL Commander
that replaces the DBMS output previously being presented in the Log tab.
- "Dependencies" tab added to the
object views
- No need to execute "@set
serveroutput on" in the same
script as the dbms_output.put_line being executed anymore
- Now possible to see Tablespace
Quota for a
user
- Now possible to see what users have
Tablespace Quota
for a tablespace
- Now possible to see Database
Properties
- Data Files now
appear as child objects to
tablespaces
- List of tablespaces now show temp
tablespaces +
size
- Tablespaces now appear as child
objects to data files
- Oracle 9.2 and later:
DATE data type now
handled and presented as Date in DbVisualizer. Former versions of
Oracle handle DATE as TIMESTAMP
- Oracle 10g: Recyle
Bin tables now
displayed in the Recycle Bin folder.
- Columns now
appear as child objects for tables
in the database objects tree
- Indexes now
appear as child objects
for tables in the database objects tree
- Java Source and Java
Class objects now
listed in the objects tree
- Roles tab now
displayed when looking
at a role in Oracle
- Added Session
Roles and Session
Privileges to the Session Properties node in Oracle
- New Database Connection property
for Oracle: Handle
DATE as TIMESTAMP
- Selecting a Synonym
in Oracle now show views
(tabs) accordingly for the target object instead of only the
generic Info tab
|
| DB2 |
Major:
- Support for object actions:
- Schema
- Table
- Create, Drop, Rename, Comment,
Import Table Data,
Script Object to SQL Editor
- View
- Drop, Comment, Script Object to
SQL Editor
- Alias
- Nickname
- Drop, Comment, Script Object to
SQL Editor
- Index
- Create, Drop, Rename, Comment
- Materialized Query Table
- Drop, Comment, Script Object to
SQL Editor
- Function
- Stored Procedure
- Package
- Trigger
Minor:
- Summary Table is
now Materialized
Query Table
|
| SQL Server |
Major:
- Support for object actions:
- Database
- Table
- Create, Drop, Rename, Import
Table Data, Script
Object to SQL Editor
- View
- Drop, Rename, Script Object to
SQL Editor
- Index
- Create, Drop, Rename, Rebuild
- Stored Procedure
- Trigger
Minor:
- Now with support for SQL
Server 2005 + the
new driver from Microsoft
Bugs:
- Triggers are now properly displayed
for SQL Server
|
| Informix |
Bugs:
- Fixed minor bug in the profile for
Informix resulting
in an error if passing DELIMIDENT=Y as a connection property
|
| Sybase ASE |
Minor:
|
| Mimer |
Major:
- Database profile with extended
support for Mimer
|
| MySQL |
Major:
- Support for object actions:
- Database
- Table
- Create, Drop, Rename, Import
Table Data, Create
Index,
Script Object to SQL Editor
- Process
Minor:
- Now possible to browse
the source for
Views (MySQL 5.0+)
|
