EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

All News & Events

SQL Manager for Oracle version 2.2 released

We are pleased to announce the new minor version of SQL Manager for Oracle - a high performance tool for Oracle database server administration and development.

You can download the newest version from the download page.

What's new in SQL Manager 2008 for Oracle 2.2?

  1. Added Create Database Wizard with the ability to create a Standby database.
  2. DDL. Unicode support is implemented.
  3. Using macro is now possible in SQL Editor and SQL Script.
  4. Added the possibility to connect to databases absent in TNS file.
  5. Query Builder. Added the ‘ANSI join’ option that allows users to create queries in ANSI-92 SQL standard.
  6. DB Explorer.
    • The Find Object dialog is improved.
    • The possibility to reorder database groups by drag-and-drop is implemented.
    • The button for switching the search mode is added to the toolbar.
    • Double-clicking the object group folds or unfolds it.
    • The program saves the information about the last opened database before shutdown. When it is started next time, this database will be automatically selected in the DB Explorer tree.
  7. Database Registration Info dialog. Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
  8. SQL Editor.
    • Creation of queries with identical names was allowed. Fixed now.
    • Fixed several errors concerning SQL code highlighting (alias usage in queries such as ‘UPDATE : SET :’; when using multiline comments, etc.).
    • When saving data to file using any charset different from Unicode, further opening of the save dialogue would set the charset to Unicode. Fixed now.
  9. SQL Editor -> Explain query. The scrollbar was absent. Fixed now.
  10. Data Grid.
    • The mouse cursor color changes when the grid is not active.
    • The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program. 
  11. Data Grid. Data | Blob View. Added the XML tab allowing you to view BLOB field values as XML.
  12. Extract Database/ Export as SQL Script.
    • Now the script is directly generated in the selected charset which reduces the script generation time. 
    • Extracting external cursor data resulted in the ORA-00900 error. Fixed now. 
  13. Extract Database/ Export. The ORA-00900 error occurred when extracting queries with a subquery block. Fixed now.
  14. Visual Database Designer.
    • Tables are arranged more compactly in the reverse engineering mode. 
    • Alignment options didn’t work if a diagram was opened from the file. Fixed now.
    • Some printers couldn't print field and table icons. Fixed now. 
  15. Window List. The ‘Close All Database Windows’ command is implemented.
  16. Dependency Tree. Pressing the Cancel button gave no result. Fixed now.
  17. Other small improvements and bug-fixes.

We hope you’ll enjoy working with our products!