MS SQL Maestro 8.11 released

Nov 1, 2008

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

  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:

Back to news archive