HeidiSQL
Software allowing you to see and edit data for different database structures
Operating system: Windows
Publisher: Ansgar Becker
Release : HeidiSQL RC3 3.0
Antivirus check: passed
HeidiSQL are MySQL and Microsoft SQL database management applications. This tool allows the user to view and edit data, create and edit tables, procedures, triggers and scheduled events. The database structure and data itself can be exported to SQL files, clipboard or other servers.
HeidiSQL enables efficient management and manipulation of databases with its user-friendly interface and robust features.
- the program is free - OpenSource;
- will connect to multiple servers in the same window;
- can connect to the server via the command line;
- SSH encryption of the connection;
- Direct export of data structure and data itself from one server to another;
- Setting user rights;
- import of text files;
- Export tables to CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array formats;
- Viewing and editing tabular data in a convenient graphical shell;
- batch import of ascii and binary files to tables;
- Writing queries with syntax highlighting and code line autocompletion functions;
- search for specific text in all tables, all databases on one server;
- Optimization and recovery of tables in batch mode;
- Launch the mysql.exe command line parallel window using the current connection settings and much more...
PROS
Supports multiple database systems.
Features powerful tools for data manipulation and analysis.
CONS
Does not support all database types.
Occasional crashes and stability issues.
