HeidiSQL – Free Front-End For MySQL & MSSQL
Most of the MySQL users will remember MySQL-Front, a very popular database manager application which later on stopped being developed (and turned into a paid application by another team).
The developer of this application, Ansgar Becker, re-launched this project under the name HeidiSQL, it is again free + open source and improved regularly.
HeidiSQL can connect to multiple databases and besides creating/editing databases, tables, views, stored routines and triggers, it has support for scheduling events (great for regular jobs like backups).
Databases and records can be exported or imported with multiple formats and its even possible to transfer a database directly into another server.
Currently experimental but HeidiSQL can now connect and manage MSSQL databases which is awesome for anyone working with both platforms.
There are many other handy features offered like optimize/repairing tables, duplicating them or query editing with syntax highlighting.
Website: http://www.heidisql.com/
Download: http://www.heidisql.com/download.php
One Response for "HeidiSQL – Free Front-End For MySQL & MSSQL"
We’ve been using heidisql for a few years now on the windows platform, and rate it really highly. We came across it quite by chance, but really struck lucky. It’s fantastic for productivity having all the usual functionality that windows offers in its usual programming (, right click options, twin-clicks to rename, drag and drop etc) to work in the mysql environment, after the tediousness of the web based interface of phpmyadmin etc.
Thoroughly recommend this. A very nice bit of coding!