EMS SQL Manager for Oracle

Features Matrix

 Full versionLite version
New state-of-the-art graphical user interface
Office 11 and Windows XP visual schemes support
+
+
Well-described Wizard System
+
+
User-friendly database explorer for easy management of all Oracle objects
+
+
Windows Toolbar to switch between windows easily, like in Windows Task Bar
+
+
Navigation bars with hot actions in most of the windows
+
+
Ability to save all program settings
+
+
Customizable toolbars for all program windows
+
+
Fully customizable program interface
+
+
Powerful visual options module
+
+
Localizable program interface
+
+
Easy management of all Oracle objects (including create/edit/ drop operations)
Managing tables and all their subobjects: fields, primary, unique and foreign keys, indices, triggers, and check constraints
+
+
Managing views and all their subobjects: fields, triggers, primary, unique and foreign keys
+
+
Managing procedures, functions, sequences, packages and package bodies
+
+
Managing users, roles, profiles, consumer groups and resource plans
+
+
Managing database and schema triggers, clusters, synonyms, database links, materialized views and materialized view logs
+
+
Managing object and array types, object type bodies, libraries
+
+
Managing java sources, resources and classes
+
+
Managing index types, operators, dimensions
+
+
Managing contexts, directories, table spaces, rollback segments, redo log groups
+
+
Managing jobs
+
–
Duplicating database objects
+
+
Viewing dependencies between database objects
+
+
Rapid database management and navigation
Multiple host/database connections
+
+
Connecting via local port forwarding through the SSH tunnel
+
–
Registering selected databases to work with
+
+
Schema restriction to see only required schemas
+
+
Projects to work with the selected database objects only
+
+
Multiple user-defined tabs for any tree node to access it in one-click
+
+
Working with multiple selected objects at a time
+
+
Grouping/Ungrouping registered databases
+
+
Advanced data manipulation tools
Powerful BLOB viewer/editor with several types of viewing BLOB data
+
–
Exporting data to SQL script as INSERT statement
+
–
Plenty of useful tools such as data grouping, fast search and filtering
+
+
Multi-level master-detail view to work with several linked tables at the same time
+
–
Table and card views to see data the way you like
+
–
Ability to copy and paste selected records
+
–
Effective security management
Grant manager displaying all database object grants in the form of a grid
+
+
Ability to set permissions for table columns
+
+
Easy management of database users, roles and profiles
+
+
Excellent visual and text tools for query building
Multiple SQL editors with code completion and syntax highlight
+
+
Visual query builder allows you to build complicated queries without any knowledge of SQL syntax
+
–
Large script execution (SQL script editor)
+
+
Ability to view query plan as diagram
+
–
SQL Formatter (Available from SQL Editor context menu)
+
–
Impressive data export and import capabilities
Exporting data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.
+
–
Exporting data to MS Access
+
–
Importing data from MS Excel, DBF, TXT and CSV
+
–
Importing data from MS Access
+
–
Report designer with clear in use report construction wizard
Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree
+
–
Create Report Wizard allows you to create simple reports in a few clicks
+
–
Latest Oracle version support
Support of all server versions from 8.1.7 to 10g R2
+
+
Support of all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types
+
+
Powerful and easy management of object permissions, including column-level permissions
+
+
Powerful visual database designer
Saving as image or printing database diagram
+
–
Ability to create/edit/drop tables and table fields, visually set links between them
+
–
Reverse engineering
+
–
And other useful features
Keyboard templates
+
+
External tool manager
+
+
To-do list
+
+
Other useful tools to make your work with Oracle server as easy as it can be
Extracting metadata into text files or SQL script editor
+
+
Powerful print metadata module to create customizable metadata reports
+
–
Report designer for building powerful reports visually
+
–
SQL Monitor
+
+
HTML report wizard to create a detailed HTML report about your database quickly
+
–

Products Navigation

SQL Manager for Oracle

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter