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

Subscribe to our news:
Partners
Testimonials
Bernhard Hartl: "Oracle Maestro works great - thank you for that really good product and the very good User Interface".
Laurits Sogaard Nielsen: "Oracle Maestro (and also MS SQL Maestro) are the perfect substitutes for TOAD and in some ways also much better products (they are much cheaper, and the support is fast and easy). I'm looking forward to getting much more experience with both products, that already now have proven themselves to be fantastic".

More

Add your opinion

SQL Maestro Group / Products / Oracle / News / Oracle Maestro 16.1 relased

Oracle Maestro 16.1 released

Jan 5, 2016

Prev Next
Oracle Maestro

SQL Maestro Group is happy to announce the release of Oracle Maestro 16.1, a powerful Windows GUI solution for Oracle 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 of the software has been successfully tested with Oracle Database 12c.
  • Database Explorer: now it's possible to hide rarely used objects from the Explorer tree to reduce it size and speed up the database schema refreshing. For example, if you never work with maintenance objects, you can disable the displaying of such objects as jobs, queues, queue tables and so on.

    Database explorer options: excluding rarely used objectsPicture 1. Database explorer options: excluding rarely used objects

  • Starting from this version a warning message appears on creating a table without a primary key constraint.

    Warning message on creating a table without a PKPicture 2. Warning message on creating a table without a PK

  • Nullable Column Checker has been implemented. This feature allows you to refactor your database schema by enforcing omitted NOT NULL constraints. It is useful, for example, if you have got a legacy schema with a lot of columns allowing NULL values and plenty of data. To invoke the wizard, use the appropriate link in the Generate SQL section of the table popup menu at the Explorer tree.

    Nullable Column CheckerPicture 3. Nullable Column Checker

Interface improvements:

  • Data Import features:
    • Starting with this version it's possible to import data from several files at a time. To import data from multiple files with the same structure, set the mask of the file names to the corresponding field. To see the list of matching files, use with the button on the right.

      Import data from multiple filesPicture 4. Import data from multiple files

    • The Column Builder for text files with fixed column width has been redesigned. Now to set the correspondence between table columns and areas of a text file, you can either input offset and width for each column directly into the controls, or define these values by clicking the left mouse button in the right area of the tool.

      Column BuilderPicture 5. Column Builder for text files with fixed column width

    • Now it's possible to add current timestamp to the log file name using the %ts:TIMESTAMP_FORMAT% string template. Examples of valid datetime formats are: 'YYYY-MM-DD', 'YYYY-MM-DD-HH24-MI', 'YYYY-MM-DD-HH24-MI-SS', and so on.
    • 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.
    • Starting from this version it is possible to import empty values as empty strings (while previous versions always imported such values as NULLs).
      Data Import: working with empty valuesPicture 6. Data Import: working with empty values
  • Data Export:
    • Support for Json file format has been implemented.

      Data Export to JSONPicture 7. Data Export to JSON

    • From now on it becomes possible to specify caption, width, and alignment for output columns (when applicable).
      Data Export: customizing output columnsPicture 8. Data Export: customizing output columns
      Also it becomes possible to add current timestamp to the output file name.
      Data Export: adding current timestamp to output file namePicture 9. Data Export: adding current timestamp to output file name
  • From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
    Custom SQL scripts settingsPicture 10. Custom SQL scripts settings
  • Support for Adobe Reader DC has been added to BLOB Editor. Also the editor window now saves its size and position between times it is opened (for each table).
    BLOB EditorPicture 11. BLOB Editor
  • Starting from this version it is possible to select a tab color for windows that belong to a certain database. This could help you to distinguish windows with the same caption but a different parent database (such as SQL Editor) with ease. The color can be specified at the Options tab in the Database Profile Properties dialog.
    Colored tabsPicture 12. Colored tabs
    For the same purpose tab hints now include the profile name.
    Tab hintsPicture 13. Tab hints
  • In Data Grids and Data Input Forms computed columns are marked by a green calculator.
    Generated columns in the Data GridsPicture 14. Generated columns in data grids
  • Support for a number of new encryption algorithms has been added to Data Grid. Now it is possible to encrypt the value of a text column, for example, by SHA512 or Haval224 algorithm with a couple of mouse clicks.
    Data encryptionPicture 15. Data encryption
  • Data Input Form: controls containing values of primary and foreign key columns are now marked with the 'gold key' and 'silver key' images accordingly. Controls containing values of required (NOT NULL) columns are marked with a red asterisk.
    Data Input Form: marking important controlsPicture 16. Data Input Form: marking important controls
  • Data Grid: To reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

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

Related links:

Oracle Maestro home page
Download Oracle Maestro
Get Oracle Maestro Tour
Purchase your license of Oracle Maestro today!
Prev Next