Portable HeidiSQL Download

A lightweight, fast and flexible application worth having when you need to manage and organize multiple MySQL database connections

Portable HeidiSQL is a reliable and straightforward application whose main purpose is to help you manage and organize multiple database connections effortlessly.

When you launch the application for the first time, you are required to add a new connection. Irrespective of which database you choose to connect to, be it MySQL or SQL Server. you need to specify the hostname, the user name and the password. The Advanced tab from the ‘Session manager’ window allows you to use SSL encryption so you can secure your databases and protect them from unauthorized access.

After you configure the connection, a new entry will appear in the left panel of the application. You can double-click it and all the available tables will appear in a drop-down list. Then, you can easily view the columns, the indexes and the foreign keys for each table. What’s more, you are able to alter the current table the way you want by removing or adding new columns, changing the primary keys or setting new variables.

Because it is mainly designed for web developers and database administrators, Portable HeidiSQL enables them to export structure and data either to a new SQL file, clipboard or to other servers.

What’s more, using Portable HeidiSQL you are able to manage user authentication and privileges by changing its credentials and limitations, dump database objects to a new SQL file and close or open multiple database connections.

Additionally, you can automatically reformat disordered SQL scripts so you can make them more readable, stop on errors in batch mode and view binary data as text.

For those of you who want to change data appearance and shortcuts, modify the font and enable completion proposal, the ‘Preferences’ window stays at your disposal. You are able to change the tab width, the grid text colors and customize other settings as you want.

Because it is a portable utility, you can carry it with you wherever you go on a removable drive and use it on any computer. It has the same functionality as the standalone edition. still it creates no registry entries and you can remove it simply by deleting its containing folder.

Considering all of the above, Portable HeidiSQL proves to be a steady and effective solution when it comes to managing and storing multiple database connections, as well as performing various modifications to specific tables such as altering them, changing the primary key and adding new columns.

CURRENT VERSION: 9.3.0.4984 FILE SIZE: 4.4 MB DEVELOPER: Ansgar Becker RUNS ON: Windows XP / XP 64 bit / Vista / Vista 64 bit / 7 / 7 64 bit / 8 / 8 64 bit / 10 / 10 64 bit CATEGORY: C: \ Portable Software \ Internet \ Servers

Versionshistorik for HeidiSQL (portable)

• * Bugfix: Crash in foreign key dropdown editor
• * Bugfix: Crash when killing processes on very long running servers
• * Bugfix: SQL error when accessing UUID and JSON columns in PostgreSQL via SUBSTR
• * Bugfix: MSSQL: Prefer "schema.table" quoting over "schema"."table" when renaming a table
• * Bugfix: Fix column type converted to locale string format by String.ToUpper in TDBConnection.GetCreateCode - prefer String.ToUpperInvariant instead, to avoid funny characters in data types
• * Bugfix: MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database
• * Bugfix: MSSQL: Try to use some universal date/time format, by injecting a "T" between the date and the time portion
• * Bugfix: Fix wrong detection of BIT default values
• * Bugfix: Use "SET search_path TO db" instead of "SET SCHEMA db" for changing a database in PostgreSQL, for downward compatibility reasons
• * Bugfix: Prepend 'E' to escaped PostgreSQL strings
• * Bugfix: Use updated URL for MariaDB Explain analyzer, and encode semicolon in URL parameter
• * Bugfix: User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+
• * Bugfix: Fix various selection bugs in column selection panel
• * Bugfix: Fix SQL error in "Copy table" dialog, in PostgreSQL mode. Use lowercase table and column names in IS.TABLES, so PG can find them
• * Bugfix: CSV import: Disable features supported in MySQL only, if active connection is not MySQL
• * Bugfix: PostgreSQL: Always keep public schema in search path, so one can use procedures from it without prefixing
• * Bugfix: Text import: Use very last value from last row, even if it's not followed by a field or line terminator
• * Bugfix: PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment
• * Bugfix: Update VirtualTree component code to v6.1.0, to fix graphical issues in Windows 8 + 10
• * Enhancement: Show error when SSH port is already in use
• * Enhancement: Add support for PostgreSQL's data types uuid, cidr, inet and macaddr
• * Enhancement: Strip folder path from various file settings, including plink.exe location, if it's the application directory
• * Enhancement: Try higher ports, up to the 20 next ones, as SSH local port, when the configured one is in use
• * Enhancement: Display session name in caption of all message dialogs
• * Enhancement: Add a custom icon for confirmation dialogs, with a question mark on it, so we don't have to use the "i" icon.
• * Enhancement: Use server time for data grid > "Insert value" menu items
• * Enhancement: Show line breaks other than Windows style as normal line breaks in text editor
• * New feature: Introduce option for setting the line break style in text cells without breaks
• * New feature: Session manager: Add support for SSL cipher, and add various texthints

