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: 18.104.22.16884
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|
|Show||Antergos||Jan 20 2018||3.0||Yes||Yes||No||Platinum||Tijder|
|Show||Slackware64 14.2 multilib||May 10 2017||2.5||Yes||Yes||Platinum||Zootal|
|Show||Arch Linux x86_64||Dec 08 2016||1.9.24||Yes||Yes||Platinum||Steffen Rieke|
|Show||Arch Linux x86_64||Apr 28 2016||1.9.9||Yes||Yes||Platinum||an anonymous user|
|Show||Arch Linux x86_64||Mar 25 2016||1.9.6||Yes||No||Garbage||an anonymous user|
If you need to use MSSQL you have to install mdac28 via winetricks.