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

   Fix broken undo history after applying auto-uppercase. Closes #541. Also support auto-fixing case of known database objects.

   committed: 19 Sep 2019 20:10 compiled: 19 Sep 2019 20:27

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

2. Revision
   10.2.0.5693

   Issue #712: insert Unicode arrow characters in query result tabs and status bar panel, and unify order of x + y

   committed: 17 Sep 2019 20:22 compiled: 17 Sep 2019 20:27

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

3. Revision
   10.2.0.5692

   Issue #515: give ReadTextfileChunk a BufferPadding of 1 instead of 10M. With 10 attempts, we get a maximum of 10 Bytes which is more than enough to get a complete character in any multibyte encoding. See https://github.com/HeidiSQL/HeidiSQL/issues/515#issuecomment-527858110

   committed: 17 Sep 2019 19:59

4. Revision
   10.2.0.5691

   Add menu item "Open URL" to grid context menu, enabled only if underlying field text is a HTTP URL. Closes #692

   committed: 16 Sep 2019 20:37 compiled: 16 Sep 2019 21:28

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

5. Revision
   10.2.0.5690

   Issue #746: Call SetString with UTF8String instead of String, as advised on https://stackoverflow.com/q/57951463/4110077 . Hopefully nails the decoding issue.

   committed: 16 Sep 2019 19:41 compiled: 16 Sep 2019 19:50

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

6. Revision
   10.2.0.5689

   Issue #746: prefer AnsiString over Byte data type for buffering http request result.

   committed: 15 Sep 2019 19:08 compiled: 15 Sep 2019 19:27

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

7. Revision
   10.2.0.5688

   Get schema with the same name as user name in search path. See https://www.heidisql.com/forum.php?t=34558

   committed: 14 Sep 2019 15:27 compiled: 14 Sep 2019 15:57

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

8. Revision
   10.2.0.5687

   LogSQL: move MainFormCreated flag activation above first wanted debug messages, and include client's time zone offset in log panel

   committed: 13 Sep 2019 17:57 compiled: 13 Sep 2019 18:27

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

9. Revision
   10.2.0.5686

   Issue #746: log result of donor check in log panel, move http request from FormCreate to AfterFormCreate, and repaint image after show/hide

   committed: 13 Sep 2019 17:52 compiled: 13 Sep 2019 17:57

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

10. Revision
    10.2.0.5685

    Issue #746: Reset http request timeout from 3s to 10s in donor check. Probably some requests take a bit longer on the new webserver.

    committed: 13 Sep 2019 06:08 compiled: 13 Sep 2019 06:27

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

11. Revision
    10.2.0.5684

    Issue #654: reduce very frequent calls to Application.ProcessMessages while import dialog shows, down from 1 call per command to 1 call per second

    committed: 08 Sep 2019 09:41 compiled: 08 Sep 2019 09:57

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

12. Revision
    10.2.0.5683

    Prevent file read issues: THttpDownload.SendRequest() now stores the response in a string variable if the passed file name is empty.

    committed: 26 Aug 2019 14:00 compiled: 26 Aug 2019 14:08

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

13. Revision
    10.2.0.5682

    Trim linebreak from right side of detected procedure parameters. See https://www.heidisql.com/forum.php?t=34518

    committed: 26 Aug 2019 07:34 compiled: 26 Aug 2019 07:57

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

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

15. Revision
    10.2.0.5680

    Fix non applied font name on some link labels

    committed: 20 Aug 2019 21:11

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

40. Revision
    10.2.0.5655

    Remove useless DPI helper panel from preferences dialog tabs

    committed: 25 Jul 2019 07:28

41. Revision
    10.2.0.5654

    Remove useless DPI helper panel from session manager tabs

    committed: 24 Jul 2019 07:38

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

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

44. Revision
    10.2.0.5651

    Prefer inline code over outsourced one-time used function BestTableName

    committed: 23 Jul 2019 17:38

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

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

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

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

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

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

Imprint