MaxDB Maestro 10.2 released

Feb 26, 2010

SQL Maestro Group is happy to announce the release of MaxDB Maestro 10.2, a powerful Windows GUI solution for MaxDB Server 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 SAP MaxDB database server v. 7.5, 7.6, and 7.7.

Database profile management extensions:

• Starting with this version it is possible to reorder servers in the Explorer Tree as well as reorder databases from the same server. You can also sort servers and databases in an alphabetical order.
• Now all the database profiles related to the same server may be deleted at once.
• The Rename Database Profile command has been added to the popup menu. Use this command to rename a profile without opening its editor.

Data management tools updates:

• Data Export wizard has been significantly improved:
  • Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, Mac).
  • Support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented.
  • The wizard has been completely redesigned to increase the usability. In particular, the export process now can be started at any step of the wizard.
• Data Import wizard has been significantly updated too:
  • Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats along with Microsoft Office Excel 97-2003, Microsoft Office Access, CSV, DBF, and Text files supported in the previous versions.
  • Starting with this version you can import Text and CSV data files stored in different encodings.
  • Now it is possible to empty the target table as well as execute custom SQL scripts before and after import.
  • The wizard has been completely redesigned to improve the look and feel and increase the usability.

Other new features:

• Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs.
• The Dependency tracker tool has been implemented (Main Menu | Tools | Dependency tracker). Use this tool to browse all-level dependencies of a schema object (table, view, function, etc).
• Data Grid features the following things:
  • Starting with this version it is possible to allow displaying row numbers in grids. Of course you can adjust the corresponding column to yours liking.

    Picture 1. Data Grid: row numbering

  • Filtering, grouping, and sorting features become available for LONG columns.
  • Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced sort command from the grid's header popup menu.

    Picture 2. Data Grid: multiple column sorting

  • Now you can fix grid columns to view them permanently when working with other grid data. To fix a column, choose the corresponding item from the grid's header popup menu.

    Picture 3. Data Grid: fixed columns

  • Starting with this version the number of grouped records is displayed for the group's header.

    Picture 4. Data Grid: number of grouped records

• All schema object (table, view, procedure, etc) editors: the tab captions are now displayed as object@schema instead of schema.object. This should increase the usability while working with a lot of objects in the same schema.

  Current version:   

  Previous version:    

• Trigger Editor: the Code Completion feature becomes available for the NEW and OLD keywords.

  Picture 5. Trigger Editor: Code Completion

• An Italian localization is now included into the installation package.
• Tabbed MDI interface: a popup menu has been added to each tab.

  Picture 6. Tabbed MDI: tab's popup menu

• SQL Editor: the Go to Line command has been added to the popup menu (Ctrl+G shortcut). Also field data types are now displayed in the Code completion window.

  Picture 7. SQL Editor: code completion

• BLOB Viewer: Unicode support has been added to the Non-BLOB data grid.

  Picture 8. BLOB Viewer: Non-BLOB data

• BLOB Viewer/Editor: starting with this version it's possible to customize PHP syntax highlighting for the text representation of BLOBs.
• Get SQL Dump: now you can specify the encoding on the generating dump to a file.
• Database Designer: a possibility to select objects with Ctrl has been implemented.

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

Related links:

Back to news archive