HeidiSQL Silent Install (How-To Guide)

HeidiSQL is a free and open-source administration tool for MySQL and its forks, as well as Microsoft SQL Server, PostgreSQL and SQLite. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of HeidiSQL from the command line using the EXE installer.

How to Install HeidiSQL Silently

HeidiSQL Silent Install (EXE)

  1. Navigate to: https://www.heidisql.com/download.php
  2. Select the 32/64 bit Combined Installer
  3. Download the HeidiSQL_w.x.y.z_Setup.exe to a folder created at (C:\Downloads)
  4. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  5. Navigate to the C:\Downloads folder
  6. Enter the following command: HeidiSQL_w.x.y.z_Setup.exe /VERYSILENT /NORESTART
  7. Press Enter

After a few moments you should see the HeidiSQL Desktop Shortcut appear. You will also find entries in the Start Menu, Installation Directory, and Programs and Features in the Control Panel.

Software Title:HeidiSQL
Vendor:Ansgar Becker
Architecture:x86_X64
Installer Type:EXE
Silent Install Switch:HeidiSQL_w.x.y.z_Setup.exe /VERYSILENT /NORESTART
Silent Uninstall Switch:"%ProgramFiles%\HeidiSQL\unins000.exe" /VERYSILENT /NORESTART
Download Link:https://www.heidisql.com/download.php
PowerShell Script:https://silentinstallhq.com/heidisql-install-and-uninstall-powershell/
Detection Script:https://silentinstallhq.com/create-a-custom-detection-script-for-heidisql-powershell/

The information above provides a quick overview of the software title, vendor, silent install, and silent uninstall switches. The download links provided take you directly to the vendors website. Continue reading if you are interested in additional details and configurations.


Additional Configurations

Create a HeidiSQL Installation Log File

The HeidiSQL installer offers the option to generate a log file during installation to assist with troubleshooting should any problems arise. You can use the following commands to create a verbose log file with details about the installation.

HeidiSQL Silent Install (EXE) with Logging

HeidiSQL_w.x.y.z_Setup.exe /VERYSILENT /NORESTART /LOG="%WINDIR%\Temp\HeidiSQL-Install.log"

Change the HeidiSQL Default Installation Directory

You can change the default installation directory by using the following command line parameters. In this example, I’m installing HeidiSQL to “C:\HeidiSQL”

HeidiSQL_w.x.y.z_Setup.exe /DIR=C:\HeidiSQL /VERYSILENT /NORESTART

Exclude the HeidiSQL Desktop Shortcut During Install

The HeidiSQL installer creates a desktop shortcut by default. If you don’t want the desktop shortcut, then you can run one the following command line switches to exclude it.

HeidiSQL Silent Install (EXE) with No Desktop Shortcut

HeidiSQL_w.x.y.z_Setup.exe /VERYSILENT /NORESTART /MERGETASKS=!desktopicon

Disable HeidiSQL Update Checks

HeidiSQL Silent Install (EXE) with Update Checks Disabled

HeidiSQL_w.x.y.z_Setup.exe /VERYSILENT /NORESTART /MERGETASKS=!activate_updatechecks
  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter the following command & press Enter:
    • Note: This is a Per User Setting
REG ADD "HKCU\SOFTWARE\HeidiSQL" /v Updatecheck /t REG_DWORD /d 0 /f

Disable HeidiSQL Usage Statistics

HeidiSQL Silent Install (EXE) with Usage Statistics Disabled

HeidiSQL_w.x.y.z_Setup.exe /VERYSILENT /NORESTART /MERGETASKS=!activate_statistics
  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter the following command & press Enter:
    • Note: This is a Per User Setting
REG ADD "HKCU\SOFTWARE\HeidiSQL" /v DoUsageStatistics /t REG_DWORD /d 0 /f

How to Uninstall HeidiSQL Silently

Check out the following posts for a scripted solution:

HeidiSQL Install and Uninstall (PowerShell)
HeidiSQL Silent Uninstall (PowerShell)
  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter the following command:

HeidiSQL Silent Uninstall (EXE)

"%ProgramFiles%\HeidiSQL\unins000.exe" /VERYSILENT /NORESTART

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.