• * New feature: Add support for JSON grid export
• * New feature: Add support for Markdown Here grid export
• * New feature: Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip. ).
• * New feature: Add support for connecting to Microsoft Azure Servers
• * New feature: Add edit box + updown buttons for limiting the size of exported INSERT queries in bytes.
• * New feature: Display creation time, last alter time, comment and start time of scheduled events.
• * New feature: Online help document available. Various "Help" buttons in relevant dialogs link to this document.
• * Bugfix: Dropping functions and procedures on PostgreSQL now with required parameters list
• * Bugfix: Size bars in "Database" tab on PostgreSQL now with correct values
• * Bugfix: Loading full grid data on PostgreSQL did not work on text columns
• * Bugfix: Fix microseconds in MSSQL date/time data types, hidden in data and query grids.
• * Bugfix: Use ISO 8601 date/time format on MSSQL
• * Bugfix: PostgreSQL: Fix wrong order of columns shown in indexes, and show normal indexes also
• * Bugfix: Do not uppercase ENUM values in procedure parameter datatypes
• * Bugfix: Fix crash when right-clicking a database, following by a click on "Drop"
• * Bugfix: Version conditional disabling for "Create new" menu items in MySQL mode only
• * Bugfix: TEXT data type has a maximum length of 65k for MySQL only. Introduce other values for MSSQL and PostgreSQL.
• * Bugfix: Fix memory leak in TfrmTableTools.SaveSettings
• * Bugfix: Let longer data type matches win over shorter ones, especially important on PostgreSQL
• * Bugfix: Make TPGConnection.FetchDbObjects compatible to pre-9.0 servers on PostgreSQL
• * Bugfix: Fix non working addition of new columns in MySQL
• * Bugfix: Detect xid type (oid 28) as integer.
• * Bugfix: Detect character type (oid 1042) as char, not varchar.
• * Bugfix: Detect aclitem[] type (oid 1034) as unknown, not text.
• * Bugfix: Fix detection of PostgreSQL data type INTERVAL as VARCHAR.
• * Enhancement: Automatic storing of settings in portable mode
• * Enhancement: Optimize query for getting total row count on PostgreSQL
• * Enhancement: Add support for microsecond precision of MSSQL date/time types in table editor, show these in "Length/Set" column
• * Enhancement: Add a help button to the quite non-intuitive controls on the export dialog
• * Enhancement: Add support for JSON data type on PostgreSQL
• * Enhancement: Add support for HIERARCHYID data type on MSSQL
• * Enhancement: Increase various default values for window dimensions, for reasonable look and feel for new users
• * Enhancement: Add "Rename" context menu item in session tree.
• * Enhancement: Use local number formatting in grids by default
• * Enhancement: Use transparent background for NULL cells by default
• * Enhancement: Support columns with a string literal as default value plus an ON UPDATE CURRENT_TIMESTAMP clause.
• * Enhancement: Increase compatibility when getting procedure body on MSSQL.
• * Enhancement: Remove duplicates from recent file list pulldown.
• * Enhancement: Translate connected/disconnected words in status bar
• * Enhancement: Set focus on filter box when SQL help dialog opens.
• * Enhancement: Update gettext unit
• * Enhancement: Make search/replace dialog resizable
• * Enhancement: Activate "Clear filter" button after applying text to filter memo.
• * Enhancement: Gracefully remove superfluous WHERE keyword from data grid filter, so other places like the previously modified "More filters" menu do not add a second WHERE.
• * Enhancement: Use existing data grid WHERE filter to filter values from quick filter > "More values".
• * Enhancement: Remove outdated details in readme file, and redirect to official help page instead.
• * Enhancement: Detect all array style types on PostgreSQL as unknown type, e.g. TEXT[].
• * Enhancement: Pass column or argument name to NativeToNamedColumnType(), as a hint for the user.
• * Enhancement: Support quoted datatypes in TDBConnection.GetDatatypeByName, coming from TDBConnection.ParseTableStructure

