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

Subscribe to our news:
Partners
Testimonials
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".
Giuseppe Maxia: "We are constantly testing everything related to MySQL world and MySQL Maestro is, so far, the best tool we have tried".

More

Add your opinion

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

MS SQL Maestro 8.11 released

Nov 1, 2008

Prev Next

 
SQL Maestro Group is happy to announce the release of MS SQL Maestro 8.11, 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:

SQL Server 2008 management extensions:

  • Support for new SQL Server 2008 data types (Date, Time, Datetime2, DatetimeOffset) has been implemented.

  • Since this version MS SQL Maestro provides support for user-defined table types. You can use such a type to declare table-valued parameters for stored procedures or functions, or to declare table variables that you want to use in a batch or in the body of a stored procedure or function.

  • Support for both row and page compression for both tables and indexes has been added. This feature is available only in Enterprise and Developer editions of SQL Server 2008.

Other server management extensions:

  • Objects are now grouped by schemas for SQL Server versions 7.0 and 2000. The screenshots below display the difference.

    Current version (with schemas)
    Current version
    Previous versions (without schemas)
    Previous versions

  • Index editor: support for Allow row locks and Allow page locks options has been added (SQL Server 2005+).

Interface improvements:

  • Data grid features the following things:

    • Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the dropdown window.

    • A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode.

    • Filtering, grouping, and sorting features become available for ntext columns.

    • It is now possible to restrict maximum column width.

  • The Dependency tracker tool has been implemented (Main Menu | Tools | Dependency tracker). Use this tool to browse all-level dependencies of a schema object (table, view, function, etc).

  • A French localization is now included into the installation package.

  • This version of our software is fully compatible with large fonts (120 DPI).

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

  • Process Browser: the statements at the Last SQL tab are now formatted if possible.

  • Extract database wizard: common database properties and program info are now included into the result scripts.

  • SQL Editor: a popup menu has been added to each query tab. Using this menu you can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed.

  • Data import wizard: the interface for adding and editing of replacements has been slightly improved.

  • SQL Script Editor settings: the "Use script runner for large scripts" option has been added.

  • Create Database Wizard, Create Profiles Wizard, and object creation wizards become resizable.

  • Data Export, Data Import, and Get SQL Dump wizards now store their size and position.

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