Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
David Boccabella: "I have really!!!! enjoyed using SQL Maestro for MySQL over the past few months. It has become one of our major development tools for implementing intelligent into MySQL databases".
Kenneth Wagner: "SQL Maestro is a delight to use. It is easy to learn. Almost always intuitive and has a good help system. I would gladly recommend it to either a beginner or even an advanced user".

More

Add your opinion

SQL Maestro Group / News / All company news / SQL Maestro for MySQL 12.12 released

SQL Maestro for MySQL 12.12 released

Dec 20, 2012

Prev Next
SQL Maestro for MySQL

SQL Maestro Group is happy to announce the release of SQL Maestro for MySQL 12.12, a powerful Windows GUI solution for MySQL administration and database development.

Please consider the list of new features implemented in this version since the last official release:

Server management extensions:

  • This version has been successfully tested with all the recent MySQL versions up to 5.6.9 RC.
  • Get SQL Dump wizard has been significantly updated:
    • Now it is possible to rename output columns in the result SQL script. To set a new target column name, enter a value to the Target column in the grid at the first step of the wizard.
    • You can also change the order of output columns using the appropriate commands of the popup menu or Ctrl+Up and Ctrl+Down shortcuts.

      SQL Dump: target column orderPicture 1. SQL Dump: target column order

    • Starting with this version it is possible to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as PostgreSQL, SQL Server, Oracle, Firebird, or SQLite.

      SQL Dump: setting SQL syntaxPicture 2. SQL Dump: setting SQL syntax

Interface improvements:

  • This version comes with Report Designer, a simple-to-use and elegant tool to prepare data for reading, viewing, and printing in a polished look.

    Report DesignerPicture 3. Report Designer

    Use this tool to create database reports using drag-and-drop functionality and rich formatting options. To invoke the window, use the Main Menu | Tools | Report Designer menu item.
  • The Start Page has been redesigned in order to provide quick access to recently connected database profiles and display the latest company news.
  • SQL Editor features:
    • Now on executing several statements from a single editor tab (did you know about such a possibility?), the corresponding result tab is marked with an appropriate image.

      SQL Editor result tabs imagesPicture 4. SQL Editor result tabs images

    • Starting from this version you can copy the selected text from any editor to Clipboard as a ready-to-use string written in one of the following programming languages: C#, C++, Delphi (Object Pascal), and Java. This feature is accessible in the Export section of the editor area popup menu.

      SQL Editor: copy selected text as a string written in programming languagePicture 5. SQL Editor: copy selected text as a string written in programming language

  • Database Explorer: now it is possible to assign a custom color to a certain database profile. For example, you can mark development and production databases in different colors in order to prevent casual metadata or data changes in the production. The desired color can be selected at the Options tab in the Edit Database Profile dialog.

    Colored profilesPicture 6. Colored profiles in the explorer tree

  • Hints for foreign key columns now include the name of the parent table.

    Foreign key column hintPicture 7. Foreign key column hint

  • Script Runner allows now to execute archived scripts directly from .zip files. The tool unpacks zip archives to temporary files by itself for further executing.
  • Data Grid features:
    • Multi-column lookup editors become available. Such editors modify values of several columns in the record simultaneously in order to guarantee referential integrity.

      Multi-column lookup editorPicture 8. Multi-column lookup editor

    • Now the headers of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly as well as the headers of required columns are marked with a red asterisk. The existence of any column marked with a gold key in the dataset means that you can modify/delete the records of this dataset without risk of updating/deleting several records at a time.

      Key columns in the data gridPicture 9. Key columns in the data grid

  • Data Import features:
    • From now on it is possible to import data from CSV files that contain multi-line strings.
    • A possibility of setting the correspondence between source and target columns by column name has been implemented (previous versions allow you to set such a correspondence only by column index).

      Setting column correspondencePicture 10. Setting column correspondence

  • Data Export: now it is possible to specify decimal and thousand separators for the generated files (when applicable).
  • The progress windows are redesigned in the modern style and become more informative.

    Progress windowPicture 11. Progress window

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

Related links:

SQL Maestro for MySQL home page
Download SQL Maestro for MySQL
Get SQL Maestro for MySQL Tour
Purchase your license of SQL Maestro for MySQL today!
Prev Next