Download HeidiSQL 8.0 stable
HeidiSQL runs fine on Windows (XP, Vista, 7, 8) and on any Linux with Wine. On Windows 2000 you might run into some "illegal function call into KERNEL.DLL", which is caused by the newer libmysql.dll which dropped Win2k support. You can fix that by downloading this older one and place it in the HeidiSQL directory, overwriting the original. Previous releases can be downloaded at Google Code.
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.
Link to latest build
Changes Feed
| Revision | Committed | Notes | Compiled .EXE | Installer |
|---|---|---|---|---|
| 4400 | 13 hours ago |
Put session name into caption of login-on-demand dialog, so applications like Keepass can identify it. Fixes issue #3180. |
6,669 KB
293 downloads |
4,052 KB
161 downloads |
| 4399 | 14 hours ago |
Do not restore previous state of checkbox options "Drop database" and "Drop tables", leave them off when calling the export sql dialog. Fixes issue #3197. |
6,669 KB
11 downloads |
4,052 KB
6 downloads |
| 4398 | 14 hours ago |
Leave SQL help action disabled as long as there is no selected connection. Fixes issue #3200. |
6,669 KB
6 downloads |
4,052 KB
5 downloads |
| 4397 | 2 days ago |
Introduce server specific quote characters, so ParseTableStructure() and DeQuoteIdent() do not remove too much. |
6,668 KB
980 downloads |
4,052 KB
629 downloads |
| 4396 | 7 days ago |
Modify installer sidebar image for the next release. |
6,667 KB
1,713 downloads |
4,051 KB
3,086 downloads |
| 4395 | 7 days ago |
Prepare release: Update major version to 8 |
6,667 KB
44 downloads |
4,075 KB
72 downloads |
| 4394 | 7 days ago |
Support default values of BIT columns in table editor and SQL export. Fixes issue #2544. |
6,667 KB
17 downloads |
4,075 KB
11 downloads |
| 4393 | 1 week ago |
Give the datagrid-truncation cast a length of 256 in MSSQL, so we don't just get the CAST default of 30 chars. Fixes issue #3186. |
6,667 KB
1,240 downloads |
4,075 KB
610 downloads |
| 4392 | 2 weeks ago |
Expect dots in database and table names, when parsing SHOW GRANTS results. See http://www.heidisql.com/forum.php?t=12640 |
6,667 KB
4,242 downloads |
4,075 KB
2,300 downloads |
| 4391 | 2 weeks ago |
Turn column default text memo into a TButtonedEdit, and use a right button drop down menu which displays ENUM and SET values. Fixes the ENUM+SET part of issue #1160. |
6,667 KB
858 downloads |
4,075 KB
400 downloads |
| 4390 | 1 month ago |
Use internal flag to remember whether we have a NULL value when copying and pasting in grid fields. Fixes issue #3171. |
6,654 KB
9,740 downloads |
4,070 KB
6,720 downloads |
| 4389 | 1 month ago |
Add "Global" column to ListVariables, and highlight values different to their session pendant. |
6,654 KB
4,588 downloads |
4,069 KB
2,403 downloads |
| 4388 | 1 month ago |
Use "times" symbol × instead of the letter x. See http://www.heidisql.com/forum.php?t=12543 |
6,652 KB
1,225 downloads |
4,069 KB
523 downloads |
| 4387 | 1 month ago |
Block "Empty tables" action if neither dbtree nor dbtab has focus. Fixes issue #3166. |
6,652 KB
323 downloads |
4,069 KB
138 downloads |
| 4386 | 1 month ago |
Append number of columns and rows in query result tab caption. See http://www.heidisql.com/forum.php?t=12543 |
6,652 KB
88 downloads |
4,069 KB
37 downloads |
| 4385 | 1 month ago |
Fix repeated column comment in table editor. See http://www.heidisql.com/forum.php?t=12540 |
6,652 KB
893 downloads |
4,069 KB
336 downloads |
| 4384 | 1 month ago |
Fix wrong offset in db.table string when checking for foreign key match. Fixes issue #3160. |
6,652 KB
552 downloads |
4,069 KB
349 downloads |
| 4383 | 1 month ago |
Try a new approach in TDBConnection.ParseRoutineStructure(). Should fix stripped backslashes from routine body, issue #3107. |
6,636 KB
1,651 downloads |
4,062 KB
739 downloads |
| 4382 | 1 month ago |
Revert helpers.RemoveComments(), accidentally committed in r4110 |
6,636 KB
67 downloads |
4,062 KB
30 downloads |
| 4381 | 2 months ago |
MSSQL stored routine editor: |
6,612 KB
5,763 downloads |
4,051 KB
3,254 downloads |
| 4380 | 2 months ago |
Auto apply distinct accelerator chars to buttons on TTaskDialog. Fixes issue #3150. |
6,610 KB
1,006 downloads |
4,050 KB
444 downloads |
| 4379 | 2 months ago |
Grid export: Remove zero padding to avoid octal => integer conversion in PHP. Fixes issue #3149. |
6,610 KB
1,630 downloads |
4,049 KB
653 downloads |
| 4378 | 2 months ago |
Accept column rename when it has the same name as a deleted column. Fixes issue #3137. |
6,610 KB
1,031 downloads |
4,050 KB
429 downloads |
| 4377 | 2 months ago |
Mark table key as modified after editing its contained column names, so such changes get posted to the server when clicking "Save". Fixes issue #3144. |
6,610 KB
10 downloads |
4,050 KB
14 downloads |
| 4376 | 2 months ago |
Ignore errors due to non existent columns in IS.ROUTINES on MSSQL. See http://www.heidisql.com/forum.php?t=12435 |
6,610 KB
17 downloads |
4,050 KB
17 downloads |
| 4375 | 2 months ago |
Check KeepAskingSetting in MessageDialog() on older Windows versions. Broken since r4302. Fixes issue #3147. |
6,610 KB
1,378 downloads |
4,050 KB
653 downloads |
| 4374 | 2 months ago |
Propose column names from selected table in filter panel. Fixes issue #3140. |
6,609 KB
2,406 downloads |
4,049 KB
1,149 downloads |
| 4373 | 2 months ago |
Return focused tree item in GetFocusedObjects() even if tree is not focused, in cases where database tab does not has focus. Fixes issue #3146. |
6,609 KB
31 downloads |
4,049 KB
23 downloads |
| 4372 | 2 months ago |
Same as r4304: Fix broken drop down buttons on main toolbar, now that MainFormOnTaskBar is missing. |
6,589 KB
3,389 downloads |
4,043 KB
1,841 downloads |
| 4371 | 2 months ago |
Remove MainFormOnTaskBar, revert r3763, to fix issue #2640. Disables support for Windows Flip3D, but who cares. |
6,589 KB
36 downloads |
4,043 KB
40 downloads |
| 4370 | 2 months ago |
Cast TEXT columns as VARCHAR in data grid selection, as MSSQL supports only VARCHAR in LEFT() function. Fixes issue #3141. |
6,589 KB
2,686 downloads |
4,043 KB
1,258 downloads |
| 4369 | 2 months ago |
Issue #2697: Make database + table tree filter case insensitive. See pm from Martin Bedrač. |
6,589 KB
482 downloads |
4,043 KB
242 downloads |
| 4368 | 2 months ago |
Issue #2496: Revert r4366, do not trim definition of MS SQL views. Instead, let the regex in ParseViewStructure() expect CREATE at any point instead of the very beginning of the code. That way the view definition may contain a BOM or any space at the start. |
6,589 KB
98 downloads |
4,043 KB
69 downloads |
| 4367 | 2 months ago |
Move code from several action events to new functions GetFocusedObjects and DBTreeClicked. Detect here whether tree or database tab was the one where user clicked the context menu, instead of just checking which of both is focused. See http://www.heidisql.com/forum.php?t=12351 |
6,589 KB
570 downloads |
4,044 KB
311 downloads |
| 4366 | 2 months ago |
Issue #2496: Trim definition of MS SQL VIEWS before passing to ParseViewStructure(), so its regex may expect CREATE at the very beginning. |
||
| 4365 | 2 months ago |
Issue #2496: Remove square brackets per TDBConnection.DeQuoteIdent() |
||
| 4364 | 2 months ago |
Issue #2496: Support square brackets in MSSQL as an alternative way to quote identifiers. |
||
| 4363 | 2 months ago |
Vtree does not focus cell after tab pressing. Do that by hand in TMainForm.AnyGridFocusChanged. Fixes issue #3139. |
||
| 4362 | 3 months ago |
Rename translation as done in dfm file in r4312 |
||
| 4361 | 3 months ago |
Distinct between traditional and simplified Chinese, add zh_TW translated by jeff.tu. |
||
| 4360 | 3 months ago |
Complete list of contributers in about dialog |
||
| 4359 | 3 months ago |
Rename local variable to what it stands for. |
||
| 4358 | 3 months ago |
Display number of selected nodes from ListTables in status bar. Fixes issue #3127. |
||
| 4357 | 3 months ago |
Include database name in GetCreateViewCode(). Fixes issue #3098. |
||
| 4356 | 3 months ago |
Issue #2697: Move pnlTreeFilter to top. |
||
| 4355 | 3 months ago |
Add missing translation string for r4350. |
||
| 4354 | 3 months ago |
Make use of property writer SetCreateCode, and display errors in SQL log when GetCreateCode failed. |
||
| 4353 | 3 months ago |
Indicate previously selected tables with a non-ghosted icon in the tree, while leaving never selected ones ghosted. |
||
| 4352 | 3 months ago |
Display timestamp in very right status bar panel when executing a query. See http://www.heidisql.com/forum.php?t=12287 |
||
| 4351 | 3 months ago |
Issue #2496: Retrieve VIEW definition from IS.VIEWS, so ParseViewStructure() can parse that code. TODO: Support ALTER command. |
||
| 4350 | 3 months ago |
Add right click menu item for clearing data tab filter on current table. Fixes issue #3125. |
||
| 4349 | 3 months ago |
Fix updating empty binary column value. |
||
| 4348 | 3 months ago |
Make usage of query history optionally. Fixes issue #3122. |
||
| 4347 | 3 months ago |
Add missing DATE and TIME datatypes for MS SQL. Fixes issue #2957. |
||
| 4346 | 3 months ago |
Remove code from TDBQuery.GetKeyColumns which gracefully allows result editing with a partially selected primary key. Fixes issue #2974. |
||
| 4345 | 3 months ago |
Add missing translation strings for db and table filter |
||
| 4344 | 3 months ago |
Turn comboDatabaseFilter into a TButtonedEdit, and place a second one besides it, for filtering tables. Fixes issue #2697. |
||
| 4343 | 3 months ago |
Support BIT data type in MS SQL. Fixes issue #2955. |
||
| 4342 | 3 months ago |
Reposition default value editor so it's not outside the main form. Fixes issue #2868. |
||
| 4341 | 3 months ago |
Make detection of active grid or editor in search/replace dialog more stable. |
||
| 4340 | 3 months ago |
Detect primary and unique keys on MS SQL tables. Makes grid updates safer, and these keys show up in the table designer. Fixes issue #2946. |
||
| 4339 | 3 months ago |
Store last sessions also when connecting to an additional session, not only when closing the program. See http://www.heidisql.com/forum.php?t=12149 |
||
| 4338 | 3 months ago |
Add missing translation string, for r4322. |
||
| 4337 | 3 months ago |
Let ParseRoutineStructure() cache values from IS.ROUTINES into TDBObject members. Fixes issue #3108. |
||
| 4336 | 3 months ago |
Grid export: Export quoted empty string when blob value is empty (SQL INSERTS/REPLACES). Fixes issue #2941. |
||
| 4335 | 3 months ago |
Create database dialog: Remove charset pulldown, leave collation pulldown alone. Init collation pulldown with the server variable "collation_server". |
||
| 4334 | 3 months ago |
Support old style "TYPE BTREE" in table index code. See http://www.heidisql.com/forum.php?t=12150 |
||
| 4333 | 3 months ago |
Get everything except routine parameters from IS.ROUTINES, to fix another regular expression problem in ParseRoutineStructure. Fixes issue #3114. |
||
| 4332 | 3 months ago |
Add missing tool tip hint for disconnect button. |
||
| 4331 | 3 months ago |
Create save/open dialogs per code, not per dfm file. That way, I can remove strings like "SQL files (*.sql)..." from the translation, and only let "SQL files" get translated. Avoids translation errors. |
||
| 4330 | 3 months ago |
SQL export dialog: Arrange controls so translated items fit. |
||
| 4329 | 3 months ago |
Enable OK button when checking "Reset autoincrement" check box. See http://www.heidisql.com/forum.php?t=12143 |
||
| 4328 | 3 months ago |
Fix setting for name of selected database, which must be a session setting, not a global one. See http://www.heidisql.com/forum.php?t=12101 |
||
| 4327 | 3 months ago |
Finally fix ramshackle detection of routine body. Fixes issue #3103, #3104. |
||
| 4326 | 4 months ago |
Work around empty body detected in ParseRoutineBody, and get it from information_schema.ROUTINES in that case. See http://www.heidisql.com/forum.php?t=12075 . |
||
| 4325 | 4 months ago |
Issue #400: Compare data types and unsigned flags of source and reference columns, when leaving foreign column editor. Introduce a more helpful error message when these do not match, as a replacement for the servers poor message "Foreign key constraint is incorrectly formed". |
||
| 4324 | 4 months ago |
Increase height of memoFindText from 26 to 60 pixels. Accidentally resized to a minimum in r4254. See http://www.heidisql.com/forum.php?t=12064 |
||
| 4323 | 4 months ago |
Hide non-InnoDB tables in foreign key editor. See http://www.heidisql.com/forum.php?t=11816 |
||
| 4322 | 4 months ago |
Make foreign values drop down optionally. See http://www.heidisql.com/forum.php?t=11816 |
||
| 4321 | 4 months ago |
No need to rethink height of SQL memos and SQL log when window is minimized. Fixes issue #3093. |
||
| 4320 | 4 months ago |
r4185 broke Host > Variables tab for MSSQL. Introduce SQL specifity for SHOW VARIABLES to fix that. Fixes issue #3100. |
||
| 4319 | 4 months ago |
Strip routine body early in ParseRoutineStructure, so later regular expressions don't get confused by keywords in user SQL. Fixes issue #3085. |
||
| 4318 | 4 months ago |
Display child count on group nodes. Fixes issue #2912. |
||
| 4317 | 4 months ago |
Enable right click options for creating new objects when one of the grouping nodes is focused. Fixes issue #2964. |
||
| 4316 | 4 months ago |
Launch command line: Escape double quotes in password, and fix broken replacement with stars if password contains double quotes. See http://www.heidisql.com/forum.php?t=11976 |
||
| 4315 | 4 months ago |
Revert *.res inclusion from previous commit, to fix compile error "E1026 File not found: 'VirtualTreesR.res'" |
||
| 4314 | 4 months ago |
Update VirtualTree component code to 5.1.0 (r450) |
||
| 4313 | 4 months ago |
Quote db and table name in new function TDBObject.QuotedDbAndTableName, which also adds "dbo" for MS SQL inbetween. Plus, run SELECT in SQL export through ApplyLimitClause, to fix an SQL error on MS SQL. See http://www.heidisql.com/forum.php?t=11956 |
||
| 4312 | 4 months ago |
Support search/replace in data and result grids. Fixes issue #2979. |
||
| 4311 | 4 months ago |
Ignore error at connection time on MS Azure servers without sysprocesses table. Fixes issue #3087. |
||
| 4310 | 4 months ago |
Disallow to drag a session folder somewhere below itself, which would end up in an infinite folder structure, theoretically. Fixes issue #3086. |
||
| 4309 | 4 months ago |
Fix minor memory leak |
||
| 4308 | 4 months ago |
Remove "Created" date/time from SQL export header. Fixes issue #3083. |
||
| 4307 | 4 months ago |
Ensure row count step + maximum settings are never "0". Fixes issue #3080. |
||
| 4306 | 4 months ago |
Fix broken SynEdit compilation: Include added files in project files. |
||
| 4305 | 4 months ago |
Update SynEdit component sources to r100 from https://synedit.svn.sourceforge.net/svnroot/synedit/SynEdit |
||
| 4304 | 5 months ago |
Work around broken ToolButton with Style=tbsDropDown after translation: https://sourceforge.net/tracker/index.php?func=detail&aid=902470&group_id=74086&atid=539908 |
||
| 4303 | 5 months ago |
Add new translation strings, forgotten in previous commit. |
||
| 4302 | 5 months ago |
Introduce "KeepAskingSetting" parameter to MessageDialog(), which activates a verification checkbox left besides the dialog buttons. Use that when confirming to close a query tab, so the user can disable the dialog within the dialog itself, without the need to disable this setting in Preferences > SQL. Fixes issue #3065, which was broken since r4283. |
||
| 4301 | 5 months ago |
Ensure we do not send an empty query, if a single query is larger than the max_allowed_packet setting. This way, we most probably get disconnected anyway, but that clearly leaves responsibility to the user to make the query smaller. |
6,669 KB
4,052 KB