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

Subscribe to our news:
Partners
Testimonials
Frank Thomas: "The import function from Excel is brilliant! I was able to port a database from a foreign source into Excel and then import it directly into MySQL with your program".
Charles Richardson: "In particular, the graphical schema design module is wonderfully smooth and responsive".

More

Add your opinion

SQL Maestro Group / News / AnySQL Maestro 11.7 released

AnySQL Maestro 11.7 released

Jul 11, 2011

Prev Next

SQL Maestro Group is happy to announce the release of AnySQL Maestro 11.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 the last official release:

DBMS-related features:

  • This version has been successfully tested with the most modern database servers including PostgreSQL 9.0, Firebird 2.5, MySQL 5.5 and 5.6, Oracle 11G, DB2 9.7, SQLite 3.7.x and MS SQL Server 2008 R2.
  • The ability of using the data pagination has been implemented for the Data tab of object editors. This feature significantly speeds up data management because of retrieving only a specified number of records.

    Data PaginationPicture 1. Data Pagination

    The default value (1000 records per page) can be customized in the Application Options dialog.

Interface improvements:

  • Now the application allows you to use Code snippets, segments of reusable code that you can copy into the editor. The feature is available from SQL Editor, SQL Script Editor, and editors of objects containing SQL bodies (such as views, triggers, etc.) with the corresponding item of the popup menu or with Ctrl+J shortcut.

    Working with code snippetsPicture 2. Working with code snippets

  • Table Editor: Another way of index creating has been implemented. Now you can create a new index directly from the Fields tab of the table editor. To add an index, select column(s) the new index to consist of and use the Create index on columns... command.

    Creating a new indexPicture 3. Creating a new index

  • Data Import: starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. Let's look through some details of the new feature:
    • To import data in this way, you have to specify a connection string and select appropriate identifier quote characters to escape improper symbols and blanks in object names according to the source database (for example, double quotes for Oracle and PostgreSQL, backticks for MySQL, or square brackets for SQL Server and MS Access).

      Connecting to ODBC data sourcePicture 4. Data Import: connecting to an ODBC data source

    • Another thing to note is that this kind of import completely supports BLOBs (if they are supported by the ODBC driver / OLE DB provider used).
    • Now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.
  • The Execute at cursor command has been added to SQL Editor (available in the Navigation bar or with Ctrl+F9 shortcut). Use this command to execute statements the cursor is over without selecting them.
  • Database Designer: now you can view all columns included in a foreign key by selecting the relation based on the foreign key.

    DB diagram: foreign key columnsPicture 6. DB diagram: highlighting of columns included in the selected foreign key

  • Application Options: now it's possible to specify default directories for data export/import/extract/etc to be used on database profiles creating.
  • Table Editor Options: starting with this version it's possible to allow the application to open details at the Data tab automatically.

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