HeidiSQL is simple tool designed for web-developers using the popular MySQL-Database. It allows you to manage multiple database connections and browse your databases or tables from an intuitive Windows interface.
HeidiSQL 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.
Here are some key features of "HeidiSQL":
· Generate nice SQL-exports
· Synchronize tables between two databases
· Manage user-privileges
· Import text-files
· Export table-data as CSV, HTML, XML and SQL
· Browse and edit table-data using a comfortable grid
· Create and edit tables, views, stored routines and triggers
· Bulk edit tables (move to db, change engine, collation etc.)
· Batch-insert ascii or binary files into tables
· Write queries with customizable syntax-highlighting and code-completion
· Pretty reformat disordered SQL
· Monitor and kill client-processes
· Connect to servers via commandline
· Find specific text in all tables of all databases of one server
· Optimize and repair tables in a batch manner
Requirements:
· MySQL Server
· SQL Server
What's New in This Release: [ read full changelog ]
· Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export
· Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created
· Threaded query execution, including a button to stop long running queries
· Enhanced completion proposal
· Grid editing support for binary primary keys
· Implement multi statements in one go for query tabs, to speed up large scripts with many single queries
· User manager: Random password proposals in dropdown menus
· User manager: Support account resource limits
· User manager: Support SSL settings
· Support pluggable authentication on MariaDB 5.2 and MySQL 5.5.7
· Indicate MariaDB and Percona Server with appropriate icons
· Support virtual columns on MariaDB
· File import dialog rewritten
· Session list now resizable instead of auto-sized
· Finally fix NULL-error for FOREIGN_KEY_CHECKS in SQL export
· Support "tabs to spaces" in query editor
· Paint Windows 7 taskbutton progress bar e....
Find us on Google+
Part of the 
