Download HeidiSQL 10.2

Release date: 15 Jun 2019.

• Installer, 32/64 bit combined
• Portable version (zipped): 32 bit , 64 bit
• Microsoft Store App, 32 bit
• Sourcecode
• Previous installers
  • HeidiSQL 10.1 (26 Jan 2019)
  • HeidiSQL 10.0 (23 Jan 2019)
  • HeidiSQL 9.5 (19 Dec 2017)
  • HeidiSQL 9.4 (20 Oct 2016)

Compatibility notes

• HeidiSQL runs fine on Windows XP, Vista, 7, 8 and 10. Using Wine, it mostly runs fine on Linux and MacOS.
• Connecting to TLS 1.2 enabled MS SQL Servers requires an updated OLE DB Driver 18 for SQL Server to be installed.
• Wine users: For MS SQL connections, avoid using Wine 3.15 up to 4.1. Instead, use Wine 3.14 or 4.2 - these should work.
• Connecting to PostgreSQL may require to have Visual C++ Redistributable Package installed

Nightly Builds of heidisql.exe

Latest automatically compiled main executable and installers for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe. Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones.

1. Revision
   10.2.0.5638

   Collect custom session background colors via OnGetColors event of TColorBox, do not mix it in the code for refreshing the session tree. Also refresh custom colors each time a session is focused, so it has new colors.

   committed: 20 Jul 2019 17:29 compiled: 20 Jul 2019 17:54

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

2. Revision
   10.2.0.5637

   Giving up on high DPI readiness - remove tweaks which mostly don't work as expected, and even differently on various computers. Instead, let Windows blur fonts.

   committed: 18 Jul 2019 20:53 compiled: 18 Jul 2019 20:57

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

3. Revision
   10.2.0.5636

   Issue #718: Fonts may still be too large because the monitor on which a form is created has DPI > 100%. Calculate DpiScaleFactor based on that first monitor. See https://www.heidisql.com/forum.php?t=34230

   committed: 18 Jul 2019 19:08 compiled: 18 Jul 2019 19:11

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

4. Revision
   10.2.0.5635

   Issue #718: Fonts may be too large because they get scaled before the window gets moved to the wanted screen. So, this moves the code for scaling fonts to FormShow, so we can scale fonts according to the screen's DPI setting.

   committed: 18 Jul 2019 07:52 compiled: 18 Jul 2019 08:05

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

5. Revision
   10.2.0.5634

   High DPI: Scale up font size when applying font to query editors and result grids
   Todo: mouse wheel zooming seems broken on dpi > 100%

   committed: 17 Jul 2019 22:15 compiled: 17 Jul 2019 22:17

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

6. Revision
   10.2.0.5633

   High DPI:
   * remove ParentFont flag from forms again (introduced in 9cdcd631454f6f9e999893ea89fcf502d994474c for #213). This just inherits from default Windows settings.
   * instead, scale font size in InheritFont(), and move that to the new TExtForm class
   * mark app with PerMonitorV2 support

   committed: 17 Jul 2019 21:59 compiled: 17 Jul 2019 22:02

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

7. Revision
   10.2.0.5632

   Make search for libraries case insensitive. Closes #716

   committed: 17 Jul 2019 07:02 compiled: 17 Jul 2019 07:24

   Downloads: 32bit build (7.8 MB)64bit build (8.3 MB)32+64bit installer (19.1 MB)

8. Revision
   10.2.0.5631

   Changed 10.2 GroupProj to point to the 10.2 packages instead of XE5 ones

   committed: 16 Jul 2019 19:15 compiled: 16 Jul 2019 19:54

   Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.1 MB)

9. Revision
   10.2.0.5630

   Changed 10.3 GroupProj to point to the 10.3 packages instead of XE5 ones

   committed: 16 Jul 2019 19:15

10. Revision
    10.2.0.5629

    Add "Multi column filter" item to "Go to" menu. Closes #681. Also, "Switch between query/results" now switches between filter and grid in Data tab.

    committed: 14 Jul 2019 19:46 compiled: 14 Jul 2019 19:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

11. Revision
    10.2.0.5628

    Add "Switch to query/results" item to "Go to" menu. Closes #698

    committed: 14 Jul 2019 19:27

12. Revision
    10.2.0.5627

    Revert a part of 1c76c2ecc0ed7d87cda822228802bedf48a143fe, which disabled the port input for MS SQL / TCP connections if the host is a named instance. According to #714 you can still use the port for named instances. Closes #714.

    committed: 14 Jul 2019 17:38 compiled: 14 Jul 2019 17:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

