EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

MySQL Products News

EMS SQL Manager for MySQL version 5.0 released

We are pleased to announce the new major version of SQL Manager for MySQL - a high performance tool for MySQL database administration and development. You can download the newest version of the software from the download page.

What's new in SQL Manager for MySQL 5.0?

  1. Added the possibility to debug procedures, functions, triggers and events.
  2. Now it is possible to connect to databases using SSL certificates.
  3. Added the possibility to connect through named pipes.
  4. Added support of new objects: PARTITIONS, TABLESPACE, LOGFILE GROUP and SERVERS.
  5. Added the possibility to compare databases (Database Comparer tool) that allows getting a SQL script for synchronizing database structure.
  6. Database Registration Manager is added. It makes the process of registering and un-registering databases much faster.
  7. Added the possibility to copy objects by groups in the DB Explorer by Drag And Drop.
  8. Added support of MySQL invalid dates. Also it is now possible to set any date and time format manually.
  9. Added the possibility to create procedures, views and functions based on the selected table (through the table menu).
  10. Added the possibility to change table type for several tables at once.
  11. Support of LOAD XML command and SET clause is added in the Load Data Wizard.
  12. Added a new option for keeping connection in the Database Registration info dialog - “Ping database every … seconds”.
  13. Triggers in DB Explorer are now displayed in a separate branch.
  14. Added the possibility to rename databases in DB Explorer and in the database properties dialog.
  15. Added the possibility to disconnect from all connected databases at once.
  16. Now it is possible to set shortcuts not only for SQL Editor commands, but also for other ones (Environment Options | Global Shortcuts).
  17. Export as PHP Page Wizard is added. It allows exporting data as PHP page.
  18. SQL Formatter now allows formatting DDL statements.
  19. Added the possibility to create templates for new object names.
  20. Added the history of procedure input parameters.
  21. Some other improvements and bugfixes.

Hope you will enjoy working with our software!