HeidiSQL is a useful and reliable tool designed for web developers using the popular
MySQL server, Microsoft SQL databases
It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.
Also, you can export structure and data either to SQL file, clipboard or to other servers.
Exact version tested: 220.127.116.1184
I regularly update this program with each new release. No
problems when updating - I just download the update executable and run
it in the drive.
In my opinion this is a professional tool and the developer does a lot of work to keep it going. Consider donating as it is worth it.
My day-to-day tasks include:
- Querying MySQL DB
- Updating large datasets
- SELECTing large resultsets
- Managing the DB
- Importing/Exporting data
- Creating DBs, DB Tables and so forth
I use this tool as my workbench DB explorer and it is awesome.
What does not
Nothing to my knowledge. I use this program on a day to day basis to connect to production servers running MySQL and PGSQL.
What was not tested
In order to use connections over SSH you will need to use Putty and more-specifically it's PLINK.EXE ! Put it in the same virtual drive somewhere and reference it in Heidy's Session Manager. Tip: If you want multiple concurrent connections using SSH and PLINK.exe each one must have a different port in the SSHTunel tab.
|Operating system||Test date||Wine version||Installs?||Runs?||Used|
|Current||Debian GNU/Linux 8.x "Jessie"||Nov 06 2015||1.7.54||Yes||Yes||Platinum||Borislav Sabev|
|Show||Arch Linux x86_64||Sep 18 2015||1.7.51||Yes||Yes||Silver||an anonymous user|
|Show||Debian GNU/Linux 8.x "Jessie" x86_64||Jul 28 2015||1.7.42||Yes||Yes||Platinum||Borislav Sabev|
|Show||Ubuntu 15.10 "Wily" amd64 (+ variants like Kubuntu)||Oct 30 2015||1.6.2||Yes||Yes||Platinum||an anonymous user|