13. Revision
    10.2.0.5626

    Issue #513: add a theme preview dialog, which loads the selected theme png file from heidisql.com

    committed: 13 Jul 2019 15:59 compiled: 13 Jul 2019 16:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

14. Revision
    10.2.0.5625

    Append system error message to error dialog popping up when tabs.ini is not writable. See https://www.heidisql.com/forum.php?t=34044

    committed: 12 Jul 2019 18:25 compiled: 12 Jul 2019 18:54

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

15. Revision
    10.2.0.5624

    Issue #360: add unique session colors only to the background color selector, and label them "Custom color". See https://www.heidisql.com/forum.php?t=34168#p34194

    committed: 12 Jul 2019 18:23

16. Revision
    10.2.0.5623

    Add custom colors from sessions to background color selector. See https://www.heidisql.com/forum.php?t=34168

    committed: 11 Jul 2019 21:38 compiled: 11 Jul 2019 22:10

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

17. Revision
    10.2.0.5621

    Issue #677: select first available library if default or configured one is not available.

    committed: 10 Jul 2019 22:05 compiled: 10 Jul 2019 22:24

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

18. Revision
    10.2.0.5620

    Issue #498: Increase completion threshold for pulling language files from 10% to 20%. Old translations now get deleted before fresh copies get downloaded, so deleted languages should really get removed from the compiled application.

    committed: 10 Jul 2019 20:24 compiled: 10 Jul 2019 20:37

    Downloads: 32bit build (7.8 MB)64bit build (8.6 MB)32+64bit installer (19.2 MB)

19. Revision
    10.2.0.5619

    Restore tabs feature crashes often on old XP systems, so we activate it by default only on Vista and newer. See https://www.heidisql.com/forum.php?t=34044

    committed: 10 Jul 2019 16:25 compiled: 10 Jul 2019 16:54

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

20. Revision
    10.2.0.5618

    Disable tab restore/store when tabs.ini is not writable. See https://www.heidisql.com/forum.php?t=34044#p34148

    committed: 10 Jul 2019 11:46 compiled: 10 Jul 2019 15:24

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

21. Revision
    10.2.0.5617

    Silence reoccurring error dialogues due to non-writable portable_settings.txt, by introducing a portable-read-only mode as soon as an update to that file fails

    committed: 10 Jul 2019 11:05

22. Revision
    10.2.0.5616

    Make mysql_fetch_field() available. Helps in debugging #697.

    committed: 08 Jul 2019 20:25 compiled: 08 Jul 2019 20:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

