ASA Maestro 9.1 released

Jan 15, 2009

SQL Maestro Group is happy to announce the release of ASA Maestro 9.1, a powerful Windows GUI solution for Sybase SQL Anywhere administration and database development. Please consider the list of new features implemented in this version since the last official release:

• Support for the SQL Anywhere remote data access feature has been implemented. With remote data access you can access data in other relational databases such as Sybase, Oracle, and DB2, access desktop data such as Excel spreadsheets, MS-Access databases, FoxPro, and text files, perform joins between local and remote data, and so on.
  
  To access remote data, you need:
  
  
  • Define a remote server where the remote object is located.
    
    
  • Create an external login for the remote server from the previous step.
    
    
  • Create a local proxy table that maps to the remote object.
    
    
  
  That's all. Now you can operate with remote data as if they were stored in the database to which ASA Maestro is connected.
  
  
• SQL Editor: starting with this version you can execute queries either in autocommit mode (default value) or manage transactions manually. In the second case you have to issue the BEGIN TRANSACTION statement to start a transaction and explicitly end the transaction by COMMIT or ROLLBACK statements (it is also possible to use the corresponding links at the editor's navigation bar).
  
  
• Get SQL Dump Wizard has been redesigned to increase the usability.
  
  

• 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 table or view.
  
  
• Tabbed MDI interface: a popup menu has been added to each tab.
  
  

  

  
  
• An Italian localization is now included into the installation package.
  
  
• 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.
    
    

    

  • Filtering, grouping, and sorting features become available for LONG VARCHAR columns.
    
    
  • The contents of string columns can now be encrypted using the md5 algorithm.
    
    
• 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:

  
  
• Database Explorer: the Data management group has been added to table and view nodes popup menus. Use this group items to run Data Export, Data Import, and Get SQL Dump wizards for the selected table or view without opening its editor (the Empty Table command has been moved to this group too). The Go to foreign table command is now available for all the foreign keys.
  
  
• Database Designer settings: the Show hints option has been added. Also it is now possible to select the default graphic file format to export diagrams as images.
  
  

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