• This is a maintenance release, fixing a build update problem on Win64, along with various other fixes and the new comment field on the session manager.

• New feature: Fast table status for databases with InnoDB tables. (Disable Session > Advanced > [X] Get full table status)
• New feature: Favorites in database tree
• New feature: Append parameter names for procedures and functions in completion proposal
• New feature: Compressed .sql file export
• Migration to the brand new Delphi XE 5 compiler
• Replace out-dated code which partly not runs in 64 bit mode
• Update gettext unit
• Update Cromis.DirectoryWatch unit
• Update VirtualTree component code to 5.2.1 (r567)
• Update SynEdit component (r114)

• Make snippets directory customizable. Fixes issue #3276
• Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
• Introduce Win7+ jump items on task button. See http://www.heidisql.com/forum.php?t=12385.
• Introduce the new data option "Local number format"
• Remove "Run file" dialog, and use a standard Windows IProgressDialog instead when executing a SQL file.
• Add CHECK option "FOR UPGRADE" to maintenance dialog. Fixes issue #3279.
• Provide edit box for custom NULL value, in grid export dialog. See http://www.heidisql.com/forum.php?t=13075
• Support length of "max" in data types. Used in MSSQL.
• Issue #3212: Add schema support in MSSQL.
• Add overlay icons for table engines Blackhole and MergeMyISAM.
• Add preference option and logic for alternating grid row background colors. Fixes issue #2820.
• Display values in grid columns which the user explicitly sets to be a UNIX timestamp in date/time format. Fixes issue #3215.
• Append instead of overwrite data grid filter when user has Shift pressed. Fixes issue #865.
• Issue #3191: Implement a simple search/replace dialog in the popup text editor.

• Available in 23 languages now. Thanks to all translators and Transifex hereby!
• Database tree: Introduce optional folders for tables, views, routines etc.
• Introduce session folders in session manager.
• Make routine editor work on MS SQL servers.
• Support search and replace in data and query results.
• Add support for microseconds in temporal datatypes of MariaDB 5.3+ and MySQL 5.6.
• Introduce a query history, available in the right side helpers box. Can be turned off.
• Implement grid export as PHP array.
• Host > Variables: Add "Global" column, and highlight values different to their session pendant
• Add menu item for launching mysql.exe command line with current parameters.
• Table editor: Fix handling of BIT default values, and support BIT columns in MS SQL.
• Table editor: Improve selection of ENUM and SET default values
• User manager: Support dots in database and table privileges
• Data grids: Support copying/pasting NULL values
• Fix stripped backslashes in VIEW body editor
• Apply hotkeys to dialog buttons
• Grid export: Remove zero padding to avoid octal => integer conversion in PHP
• Data grid: Propose column names from selected table in filter panel
• Database and new table filter above database tree
• Table editor: Display number of selected columns in status bar
• Database tree: Indicate previously selected tables with a non-ghosted icon in the tree, while leaving never selected ones ghosted
• Display timestamp in very right status bar panel when executing a query
• Table editor: Add missing DATE and TIME datatypes for MS SQL
• Table editor: Support old style "TYPE BTREE" in table index code
• Routine editor: Finally fix ramshackle detection of routine body
• Data grid: Make foreign values drop down optionally
• Dialogs: Introduce "KeepAskingSetting" checkbox
• Session manager: Move startup script and local time zone options together with SSL settings to a new "Advanced" tab
• SQL export: Support filename and dirname patterns in export target combobox
• Database tree: Display overlay icons for some special table engines like federated, csv, aria and performance_schema
• Implement an automatic keep-alive ping, to prevent SSH tunnels from disconnecting
• Add support for renaming tables in MS SQL
• Fix crash on exit when connected to pre-4.1 servers
• Table editor: Enhance MS SQL compatibility in table editor
• Fix and enhance handling of multiple statements and multiple results
• Grid export: Add "Include query" and "Include auto increment column" checkbox options
• Processlist: Add link label "EXPLAIN Analyzer on MariaDB.org"
• Internal: Refactor logic for reading and writing application and session settings
• Session manager: Introduce new columns "Last connect" and "Counter"
• Extend the variable editor to explicitly modify strings, numbers, booleans or enumerations
• Detect client timezone and send SET time_zone to the server, so that NOW() and friends return UTC-fixed values
• Session manager: Add server specific icons for TokuDB, InfiniDB and Infobright
• Session handling: Use home brown file format for exporting and importing registry settings, as used for the portable version
• Implement usage of mysql_warning_count(). Ask for running SHOW WARNINGS in a new query tab.
• Fix command line for Wine users
• Introduce new preference option "Prefill empty date/time fields".
• Restore previous selection after refreshing process list (and neighbor tabs)