23. Revision
    10.2.0.5615

    Issue #677:
    * drop workaround for application crash on WinXP, when loading newer libmariadb (see #79)
    * raise TDbLib's own exception instead of baking an own one with less details. Probably helps in debugging: https://www.heidisql.com/forum.php?t=34044
    * rename EDatabaseError to EDbError, to overcome naming conflict in DB unit
    * load libpq.dll always with path, which should anyway work better than without it. See http://www.heidisql.com/forum.php?t=22514

    committed: 08 Jul 2019 20:23

24. Revision
    10.2.0.5614

    High DPI: fix growing window dimensions on each opening. Related to #378

    committed: 07 Jul 2019 21:22 compiled: 07 Jul 2019 21:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

25. Revision
    10.2.0.5613

    Fix wrong calculated height and width of tool buttons after DPI change / move between monitors. Closes #446

    committed: 07 Jul 2019 09:42 compiled: 07 Jul 2019 09:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

26. Revision
    10.2.0.5612

    High DPI: fix wrong height of status bar, by not setting it to what GetTextHeight returns. Maybe also related to #483.

    committed: 06 Jul 2019 16:03 compiled: 06 Jul 2019 16:24

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

27. Revision
    10.2.0.5611

    Issue #677: provide a new library combobox in MySQL mode, for selecting any of the libmysql/mariadb.dll files from the application directory

    committed: 05 Jul 2019 06:44 compiled: 05 Jul 2019 06:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

28. Revision
    10.2.0.5610

    Fix new crash in ConnectionInfo (mouse over server version status panel)

    committed: 30 Jun 2019 08:59 compiled: 30 Jun 2019 09:23

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

29. Revision
    10.2.0.5609

    Escape double quotes in SSH password for plink command. Closes issue #261

    committed: 29 Jun 2019 08:02 compiled: 29 Jun 2019 08:24

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

30. Revision
    10.2.0.5608

    Use UnescapeString() to remove more escape sequences than a duplicated single quote. Move ExtractLiteral() to TDBConnection, as UnescapeString() depends on the connection type. Closes #690.

    committed: 26 Jun 2019 19:52 compiled: 26 Jun 2019 20:23

    Downloads: 32bit build (7.8 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

31. Revision
    10.2.0.5607

    Fix some suspicious places which can cause exceptions when data tab is open and current connection is being closed. Probably closes #615.

    committed: 24 Jun 2019 21:45 compiled: 24 Jun 2019 21:54

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

32. Revision
    10.2.0.5606

    Use the same new dll loading mechanism also for PostgreSQL's libpq.dll

    committed: 22 Jun 2019 17:57 compiled: 22 Jun 2019 18:24

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

33. Revision
    10.2.0.5605

    Refactor: rename mysql_structures unit neutrally to dbstructures

    committed: 22 Jun 2019 14:26 compiled: 22 Jun 2019 14:54

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

34. Revision
    10.2.0.5604

    Fix wrong data shown in data tab, when switching between a table/database with the same name on different servers

    committed: 22 Jun 2019 14:16

35. Revision
    10.2.0.5603

    Use mysql_optionsv to tell newer MySQL servers HeidiSQL's program_name, visible then in performance_schema.session_connect_attrs

    committed: 19 Jun 2019 22:47 compiled: 19 Jun 2019 22:58

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

36. Revision
    10.2.0.5602

    Fix duplicated application directory prepended on library path

    committed: 19 Jun 2019 22:45

37. Revision
    10.2.0.5601

    Experimental: introduce TDbLib and descendant TMySQLLib, and outsource dll loading mechanism there, out of DoBeforeConnect

    committed: 19 Jun 2019 21:15

38. Revision
    10.2.0.5600

    Quick filter: only unique cell values in "IN (...)" generation

    committed: 19 Jun 2019 17:51 compiled: 19 Jun 2019 17:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

39. Revision
    10.2.0.5599

    Bump version for v10.2 release

    committed: 15 Jun 2019 07:57 compiled: 15 Jun 2019 08:04

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.2 MB)

40. Revision
    10.1.0.5598

    Issue #296: enhance checkbox phrasing, and move it above to the other checkboxes

    committed: 12 Jun 2019 20:34 compiled: 12 Jun 2019 20:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

41. Revision
    10.1.0.5597

    Fix compiler warnings, and add documentation

    committed: 12 Jun 2019 20:15 compiled: 12 Jun 2019 20:25

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

42. Revision
    10.1.0.5596

    Cleartext syntax changes

    committed: 11 Jun 2019 23:17 compiled: 12 Jun 2019 20:23

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

43. Revision
    10.1.0.5595

    Add cleartext option to sessions

    committed: 11 Jun 2019 21:57 not compilable

44. Revision
    10.1.0.5594

    Issue #578: prefer Invalidate over Repaint, as the lists may not be displayed at all and may crash when forcing a repaint

    committed: 11 Jun 2019 07:16 compiled: 11 Jun 2019 07:25

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

45. Revision
    10.1.0.5593

    Table editor: root nodes in indexes and foreign key list are defined in BeforePaint event, so repaint these explicitly when table properties have been read. Closes #578.

    committed: 11 Jun 2019 07:11 compiled: 11 Jun 2019 07:23

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

46. Revision
    10.1.0.5592

    Define default values for port and username of all supported server types. Also, do not change them in the session manager, when user selects a different sub type of the same server.

    committed: 09 Jun 2019 09:27 compiled: 09 Jun 2019 09:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

47. Revision
    10.1.0.5591

    Issue #140: restore width and height of query tab editors along with their filename

    committed: 09 Jun 2019 08:39 compiled: 09 Jun 2019 08:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

48. Revision
    10.1.0.5590

    Report active theme name, so we are once probably able to remove some of them which are mostly unused, to speed up application start

    committed: 08 Jun 2019 09:19 compiled: 08 Jun 2019 09:23

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

49. Revision
    10.1.0.5589

    Remove unused variable

    committed: 08 Jun 2019 08:49 compiled: 08 Jun 2019 08:55

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

50. Revision
    10.1.0.5588

    Fix wrong position of dropped column on index tab. Closes #385.

    committed: 08 Jun 2019 08:48 compiled: 08 Jun 2019 08:53

    Downloads: 32bit build (7.9 MB)64bit build (8.7 MB)32+64bit installer (19.1 MB)

Imprint