SQL Maestro Group / Products / Oracle / Oracle Maestro / Documentation

Download Buy

Oracle Maestro online help

Return to chapter overview

What's new

21/03/2008 - Oracle Maestro 8.3 released

Server management extensions:

•	Support for Oracle 8i has been added. Also this version has been successfully tested with Oracle 11g.

•	The Quick Connect mode has been implemented. Use it to skip metadata refreshing when connecting to a database (for example, to execute a query or SQL script).

•	Database triggers are moved from the database tree branch to schema one.

Interface improvements:

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

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

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

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

•	Create Profiles Wizard and object creation wizards become resizable.

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

•	The F11 key is now used to show/hide the Explorer tree.

•	Data grid options: it is now possible to restrict maximum column width.

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

•	Create Database Profiles wizard: the Hide already registered databases option has been added.

•	Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list.

Important fixes:

•	Directories are now refreshed much faster.

•	Get SQL Dump wizard: data from CLOB and BLOB columns are now extracted correctly.

•	Database triggers: support for the Server error event has been added.

10/2/2007 - Oracle Maestro 7.10 released

Server management extensions:

•	Now it is possible to cancel a long-running query execution and/or data fetching.

•	SQL Script Editor: DBMS_OUTPUT lines are now captured in the message window.

•	Support of the Oracle Gather Statistics feature is implemented. You can run it for the current database from the Tools menu or for selected table/schema in the Explorer tree. It is possible to execute the result script immediately, copy it to SQL Script Editor, or create a job.

•	Session Browser: now Oracle Maestro displays long-running operations for each session (V$SESSION_LONGOPS system view is used).

•	The export (backup) command now can be launched for the selected table, schema or tablespace (Explorer tree, Object Browser, Table/Schema/Tablespace editor, etc).

Interface improvements:

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

•	It is now possible to execute SQL scripts after connect and before disconnect to/from a database.

•	Database Designer: 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.

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

Important fixes:

•	Procedure Editor: routines with output prameters are now executed correctly.

•	Create Table Wizard: the proper script is now generated for fields with default value and not null constraint simultaneously.

•	Tablespace Editor: fixed a bug with altering Readonly and Online properties.

•	Triggers and table with triggers are now duplicated correctly.

5/7/2007 - Oracle Maestro 7.5 released

Server management extensions:

•

Session Browser is implemented. 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 session (such as login, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc.
To access the Session Browser window, select the corresponding item from the Tools menu.

•

Another important thing implemented in this version of Oracle Maestro is the Database Export feature, which represents a GUI wrapper for standard EXP utility. This tool allows you to choose export mode (database, schemas, tablespaces or tables), select objects to export and specify a lot of additional options to get the database dump according to your needs. It is also possible to save all the settings as a batch file for future executing.
This window also can be invoked from the Tools menu. Please note that you should have installed the EXP utility to use this functionality.

•	Now Oracle Maestro uses the TRUNCATE statement for table emptying (instead of DELETE one).

•	Fixed the bug with importing data to CLOB fields.

Interface improvements:

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

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

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	A 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).

3/14/2007 - Oracle Maestro 7.3 released

Server management extensions:

•

One of the main version features is PL/SQL Debugger. It is a tool to debug PL/SQL code such as procedures and functions (both stand-alone and packaged) using traditional debugging features such as setting break points, viewing variable values, and examining the call stack. To debug a function/procedure/package, select the appropriate command from the object pop-up menu in the Explorer tree.

o	PL/SQL Debugger is very easy to use. No extra actions or conversions are needed and no limitations exist. Just execute the program unit in the debugger and step through your code. You can step into any program unit (Step into, Step over);

o	Breakpoints can be set or removed by simply clicking in the left margin of the debugger;

o	When an exception occurs, the PL/SQL Debugger will take you to the line that causes it and you are able to view variable values at the time of the exception. This can obviously be very helpful to find the cause of the exception;

o	You can determine the code path to the current point in the execution of your program by examining the call stack.

•	The Compile dependencies, Compile with debug info and Compile references with debug info commands are available now wherever you work with the object: Explorer tree, Object Editors, Object Browser, etc.

Interface improvements:

•

The new version also introduces 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 Oracle 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 Oracle 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/12/2006 - Oracle Maestro 6.12 released

Server management extensions:

•	Since this version you can see quotas and segments in the tablespace 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;

•	Oracle 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, Oracle 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 Oracle DDL). Also it is possible to find and replace a text fragment of a BLOB column data;

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

11/7/2006 - First public release of Oracle Maestro

Oracle Maestro is a powerful solution for Oracle server administration and development.

It allows you to create, edit, copy, extract and drop all the database objects such as tables, views, database functions, procedures, packages, sequences, synonyms, collections, jobs, users, 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 Oracle users and their privileges, and use a lot of other tools designed for the easiest and most efficient work with Oracle 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.11.

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 Oracle Maestro 6.11 features below:

•	support for Oracle server versions from 9.x to 10.x provided: users, views, triggers, functions, procedures, sequences, jobs, synonyms, packages, types, queues, and many more;

•	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 Oracle Maestro will make your Oracle database management and administration easy and efficient; data can be viewed either as tables or as summary cards; Object Manager and Object Explorer 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: Oracle 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 Oracle users and their privileges as easy as it can be, even if you are not a skilled Oracle 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 Oracle 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 Oracle 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. Oracle 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 Oracle Maestro, we hope that you will enjoy working with your Oracle server!

Return to chapter overview