Skip to content
The latest version of DbVisualizer was released 2024-11-27DOWNLOAD HERE ->

GUI Command Line Arguments

As an alternative to start DbVisualizer via the menu items and icons created by the installer, you can also start DbVisualizer from a shell (terminal) on all operating systems using the following scripts:

# DbVisualizer GUI on Windows:
DBVIS-HOME\dbvisgui.bat

# DbVisualizer GUI on Linux/UNIX:
DBVIS-HOME/dbvisgui.sh

# DbVisualizer GUI on macOS:
/Applications/DbVisualizer.app/Contents/Resources/app/dbvisgui.sh

The scripts supports a number of command line arguments. These are also listed in the Help->About menu choice, under the Command Line tab, in DbVisualizer.

Usage: dbvisgui [-connection <name>] [-userid <userid>] [-password <password>]
                [-encoding <encoding>]
                [-workspace <directory>]
                [-windowtitle <title>]
                [-help] [-version]
                [<filename>]
General Options:
 -connection <name>     Database connection name (created with the GUI)
 -userid <userid>       Userid to connect as
 -password <password>   Password for userid
 -encoding <encoding>   Encoding for the SQL script file
 -workspace <directory> Load preferences from an alternate workspace
 -windowtitle <title>   Additional window title
 -help                  Display this help
 -version               Show version info
 <filename>             SQL script file to load into editor

JAVA_EXEC

Please note that these scripts use the first Java version that is found in the PATH. The result may be that a non supported Java version is used.

You can specify a specific version by setting the environment variable JAVA_EXEC to point at an executable Java (note: set this using the operating system's mechanism, not by editing the dbvisgui script).

Example: Windows

(adjust paths to match your environment)

  • From the command line before launching dbvisgui.bat:
    set JAVA_EXEC=D:\java\openjdk\jdk-17.0.4.1+1-jre\bin\java.exe
    
  • In your own script:
    setlocal
    set JAVA_EXEC=D:\java\openjdk\jdk-17.0.4.1+1-jre\bin\java.exe
    call "d:\Program Files\DbVisualizer\dbvisgui.bat"
    
  • Using the system control panel (type "Windows + X", click System -> Advanced System Settings -> Environment Variables): Screenshot of Environment Variables setup in Windows Control Panel