What's new in MaxDB Maestro 14.9.0.1
Sep 4, 2014
- Server management extensions:
- Support for SAP MaxDB server versions up to 7.8
- You can now use any ODBC driver to connect to a MaxDB database
- New tools:
- Report Designer
- Nullable Column Checker
- Interface improvements:
- Data Grid with support for displaying images, Data Input Form, multi-column lookup editors, 'gold key' and 'silver key' images for marking headers, Clone current record function, Case Insensitive option, reset all grid settings to defaults option.
- Table Editor, with possibility of importing data from Clipboard and ability to upload files as BLOBs into a table.
- Data Analysis, with the possibility to use a wide spectrum of aggregate functions, possibility of sorting data by summary columns, specification of the number of top rows that are displayed to view.
- The SQL editor, with text change markers, updated code folding appearance, Drag-n-drop from Windows Explorer function.
- Script Runner, with invoking directly from the Tools menu, the name of the database on display at the top of the window, the possibility of executing archived scripts directly from .zip files.
- SQL Editor features marking the result tab with an image, the possibility of copying the selected text from any editor to Clipboard as a ready-to-use string in programming language.
- Data management tools updates:
- Get SQL Dump wizard has been significantly updated.
- Data Import features the possibility to import data from CSV files, the possibility of setting the correspondence between source and target columns by column name, the possibility to import data from several files at a time.
- Data Export features support for Json files, the possibility to specify decimal and thousand separators for the generated files.
- Other new features:
- The progress windows are redesigned in the modern style and become more informative.
- Visual Query Builder: the Create view from SQL link has been added to the Navigation panel. This feature allows you to create a view based on a SELECT query prepared within the builder as quickly as possible.
- A Spanish translation is now included into the installation package. Other available languages are English, German, French and Italian.
- The Start Page has been redesigned in order to provide quick access to recently connected database profiles and display the latest company news.
- Starting with this version the warning appears on creating a table without a primary key.
- Database Explorer: now it is possible to assign a custom color to a certain database profile. For example, you can mark development and production databases in different colors in order to prevent casual metadata or data changes in the production. The desired color can be selected at the Options tab in the Edit Database Profile dialog.
- Hints for foreign key columns now include the name of the parent table. Hints for domains contain the information about the underlying data type of the domain.
New in MaxDB Maestro 10.2.0.1 (Mar 3, 2010)
- Data management tools updates:
- Data Export wizard has been significantly improved:
- Now you can select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, 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 increase the usability. In particular, the export process now can be started at any step of the wizard.
- Data Import wizard has been significantly 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 wizard has been completely redesigned to improve the look and feel and increase the usability.
- Other new features:
- 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.
- 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).
New in MaxDB Maestro 8.7.0.1 (Jul 21, 2008)
- 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:
- 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.
- 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.
- 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.
- 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).
- 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.
New in MaxDB Maestro 7.10 (Nov 11, 2007)
- This version introduces unicode support, SQL Formatter, improved Database Designer and SQL Editors.
New in MaxDB Maestro 7.3.0.1 (Mar 21, 2007)
- Handy tools of Designer allow you to create new and edit existing tables and references;
- The reverse engineering feature will help you to understand the schema structure and make its modification in an easy and clear way;
- Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
- A rich set of options and settings give you a way to see your database in your own look and feel style.
- 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.