Database Profile Utilities
In the Database Profiles list in Connection Properties there is a right-click menu with various commands to process the database profile and list of profiles. These
commands are useful while developing a database profile. Read the following sections for more details about each command.
Analyze Database Profile
This command verify the loaded database profile and perform various consistency checks and may report:
| Check |
|---|
| GroupNode and DataNode elements with no matching ObjectView (by "type" attribute) |
| ObjectView elements with no matching GroupNode or DataNode (by "type" attribute) |
| ActionGroup elements with no matching GroupNode or DataNode (by "type" attribute) |
| DataView elements located in the same ObjectView having same "label" attribute |
| No matching icon for these elements (by the "type" or "icon" attributes) |
Show All Type and Icon Attributes
This command examine the loaded profile and report all used icons (logical name) as referenced by the object type and specific icon attributes. The following is an example doing running this command with the MySQL profile loaded.
These are all "type" and "icon" references in the profile:
add
catalog
catalogs
charset
collation
column
columns
data
databases
dba
edit
errors
event
events
export
function
functions
import
index
indexes
info
login
navigator
primarykey
privileges
procedure
procedures
process
processes
references
remove
rename
role
rowcount
rowid
schema
schemas
scriptobject
slavestatus
source
sourceeditor
stateerror
status
table
tableengine
tableengines
tableprivileges
tables
trigger
triggers
users
variables
view
views
warning
warnings
Show Available Icons
This will show a window with all available icons, their name, icon file name and an indicator if the icon is used in the loaded database profile.
Export Merged Profile
This will export the currently loaded profile. If the profile has been merged using the extend attribute the exported profile file is the complete and processed profile.
Configure Search Path
This will open Tool Properties / General / Database Connection / Database Profile pane used to configure the search path for database profile loading.
Reload Database Profiles List
This will reload the list of database profiles in case a new profile has been added (or renamed) since last launch of DbVisualizer.