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.5681

   Fix InnoSetup warning: Warning: Constant "pf" has been renamed. Use "commonpf" instead or consider using its "auto" form.

   committed: 20 Aug 2019 21:23 compiled: 20 Aug 2019 21:26

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

2. Revision
   10.2.0.5680

   Fix non applied font name on some link labels

   committed: 20 Aug 2019 21:11

3. Revision
   10.2.0.5679

   Make installer script ready for Inno Setup 6

   committed: 20 Aug 2019 20:33 compiled: 20 Aug 2019 20:42

   Downloads: 32bit build (5.4 MB)64bit build (6.3 MB)32+64bit installer (20.5 MB)

4. Revision
   10.2.0.5678

   Leave explain links disabled when SQL in focused process is empty, and only prepend a "USE dbname" if used database is not empty. Closes #738

   committed: 16 Aug 2019 07:13 compiled: 16 Aug 2019 07:24

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

5. Revision
   10.2.0.5677

   Fix duplicated parentheses on host sub tabs, broken by previous commit. Closes #739

   committed: 16 Aug 2019 06:42 compiled: 16 Aug 2019 06:54

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

6. Revision
   10.2.0.5676

   Remove FHostTabCaptions list which had untranslated captions since recently. Use a regular expression instead. Closes #730.

   committed: 15 Aug 2019 07:48 compiled: 15 Aug 2019 07:54

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

7. Revision
   10.2.0.5675

   Issue #513: remove minimize and maximize buttons from theme preview dialog

   committed: 13 Aug 2019 09:30 compiled: 13 Aug 2019 09:54

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

8. Revision
   10.2.0.5674

   Try to fix missing schema in row counting query. See https://www.heidisql.com/forum.php?t=34331#p34439 and https://www.heidisql.com/uploads/34439-2-bugreport.txt

   committed: 13 Aug 2019 09:12 compiled: 13 Aug 2019 09:24

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

9. Revision
   10.2.0.5673

   Catch more sorts of exceptions in TMainForm.AnyGridGetText when converting large integers to unix timestamps. Should fix #735

   committed: 13 Aug 2019 08:50 compiled: 13 Aug 2019 08:54

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

10. Revision
    10.2.0.5672

    Return default net group in TConnectionParameters.GetNetTypeGroup. Raising an exception lets the app die for some reason. Reproduction: click drop-down button on "Database(s)" session setting

    committed: 11 Aug 2019 14:18 compiled: 11 Aug 2019 14:24

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

11. Revision
    10.2.0.5671

    Expect COMMENT 'xxx' clause in index creation code, and store that comment in a new TTableKey.Comment field. Not yet visible per GUI, but at least such indexes are displayed now. Closes #732

    committed: 11 Aug 2019 09:45 compiled: 11 Aug 2019 09:54

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

12. Revision
    10.2.0.5670

    Restore compatibility to SQL Server 2000, when opening a table. See https://www.heidisql.com/forum.php?t=34331

    committed: 09 Aug 2019 15:04 compiled: 09 Aug 2019 15:24

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

13. Revision
    10.2.0.5669

    Move MySQL/MariaDB constants from const.inc to dbstructures.pas

    committed: 02 Aug 2019 08:50 compiled: 02 Aug 2019 08:56

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

14. Revision
    10.2.0.5668

    Issue #704: Add basic SSL support for PostgreSQL connections.

    committed: 29 Jul 2019 13:40 compiled: 29 Jul 2019 13:54

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

15. Revision
    10.2.0.5667

    Replace remaining SHOW VARIABLES queries with GetSessionVariable

    committed: 29 Jul 2019 12:41 compiled: 29 Jul 2019 12:54

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

16. Revision
    10.2.0.5666

    Issue #80: Safely accept empty default value for probably non existing server variable "skip_name_resolve" in user manager.

    committed: 29 Jul 2019 08:30 compiled: 29 Jul 2019 08:54

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

17. Revision
    10.2.0.5665

    Introduce TDBConnection.GetSessionVariable, to retrieve the value of one specific variable. Use that to simplify the code in some places.

    committed: 29 Jul 2019 08:18

18. Revision
    10.2.0.5664

    Trim SSH host name, and revert some recently accidentally committed debug lines

    committed: 28 Jul 2019 12:23 compiled: 28 Jul 2019 12:54

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

19. Revision
    10.2.0.5663

    Use Library setting for MS SQL as well, and provide available ADO providers in the drop down. Also show a security warning dialog when there is just the old SQLOLEDB provider. Related to #237

    committed: 28 Jul 2019 12:18 compiled: 28 Jul 2019 12:24

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

20. Revision
    10.2.0.5662

    Tweak help message

    committed: 28 Jul 2019 10:56 compiled: 28 Jul 2019 11:24

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

21. Revision
    10.2.0.5661

    Make download hint translatable

    committed: 28 Jul 2019 08:59 compiled: 28 Jul 2019 09:24

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

