EMS SQL Manager for Oracle Freeware 2.2
POWERFUL GUI TOOL FOR ORACLE ADMINISTRATION.
EMS SQL Manager for Oracle is a high performance tool for Oracle Database Server administration and development. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to 10g and supports all Oracle objects and all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types, and others. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. SQL Manager for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.
Key Features:
- New state-of-the-art graphical user interface
- Connecting via local port forwarding through the SSH tunnel
- Easy management of all Oracle objects (including create/edit/ drop operations)
- Rapid database management and navigation
- Advanced data manipulation tools
- Effective security management
- Excellent visual and text tools for query building
- Impressive data export and import capabilities
- Report designer with clear in use report construction wizard
- Latest Oracle version support
- Powerful visual database designer
- And other useful features
- Other useful tools to make your work with Oracle server as easy as it can be
SQL Manager for Oracle Freeware released
We are pleased to announce the new version of SQL Manager for Oracle Freeware - a high performance tool for Oracle database server administration and development.
You can download EMS SQL Manager for Oracle Freeware from the following link:
What's new in SQL Manager 2008 for Oracle 2.2?
Added Create Database Wizard with the ability to create a Standby database.
DDL. Unicode support is implemented.
Using macro is now possible in SQL Editor and SQL Script.
Added the possibility to connect to databases absent in TNS file.
Query Builder. Added the 'ANSI join' option that allows users to create queries in ANSI-92 SQL standard.
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.
Database Registration Info dialog. Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
SQL Editor.
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.
SQL Editor -> Explain query. The scrollbar was absent. Fixed now.
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.
Data Grid. Data | Blob View. Added the XML tab allowing you to view BLOB field values as XML.
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.
Extract Database/ Export. The ORA-00900 error occurred when extracting queries with a subquery block. Fixed now.
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.
Window List. The 'Close All Database Windows' command is implemented.
Dependency Tree. Pressing the Cancel button gave no result. Fixed now.
Other small improvements and bug-fixes.
What is new in 2.2 software version? - - Support of Oracle 11g features
- Unicode support
- partitioning tables and indexes support
- PL/SQL Profiler
- Database Alerts
- wizards working in the background mode
- improved SQL Editor
- Favorite queries
and much more.... What is expected in the future? Newly-made EMS SQL Manager for Oracle Freeware 2.3 be downloaded from current page, we also looking forward to unconfirmed 2.4 release build. You may download oramanager_lite.zip directly, estimated download time by ADSL2+ [~24.5 Mbit/s] is 0:00:12. Just write the reviews of the EMS SQL Manager for Oracle Freeware. System requirements are 600Mhz; 128Mb RAM; 150MB HD; Connection to local or remote SQL Server; Oracle Database Client. Program has been scanned and verified by the several antivirus and anti-spyware applications and EMS SQL Manager for Oracle Freeware found to be clean. The following languages are supported by EMS SQL Manager for Oracle Freeware: English, Polish.









