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

   Issue #140: Be sure to write tab backup files in UTF8 without BOM

   committed: 15 Oct 2019 07:07 compiled: 15 Oct 2019 07:27

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

2. Revision
   10.2.0.5716

   Issue #140: Prefer TStreamWriter over TFileStream, in SaveUnicodeFile(). Also, use its own Write() method instead of StreamWrite(), which encodes UTF8 first, so the new approach is probably faster. Probably also helps with non-writable tab backups on some systems.

   committed: 13 Oct 2019 16:38 compiled: 13 Oct 2019 16:56

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

3. Revision
   10.2.0.5715

   Issue #704: detect pre-authentication banner messages as informational (not as error) in plink output

   committed: 13 Oct 2019 14:48 compiled: 13 Oct 2019 14:57

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

4. Revision
   10.2.0.5714

   Issue #704: check result of "SHOW ssl" for whether SSL is really being used

   committed: 13 Oct 2019 14:35

5. Revision
   10.2.0.5713

   Issue #704: escape backslashes in SSL certificate files for PostgreSQL connections

   committed: 11 Oct 2019 07:53 compiled: 11 Oct 2019 07:57

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

6. Revision
   10.2.0.5712

   Remove the SHAutoComplete() call to revert the solution for #144 - this introduces too many new bugs.

   committed: 08 Oct 2019 19:26 compiled: 08 Oct 2019 19:56

   Downloads: 32bit build (7.9 MB)64bit build (8.4 MB)32+64bit installer (20.1 MB)

7. Revision
   10.2.0.5711

   Update libmariadb.dll and various plugins, add 2 new ones: client_ed25519 and auth_named_pipe. Probably solves #754

   committed: 08 Oct 2019 19:05 compiled: 08 Oct 2019 19:27

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

8. Revision
   10.2.0.5710

   Revert 355db1403aff5c7d061962f3ca21c62bcd8001f8 for #144, which makes the Tab key ineffective. Closes #765

   committed: 07 Oct 2019 20:27 compiled: 07 Oct 2019 20:57

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

9. Revision
   10.2.0.5709

   Issue #762: add informational message when foreign key'd column has too many rows in the connected table, and raise limit from 1000 to 10000.

   committed: 05 Oct 2019 14:09 compiled: 05 Oct 2019 14:26

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

10. Revision
    10.2.0.5708

    To retrieve a column default value, prefer pg_attrdef.adbin column over pg_attrdef.adsrc. PostgreSQL 12 does not have adsrc. Closes #763

    committed: 05 Oct 2019 12:08 compiled: 05 Oct 2019 12:26

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

11. Revision
    10.2.0.5707

    Issue #62: distinct between TIMEZONE (without time zone) and TIMEZONETZ (with time zone). And modify GetDatatypeByName() so it deletes the longest detected datatype string PostgreSQLDatatypes.Names . This solves empty/undetected column comments in ParseTableStructure(). See https://www.heidisql.com/forum.php?t=23211#p34709

    committed: 05 Oct 2019 08:04 compiled: 05 Oct 2019 08:27

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

12. Revision
    10.2.0.5706

    Fix glitch in previous commit for #62: never escape \, and don't overwrite text with escaped joker chars. So we just escape %, _ and ' now in Postgres mode.

    committed: 03 Oct 2019 12:19 compiled: 03 Oct 2019 12:27

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

13. Revision
    10.2.0.5705

    Remove "E" prefix from escaped strings, which caused an empty result in ExtractLiteral(). Instead, let EscapeString() escape just \, % and _ with backslash, and ' by a second '. Closes #62

    committed: 03 Oct 2019 12:09

14. Revision
    10.2.0.5704

    Check if (old) grid result is in a valid state before checking for an url. Closes #759

    committed: 01 Oct 2019 19:35 compiled: 01 Oct 2019 19:57

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

15. Revision
    10.2.0.5703

    Issue #541: apply KeyPress event to all other writable SQL editors, so the auto-uppercase feature is available everywhere

    committed: 30 Sep 2019 20:44 compiled: 30 Sep 2019 20:57

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

16. Revision
    10.2.0.5702

    Issue #712: final solution for intuitive result tab captions and line/char panel

    committed: 29 Sep 2019 12:34 compiled: 29 Sep 2019 12:58

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

17. Revision
    10.2.0.5701

    Issue #144: TMemo and friends select their text when pressing Enter, when they were manipulated by SHAutoComplete, so fix that by leaving TCustomMemo as they are

    committed: 28 Sep 2019 16:44 compiled: 28 Sep 2019 16:57

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

18. Revision
    10.2.0.5700

    Issue #719: For message dialog button captions, prefer localized strings from user32.dll over our translation from Transifex

    committed: 26 Sep 2019 20:29 compiled: 26 Sep 2019 20:57

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

19. Revision
    10.2.0.5699

    Issue #144: Change default keystroke for "delete next word" (ecDeleteWord) from Ctrl+T reasonably to Ctrl+Del

    committed: 26 Sep 2019 19:16 compiled: 26 Sep 2019 19:28

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

20. Revision
    10.2.0.5698

    Issue #144: Let grid editors call TExtForm.FixControls on their MainControl, to support Ctrl+Backspace there.

    committed: 25 Sep 2019 20:39 compiled: 25 Sep 2019 20:57

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

21. Revision
    10.2.0.5697

    Issue #144: Move some code out of TExtForm.OnCreate into .DoShow, where it works for more instances of TEdit, e.g. the database and table filter. Also, let the object editors call this code, as they don't derive from TExtForm.

    committed: 25 Sep 2019 20:14 compiled: 25 Sep 2019 20:27

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

22. Revision
    10.2.0.5696

    Issue #144: make Ctrl+Backspace delete the last word of TEdit and TButtonedEdit in any TExtForm

    committed: 25 Sep 2019 17:40

23. Revision
    10.2.0.5695

    Issue #423: add DataTypeCompatibility=80 to connection string, hopefully healing these "multiple step" errors on MS SQL

    committed: 22 Sep 2019 19:35 compiled: 22 Sep 2019 19:57

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

38. Revision
    10.2.0.5680

    Fix non applied font name on some link labels

    committed: 20 Aug 2019 21:11

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

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

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

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

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

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

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

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

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

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

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

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

Imprint