22. Revision
    10.2.0.5660

    Give the user a hint to download VC redistributable if PostgreSQL dll fails to assign a procedure. See https://www.heidisql.com/forum.php?t=18580#p34297

    committed: 28 Jul 2019 08:57

23. Revision
    10.2.0.5659

    Move library selector up, below the network type selector, so these both define the basic connection type

    committed: 28 Jul 2019 08:33 compiled: 28 Jul 2019 08:54

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

24. Revision
    10.2.0.5658

    Activate Library drop down for PostgreSQL connections as well, so we may provide multiple versions in the future.

    committed: 28 Jul 2019 08:24

25. Revision
    10.2.0.5657

    Raise error before LoadLibrary is called, when library file does not exist, so the user gets a more reasonable message

    committed: 26 Jul 2019 20:48 compiled: 26 Jul 2019 20:54

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

26. Revision
    10.2.0.5656

    Remove useless DPI helper panel from tabs in routine editor, table editor and table tools dialog

    committed: 25 Jul 2019 07:44 compiled: 25 Jul 2019 07:50

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

27. Revision
    10.2.0.5655

    Remove useless DPI helper panel from preferences dialog tabs

    committed: 25 Jul 2019 07:28

28. Revision
    10.2.0.5654

    Remove useless DPI helper panel from session manager tabs

    committed: 24 Jul 2019 07:38

29. Revision
    10.2.0.5653

    Issue #722: Tweak TMySQLConnection.GetLastErrorMsg so it shows an additional more helpful message what the user could do to solve his SSL connection error

    committed: 23 Jul 2019 22:00 compiled: 23 Jul 2019 22:24

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

30. Revision
    10.2.0.5652

    Provide additional libmysql library version v6.1.11. Closes issue #722

    committed: 23 Jul 2019 18:43 compiled: 23 Jul 2019 18:54

    Downloads: 32bit build (7.8 MB)64bit build (8.4 MB)32+64bit installer (20.5 MB)

31. Revision
    10.2.0.5651

    Prefer inline code over outsourced one-time used function BestTableName

    committed: 23 Jul 2019 17:38

32. Revision
    10.2.0.5650

    Move another old and probably no longer required workaround from MainForm to TExtForm.Create, which shall prevent flicker on Win10

    committed: 23 Jul 2019 13:53 compiled: 23 Jul 2019 14:16

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

33. Revision
    10.2.0.5649

    Move workaround for broken split buttons after translation into TExtForm.Create, so we have it once and the caller does not need to care about it. See https://sourceforge.net/p/dxgettext/bugs/80/

    committed: 23 Jul 2019 13:36 compiled: 23 Jul 2019 13:54

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

34. Revision
    10.2.0.5648

    Update gnugettext unit to rev 128 from http://svn.code.sf.net/p/dxgettext/code/trunk/dxgettext/sample/gnugettext.pas

    committed: 23 Jul 2019 13:24

35. Revision
    10.2.0.5647

    Reapply image list fix for extra space besides top items in main menu, after form translation has taken place

    committed: 23 Jul 2019 13:22

36. Revision
    10.2.0.5646

    Move code from TDBObjectEditor.GetDefiners to new TDBConnection.AllUserHostCombinations

    committed: 22 Jul 2019 07:44 compiled: 22 Jul 2019 07:47

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

37. Revision
    10.2.0.5645

    Get back important comment which I had moved to the wrong place and deleted in fcdf32308682c051b8e9a5858fd2bcfd47da9928. The menu space issue still exists with the default Windows style.

    committed: 22 Jul 2019 07:30

38. Revision
    10.2.0.5644

    Same as for TExtForm: translate in TDBObjectEditor.OnCreate, not in all derived editor classed

    committed: 22 Jul 2019 07:28

39. Revision
    10.2.0.5643

    Remove no longer maintained package files

    committed: 22 Jul 2019 07:20

40. Revision
    10.2.0.5642

    Closed Open Collective account

    committed: 22 Jul 2019 07:19

41. Revision
    10.2.0.5641

    Let TExtForm translate all strings on a form, to reduce the code in any FormCreate event

    committed: 21 Jul 2019 20:12

42. Revision
    10.2.0.5640

    Remove remainders of DPI related code, and move TExtForm.AddSizeGrip procedure to property .HasSizeGrip. Uses TSizeGripXP instead of TSizeGripThemed, as this looks quite the same.

    committed: 21 Jul 2019 19:44

43. Revision
    10.2.0.5639

    Update code from vcl-styles-utils to current master branch from April 03 2019. Disables LegacyIFEND compiler flag so Vcl.Styles.FontAwesome.pas compiles without modification.

    committed: 21 Jul 2019 08:17 compiled: 21 Jul 2019 08:24

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

44. 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)

45. 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)

46. 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)

47. 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)

48. 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)

49. 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)

50. 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)

Imprint