SQL Maestro Group announced the release of SQL Maestro for MySQL 7.8, a powerful Windows GUI solution for MySQL administration and database development.
Reordering columns for existing tables, canceling long-running queries, SQL Formatter, improved Extract Database Wizard and a lot of other useful things.
The new version is available for download here:
http://www.sqlmaestro.com/products/mysql/maestro/download/
New version features:
- SQL Maestro for MySQL is optimized to work with MySQL servers with a small timeout.
- Since this version you can reorder columns for existing tables. It is also possible to reorder parameters for a stored procedure/function and reorder partitions (only for newly created tables).
- It is now possible to cancel a long running query execution (MySQL 5) and data fetching (all MySQL versions).
- Field Editor: the NCHAR and NVARCHAR types are added to the type list.
- Process Browser: session killing now works correctly for all MySQL versions
- The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is implemented. It can be invoked through the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). Also it is now used for view body formatting (MySQL stores such bodies as a single line)
- Data grid: the editor for ENUM fields displays a lookup list with enumeration values.
- Extract Database Wizard is improved. Now it works faster and requires less memory.
- Get SQL Dump Wizard: the result table is now scripted correctly.
- Now SQL Maestro for MySQL displays execution time for lengthy operations.
- The Row count and Data length columns are added to the table list (Database Editor, Object Browser).
- The database hints in the explorer tree now contain connection ID and default character set/collation. Hints for tables and columns are also included character set and collation, but only if they are different from database default.
- Data Import Wizard: the speed of loading of Excel files was significantly increased.
- Foreign key editor: now only InnoDB tables are displayed in the foreign table list. Table engine is also now checked for the Relation tool in the Database Designer.
Full press-release is available at SQL Maestro Group website.