MS SQL Maestro 9.4 released

Apr 24, 2009

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

Server management extensions:

• SQL Editor: support for explicit transaction management has been implemented. Now you can execute queries either in autocommit mode (default behavior) 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 now can generate multi-row INSERT statements supported by SQL Server 2008.
  
  
• Field Editor: now it is possible to pick some predefined default values such as CURRENT_USER for VARCHAR columns or CURRENT_TIMESTAMP for DATETIME columns from the list instead of entering them manually.
  
  
• Starting with this version MS SQL Maestro determines if a table column is a foreign key for another table.
  
  

  

Interface improvements:

• Data Export wizard has been significantly improved:
  
  
  • Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, and 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 improve the look and feel and increase the usability. In particular, the export process now can be started at any step of the wizard.
    
    
• Data Import wizard has been 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 speed of the import process has been significantly increased.
    
    
  • The wizard has been completely redesigned to improve the look and feel and 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.
  
  
• Trigger Editor: the Code Completion feature becomes available for the INSERTED and DELETED keywords.
  
  

  

  
  
• SQL Editor: starting with this version MS SQL Maestro highlights the error line after executing an erroneous query.
  
  
• An Italian localization is now included into the installation package.
  
  
• Data grid: 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.
  
  

  

• Tabbed MDI interface: a popup menu has been added to each tab.
  
  

  

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