HeidiSQL - portable and feature rich MySQL client

I was stuck with native Query Browser for a while, but mostly because at the time it was stable and reliable choice for horribly outdated MySQL installation (embedded in software product).

Lately I’ve been revisiting MySQL frontend tools in context of web hosting and HeidiSQL clicked with me almost immediately as light yet feature-rich client .

As any tool of such kind the task HeidiSQL performs is quite defined – connect to database(s) and retrieve or manipulate data. So difference between tools boils down to performance, convenience and extra functions that go beyond running simple SELECTs all day long.

This one scores nicely on all:

• database is accessed directly;

• interface is very responsive and sufficiently visual;

• there are plenty of functions to make life easier.

As for general usage I like that app has live log that displays any and all operations you perform – both those run explicitly by queries and anything else like just navigating around. It is good reference, educational  and queries from there can be quickly copied as text or into new query tab via context menu.

Among more impressive functions – export implementation is great. While going through exporting/importing through a file is no-brainer in most tools, HeidiSQL actually allows you to set up transfers between different servers. Not much difference on technical level, but huge improvement to the workflow.

Oh, and global (as in whole database or server) search. I wish someone told me about this some years back.

While export/migrate is very impressive, import is somewhat more basic – SQL and CSV. Good enough, but stuffing some Excel file into table would seem common enough task to be supported.

At times interface gets confusing (in how-do-I-unpress-what-I-just-pressed fashion) and also a little glitchy (like buttons on toolbar duplicating).

Snappy and functional open source app with native portable version available. Doesn’t quite compete at level of commercial front-end monsters of a software, but still very useful.

Как удалить

Как вы поступите с файлом heidisql.exe?

Как другие пользователи поступают с этим файлом?

Всего голосов (2 ), 1 говорят, что не будут удалять, а 1 говорят, что удалят его с компьютера.

папка: f:>>taller vi reunion notificacion 2015>base de datos>gestor>heidisql_9.2_portable>heidisql.exe частью: HeidiSQL компания: unknown company Версия продукта: размер: 3829047 MD5= 276b868c302ed4763f236ba1e1e4211a

папка: d:>program files>heidisql>heidisql.exe частью: HeidiSQL компания: unknown company Версия продукта: размер: 3410944 MD5= dc513b324b47a54893a15240bcb258b2

папка: c:users afael f. rodr?guezdownloadsutilesheidisql_8.3_portableheidisql.exe частью: HeidiSQL компания: unknown company Версия продукта: размер: 3551543 MD5= 41b2d4840023f7e7a7ac191bf5d11a74

папка: частью: unknown product компания: Unknown company Версия продукта: unknown version размер: 6827063 MD5= 1982bfefeaa9398e8ea5e1513e9473a0

скачать бесплатно Dr Prot Antivirus

HeidiSQL Portable

HeidiSQL – portable and feature rich MySQL client. I was stuck with native Query Browser for a while, but mostly because at the time it was stable and reliable choice for horribly outdated MySQL installation (embedded in software product). Lately I’ve been revisiting MySQL frontend tools in context of web hosting and HeidiSQL clicked with me almost immediately as light yet feature-rich client. As any tool of such kind the task HeidiSQL performs is quite defined – connect to database(s) and retrieve or manipulate data. So difference between tools boils down to performance, convenience and extra functions that go beyond running simple SELECTs all day long.

HeidiSQL is a powerful and easy client for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL. Open source and entirely free to use. Скачать STDU Viewer 1.6.375 - STDU Viewer - бесплатная программа для чтения электронных документов. PortableApps.com - Portable software for USB, portable and cloud drives.

