Firebird Maestro 7.7 released

Jul 10, 2007

SQL Maestro Group is happy to announce the release of a new version of Firebird Maestro, a powerful Windows GUI solution for Firebird administration and database development.

Please consider the list of new features implemented in Firebird Maestro 7.7 since last official release:

Server management extensions:

• The most important thing added in this version is support of Unicode/UTF-8 data.
  
  
• Since this version Firebird Maestro works fine with embedded Firebird server. The corresponding changes were added to Create Database wizard, Create Database Profiles wizard and Edit Database Profile window.
  
  
• Transaction Browser is implemented (Firebird 2.1). This feature is very useful for DBAs who want to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each transaction (such as user, connect time, database name, client host, last SQL statement executed and more) as well as group and filter transactions by client host, connected user, database, etc.
  To access the Transaction Browser window, select the corresponding item from the Tools menu.
  
  
• Support of database triggers from Firebird 2.1 is added to the software (see Firebird 2.1 release notes). You can create new database triggers and edit existing ones.
  
  

• Database Designer: a possibility of locking/unlocking diagram objects is added. This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.
  
  
• It is now possible to execute SQL scripts after connect and before disconnect to/from a database.
  
  
• Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible:
  
  
  • comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
    
    
  • convert selected text to different cases (lower, UPPER, and NameCase);
    
    
  • export the contents of the editor to RTF and HTML formats (to file or to clipboard);
    
    
  • print/preview the contents of the editor.
    
    
• The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;
  
  
• Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter);
  
  
• Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).
  
  

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

Related links:

Back to news archive