Customers
MaxDB Maestro online Help
Prev  |
Return to chapter overview | Next  |
What's new
7/9/2008 - MaxDB Maestro 8.7 released
Server management extensions:
| • | None in this version. |
Interface improvements:
| • | A French localization is now included into the installation package. |
| • | The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc.) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor. |
| • | Data grid has been significantly updated: |
| o | 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 drop-down window. |
| o | A possibility of displaying master-detail data 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. |
| o | The Generate Query command has been added to the Table / View Editor. Use this command to copy current filter conditions to the SQL Editor window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu. |
| o | Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu). |
| o | A possibility to restrict maximum column width has been implemented. |
| • | 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 openning its editor. The Empty Table command has been moved to this group too. |
| • | 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. |
| • | SQL Script Editor: Script Explorer has been significantly improved. Now it works much faster and more exactly. |
| • | 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 import wizard: the interface for adding and editing of replacements has been slightly improved. |
| • | Database Designer settings: the "Show hints" options has been added. Also it is now possible to select the default graphic file format to export diagrams as images. |
| • | The F11 key is now used to show/hide the Explorer tree. |
| • | Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list. |
10/24/2007 - MaxDB Maestro 7.10 released
Server management extensions:
| • | None in this version. |
Interface improvements:
| • | Data Grid: Unicode data are now displayed correctly (for Unicode-enabled databases). To use the Unicode driver, turn on the corresponding option in the Create Database Profiles wizard or Edit Database Profile dialog window. |
| • | The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is fulfilled. It can be invoked with the aid of the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). |
| • | Database Designer has been improved. Following features have been added: |
| o | 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. |
| o | now you can drag a schema in the Explorer tree or Object Browser and drop it in the Designer window: all schema tables will be added to the current diagram. Also we have implemented the Note and Text tools to decorate the diagrams. |
| • | Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible: |
| o | 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; |
| o | convert selected text to different cases (lower, UPPER, and NameCase); |
| o | export the contents of the editor to RTF and HTML formats (to file or to clipboard); |
| o | 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; |
| • | Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool). |
| • | It is now possible to execute SQL scripts after connect and before disconnect to/from a database. |
| • | Now our software displays execution time for lengthy operations. |
| • | BLOB Viewer: it is now possible to save all BLOBs from a table to a given directory. |
| • | Data Import Wizard: the speed of loading of Excel files has been significantly increased. |
3/18/2007 - MaxDB Maestro 7.3 released
Server management extensions:
| • | full support of MaxDB 7.5 is implemented. Now our software supports both production releases of MaxDB database server (7.5 and 7.6); |
Interface improvements:
| • | The main feature of the new version is the Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your MaxDB databases. Each diagram displays the tables of your database and the relationships between them; |
| o | Handy tools of Designer allow you to create new and edit existing tables and references; |
| o | The reverse engineering feature will help you to understand the schema structure and make its modification in an easy and clear way; |
| o | Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc; |
| o | A rich set of options and settings give you a way to see your database in your own look and feel style. |
A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
| • | SQL Editor: now MaxDB Maestro can edit even very large SQL files. Also the speed of editor's work has been significantly improved; |
| • | SQL Editor: queries' tabs can now been displayed at the all sides of the editor (bottom, top, left or right); |
| • | The hint for foreign keys now contains such information as foreign table name and field correspondence. |
12/14/2006 - MaxDB Maestro 6.12 released
Server management extensions:
| • | Now MaxDB Maestro displays dependencies for tables and views (MaxDB 7.6.0.34+); |
| • | It is now possible to see the list of object synonyms in the corresponding editors; |
| • | The Make primary key and Clear primary key commands are now accessible anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc); |
Interface improvements:
| • | The tabbed interface is implemented in addition to classic MDI (see screenshot). You can choose your favorite UI in the Options dialog; |
| • | MaxDB Maestro now stores parameters history for procedure execution so you can choose a set of already used values instead of entering them manually; |
| • | SQL Script Editor: if a user opens a file larger than 100K, MaxDB Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename; |
| • | The Table Editor interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable; |
| • | BLOB viewer/editor: the text pane provides now several types of text highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and MaxDB DDL). Also it is possible to find and replace a text fragment of a BLOB column data; |
| • | It is now available to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation; |
| • | The Insert key is now a shortcut for creating a new database object from the Explorer tree; |
| • | Create Profiles Wizard: we've added an option for converting new object names to lower/upper case; |
| • | Data grid: the speed of data loading was significantly increased. |
10/28/2006 - First public release of MaxDB Maestro
MaxDB Maestro is a powerful solution for MaxDB server administration and development.
It allows you to create, edit, copy, extract and drop all the database objects such as tables, views, user-defined functions, procedures, domains, sequences, synonyms, etc., build queries visually, execute queries and SQL scripts, view and edit data including Blobs, represent data as diagrams, export and import data to/from most popular file formats, manage MaxDB users and their privileges, and use a lot of other tools designed for the easiest and most efficient work with MaxDB Server.
Our product release versions are formalized according to temporal principles: the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. Hence, the present version is 6.10.
While developing the new software product we tried to include the usable features available in the existing products and to provide it with unique functionality. Please consider the short list of MaxDB Maestro 6.10 features below:
| • | support for all MaxDB server versions from 7.6 and higher provided: schemas, views, triggers, functions, procedures, sequences, system triggers, and so on; |
| • | easy database management: the conception of database profiles gives you the opportunity to connect to databases in one touch and work with the selected databases only; |
| • | powerful database object management: the application includes a number of handy wizards and editors, database explorer allowing you to perform all necessary operations upon databases and their objects (creating new database objects, editing existing ones as well as duplicating and renaming objects); |
| • | user-friendly interface: easy-to-use GUI provided by MaxDB Maestro will make your MaxDB database management and administration easy and efficient; data can be viewed either as tables or as summary cards; |
| • | Object Manager and Object Browser allow you to fulfill complex data manipulation tasks irrespective of your personal level of competence in this or that server feature; |
| • | building and executing queries: MaxDB Maestro provides powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables and so on; |
| • | powerful security management: implemented a number of powerful editors, which allow you to manage MaxDB users and their privileges as easy as it can be, even if you are not a skilled MaxDB administrator; |
| • | powerful BLOB viewer/editor: opportunity to view and edit the content of the BLOB fields in various representations such as hexadecimal dump, plain text, graphical image or HTML page; graphical representation of BLOB data supports the following image formats: BMP, Windows metafile, JPEG, GIF and PNG; |
| • | data export module: exporting data from MaxDB Server tables and queries to files of the 14 most popular formats including MS Excel, MS Access, MS Word, HTML, XML, PDF; |
| • | data import module: importing data to MaxDB Server tables from files of the following formats: MS Excel, MS Access, XML, DBF, TXT and CSV. |
The list of useful features implemented in our software can be continued. MaxDB Maestro gives you opportunities to create a new database object in a couple of simple operations, to get SQL dump of your metadata and data (even without knowing the syntax), to get a high-quality printable report for your database, to execute any SQL script, to copy a table from one database to another by drag-n-drop operations or by pressing Ctrl+C/Ctrl+V hot key combinations and a lot of other features.
To summarize all the features available in MaxDB Maestro, we hope that you will enjoy working with your MaxDB server!
| Prev |
Return to chapter overview | Next |