Download HeidiSQL 9.3 () HeidiSQL 9.3 Installer; Portable; Sourcecode; HeidiSQL runs fine on Windows (XP, Vista, 7, 8, 10) and - with Wine - on any Linux. HeidiSQL ?????????? MySQL ?????????????????????????????,???,?????. Popular Alternatives to HeidiSQL for 29 platforms including iPhone, Android, Android Tablet, and Windows Phone. Explore 48 apps like HeidiSQL, all suggested and.

This one scores nicely on all. database is accessed directly;. interface is very responsive and sufficiently visual;. there are plenty of functions to make life easier. Strong features. As for general usage I like that app has live log that displays any and all operations you perform – both those run explicitly by queries and anything else like just navigating around.

It is good reference, educational  and queries from there can be quickly copied as text or into new query tab via context menu. Among more impressive functions – export implementation is great. While going through exporting/importing through a file is no-brainer in most tools, HeidiSQL actually allows you to set up transfers between different servers.

Not much difference on technical level, but huge improvement to the workflow. Oh, and global (as in whole database or server) search. I wish someone told me about this some years back. While export/migrate is very impressive, import is somewhat more basic – SQL and CSV. Good enough, but stuffing some Excel file into table would seem common enough task to be supported. At times interface gets confusing (in how-do-I-unpress-what-I-just-pressed fashion) and also a little glitchy (like buttons on toolbar duplicating). Snappy and functional open source app with native portable version available.

Doesn’t quite compete at level of commercial front-end monsters of a software, but still very useful.

Скачать Volume2 1.1.4.347 - Volume2 - очень удобная программа, дающая пользователю возможность.

HeidiSQL - Работа с MySQL базами данных

Уважаемый читатель, сегодня я познакомлю вас с заменителем тормознутого, непонятного, некрасивого phpMyAdmin -а в области работы с SQL-базами данных на локальном компьютере.

Встречайте! Отличная программа HeidiSQL. Благодаря данной утилите вы сможете существенно упростить и ускорить процесс работы с SQL-базами данных, легко и непринужденно создавать новые базы, заполнять их таблицами, управлять пользователями.

К сожалению, в подавляющем большинстве случаев, программа не сможет соединится с удаленной базой данных хостинг-провайдера, поэтому прерогатива HeidiSQL – это локальная среда разработки.

Так же огромным плюсом данной программы является ее бесплатность.

Это лучшее, на мой взгляд, приложение, позволяющая работать с базами данных на локальном компьютере.

Дистрибутив программы HeidiSQL можно скачать с сайта разработчика. После элементарно простой процедуры установки вы сразу сможете производить соединение с локальным MySQL-сервером.

• В строке Hostname / IP указываем локальный IP 127.0.0.1
• User – здесь нужно указать имя администартора root.
• Password – в данном поле указывается пароль администратора root, которой вы задавали на этапе установки и настройки MySQL-сервера .

Все остальные поля можно оставить пустыми. Нажимайте Connect! и соединяйтесь с MySQL-сервером.

Если настройки подключения были заданы правильно, то вы увидите интуитивно понятный интерфейс программы:

В качестве мануали по основным функциям предлагаю вам посмотреть видеоурок по работе с программой HeidiSQL.

Видео на сервисе RuTybe:

Первая часть видео на сервисе YouTube:

Вторая часть видео на сервисе YouTube:

Поскольку алгоритмы сжатия сервисов YouTube и RuTube серьезно ухудшают качество видео и мелкие детали становятся плохо различимы я загрузил видео в лучшем качестве на Deposit Files.

Online Antivirus Scanner Report for Portable HeidiSQL

Antivirus Scanner Status Clean

Portable HeidiSQL has been downloaded and scanned by FileCluster on Mar 23, 2012 with a 4-in-1 antivirus security solution, composed by: BitDefender Antivirus Pro, NOD32, Avira Antivirus and Kaspersky Antivirus. Portable HeidiSQL was found clean of any form of viruses, spyware or malware, making it safe to install on any system. For improved security, Portable HeidiSQL will be retested with every version update.

Get the security badge Share this report

NOTE: We strongly recommend checking this page before downloading future version updates of Portable HeidiSQL, the antivirus report status might change.