EMS SQL Manager is a powerful software for managing and developing MySQL databases. It is compatible with all versions of MySQL and supports the latest features, such as triggers and views. It offers high performance and efficient administration tools.
This software enables you to create and edit all MySQL database objects, design MySQL databases visually, run SQL scripts, import and export MySQL database data, and manage MySQL users and their privileges. Moreover, it has many other useful features for efficient MySQL administration.
The state-of-the-art graphical user interface of SQL Manager for MySQL has a well-described wizard system, making it easy to navigate for both professionals and newbies. It supports UTF8 data, allowing database management and navigation to be performed rapidly. The simple management of all MySQL objects and advanced data manipulation tools make it easy to modify MySQL databases with ease.
Furthermore, the software has powerful security management features, including visual and text tools for query building, impressive data export and import capabilities, and report designer with clear report construction wizard. Users can also take advantage of the powerful Visual Database Designer tool and easy-to-use wizards performing MySQL services.
SQL Manager for MySQL also enables users to connect to MySQL Server through HTTP or SSH, providing flexibility in database management. Overall, EMS SQL Manager for MySQL is an excellent tool that provides efficient and effective MySQL database administration and development.
Version 5.4: Now the table editor for MariaDB servers supports such storage engines as PBXT, Aria, SphinxSE. Such privileges as TRIGGER, CREATE VIEW, SHOW VIEW were added to tables Grant manager. The data export speed is increased. Lots of other improvements and bug-fixes.
Version 4.5:
Search in metadata is implemented.
Windows 7 support is added.
Procedure and Function Editors. Now when compiling a procedure, its privileges are automatically recreated.
Data Editor. Set to Now operation does not post data for newly created and edited records.
and more improvements
Version 4.2:
- Building the dependencies on the corresponding editor tabs is improved
- The Code Completion feature was improved. Added highlighting of MySQL 6.0 reserved words
- Fixed Korean locale in Windows. Character data in tables was displayed improperly
- Lots of other improvements and bugfixes
Version 4.1:
- SQL Editor: added a hint listing parameters for added procedures and functions
- Ability to maximize SQL definition editor window
- BLOB Editor now allows one to browse TEXT fields
- Extract Database tool runtime has been considerably shortened
- Lots of other improvents and bugfixes
Version 4.0:
- Support of UTF8 data in SQL Editor, Query Builder, Grid View, Data Export/Import Wizard.
- Multitasking in SQL Editor an Query Builder
- New improved SQL Editor of the Visual Studio 2005 kind with Code Folding function and UNICODE support.
- All Wizards run in the background mode.
Version 3.7:
- Added support for Scheduled Events;
- HTTP tunnel now can work through HTTPS protocol;
- Added support of NDBCluster and BlackHole storage engines;
- CPU usage significantly decreased;
- Other improvements and bugfixes...
Version 3.6.5:
- SQL Editor. Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs.
- Query Builder. Support of queries containing the tables from different databases hosted on one server is implemented.
- Create Table. Added comment support for tables.
- Server Properties. Now connection with SSH and HTTP tunnels is supported.
- Other improvements and bugfixes.
Version 3.6: SQL Formatter has been implemented, a lot of improvements and bugfixes have been made.
Version 3.5:
1. Triggers support implemented.
2. Visual Query Builder.
- Support of subqueries and UNION joins.
- Ability to create INSERT/UPDATE/DELETE statements.
3. Now the program notifies itself of new versions released and it updates
the needed files when SQL Manager Direct is enabled to automatic update.
4. Some improvements and bugfixes.
Version 3.4:
- New data options;
- Ability to rename views, procedures and functions;
- Small improvements and bugfixes...