Feature TourFeature Tour

Configurable

Previous

DbVisualizer is highly configurable. Settings can be defined on the application level or per database connection. All settings are saved between invocations.

 
The key binding support in DbVisualizer is extensive as it supports setting key bindings for lots of operations. There are pre-defined key maps specifically for Windows, Linux/UNIX and Mac OS X users. This is really important for key bindings such as those used for editing since these key strokes are different in each OS. In addition there are key maps for users coming from other database tools such as TOAD and SQL Server's Query Analyzer.
Key Binding setup
There are many settings used to control the appearance and behavior of DbVisualizer. One great feature is to set connection mode for a database connection. It can be set to one of Development (default), Test or Production. A border indicates the current mode for the connection. The connection mode is also used in combination with the permission subsystem to control what commands need attention, are accepted or are denied for execution.
Connection mode
The grid colors can be defined so that every second row is presented in an alternate color.
Grid colors
The permission feature simply controls every action and SQL that are about to be executed. The permission is set per individual SQL statements executed in the SQL Commander, such as DELETE, DROP, UPDATE, etc. The response can be any of "Allow", "Ask" or "Deny". Permissions are also available when editing in the table data editor. Permissions can be defined for Insert, Update or Delete operations. The response for each command is any of "Confirm" or "No Confirm". Permissions are grouped based on the connection modes, "Development", "Test" and "Production".
Permission control setup
Feature DbVisualizer
Personal		 DbVisualizer
Free
» Extensive collection of tool properties
» Set unique properties per database connection
» Permissions checks what commands need confirmation