Installation Structure
DbVisualizer is installed in these locations by default:
- Windows:
C:\Program Files\DbVisualizer - macOS:
/Applications/DbVisualizer.app. The application files are inContents/Resources/appinside the app. - Linux: the folder you choose with the SETUP installer, or
/opt/DbVisualizerfor the RPM and DEB packages.
If you use a ZIP or TAR.GZ archive, DbVisualizer is in the folder you extract it to.
Contents
The installation folder contains, among other things:
| Item | Description |
|---|---|
dbvis.exe (Windows), dbvis (Linux) | Starts DbVisualizer. |
dbvis.vmoptions (Windows, Linux) | The default Java VM options. See Java VM options. |
dbvisgui.bat, dbvisgui.sh | Starts DbVisualizer from a terminal. See Starting the GUI from the Command Line (dbvisgui). |
dbviscmd.bat, dbviscmd.sh | Runs the command-line interface. |
jre/ (Windows, Linux) | The Java runtime bundled with DbVisualizer. On macOS, it is in Contents/PlugIns in the app. |
lib/ | The DbVisualizer program files. |
resources/ | Database profiles, templates and other resources. |
addon/demo/ | The demo database. |
doc/ | The license agreement and third-party licenses. |
The other files and folders are used by the launcher and the installer.
Java VM options
The dbvis.vmoptions file holds the default options for the Java VM that runs DbVisualizer, such as the maximum memory (-Xmx). Your own options are stored in a separate file, user.vmoptions, so that they are kept when you upgrade DbVisualizer. To edit them, open Tools → Tool Properties, select the General category, and use the Java VM Properties section. The path to user.vmoptions is shown there as a link. Restart DbVisualizer for the changes to take effect.
If DbVisualizer doesn't start after you change the options, edit or delete user.vmoptions.
When you start DbVisualizer from a script, these options aren't used. See Starting the GUI from the Command Line (dbvisgui).
Increasing the memory
To let DbVisualizer use more memory, add the -Xmx option in the Java VM Properties section with the maximum amount, for example -Xmx8g for 8 GB. Don't set it higher than the memory in your computer. Restart DbVisualizer for the change to take effect.
Storing user.vmoptions in another folder
By default, user.vmoptions is stored in the .dbvis folder in your home directory. On Windows and Linux, you can store it somewhere else by changing the -include-options line in dbvis.vmoptions, for example on Windows:
-include-options ${APPDATA}\DbVisualizer\user.vmoptions
Upgrading
When you upgrade DbVisualizer, dbvis.vmoptions may be replaced, so check the -include-options line after an upgrade.