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".
Carl Schammel: "I have been in search of a software product that was rich in features and easy for using, but was unable to find one until I came upon Firebird Maestro. Not only does it have all-inclusive integrated functionality, but SQL Maestro Group have provided me with superior support. I now have the management tools at my hand that I have been looking for".

More

Add your opinion

SQL Maestro Group / News / All company news / MS SQL Maestro 9.4 released

MS SQL Maestro 9.4 released

Apr 24, 2009

Prev Next

 
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.

    Table Editor

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.

    Trigger Editor


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

    Editor

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

    Editor

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


Related links:

MS SQL Maestro home page
Download MS SQL Maestro
Purchase your license of MS SQL Maestro today!
Prev Next