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

Subscribe to our news:
Partners
Testimonials
Scott McWilliams: "I would just like to thank you for making this fantastic tool available for free. I use it all the time for both my professional and personal projects".
Steve Horne: "All in all it's a great product, I used the freeware version for a while but purchased a commercial license recently as I am now using it for my work. The ability to query SharePoint lists using SQL makes my administration tasks much easier".

More

Add your opinion

SQL Maestro Group / Products / AnySQL / News / AnySQL Maestro 10.7 released

AnySQL Maestro 10.7 released

Jul 6, 2010

Prev Next

SQL Maestro Group is happy to announce the release of AnySQL Maestro 10.7, a universal powerful solution for administering any database engine (SQL Server, Oracle, MySQL, MS Access, etc.) that is accessible via ODBC driver or OLE DB provider.

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

Database profile management extensions:

  • Starting with this version it is possible to reorder database groups in the Explorer Tree as well as reorder databases from the same group. You can also sort database groups and databases in an alphabetical order.
  • Now all the database profiles related to the same group 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.

Interface improvements:

  • This release has been successfully tested with 64-bit operating systems including Windows 7 x64.
  • Table Editor: a possibility of importing data from Clipboard has been implemented. It is supposed that columns within the data block are separated by the tabulation symbol, records are separated by newlines and the first line of the data block contains column headers.

    Listing 1. Data packet example
    ColHeader1  ColHeader2
    R1C1        R1C2
    R2C1        R2C2

    The same data format is supported by a lot of other applications, so it is easy to use this feature to quickly copy data from MS Excel, another table or view, or even from a data set from a different DBMS especially if it is opened with an appropriate our product.

  • The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved.

    Script RunnerPicture 1. Script Runner

  • Data Analysis tool features the following things:
    • Starting with this version it is possible to use a wide spectrum of aggregate functions such as maximum, minimum, average value, etc. for subtotals (the only available function for the previous versions was sum of values).
    • A possibility of sorting data by summary columns has been added. This means, for example, the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales.
    • You can also specify the number of top rows that are displayed to view, for example, only a specific number of best-selling or worst-selling products for each year, month, customer, etc. This will help you to concentrate on only the most important information and avoid being overload with a lot of superfluous data.
  • The Update Existing Records option has been added to the Data Import wizard. If this option is turned ON, the records will be either updated or inserted (Firebird 2.1+, MySQL, SQLite).

    Updating existing recordsPicture 2. Data Import: updating existing records

  • Data Grid features the following things:
    • The Clone current record command has been added to the popup menu. Use it to add a new record which is substantially similar to an existing one.
    • Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced sort command from the grid's header popup menu.

      Multi-column sortingPicture 3. Data Grid: multiple column sorting

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

      Number of grouped recordsPicture 4. Data Grid: number of grouped records

  • 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.

    Code completionPicture 5. SQL Editor: code completion

  • BLOB editor: starting with this version it is possible to select a BLOB column to edit directly within the editor window.

    Switching between BLOB columns in BLOB editorPicture 6. BLOB Editor: Switching between BLOB columns

  • The Case Insensitive option has been added to data grid filter settings (ON by default).
  • BLOB Viewer/Editor: starting with this version it's possible to customize PHP syntax highlighting for the text representation of BLOBs.
  • 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:

AnySQL Maestro home page
Download AnySQL Maestro
AnySQL Maestro Screenshots
Prev Next