EMS SQL Manager for DB2

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 DB2 objects
+
+
Windows Toolbar to switch between windows easily, like in Windows Task Bar
+
+
Navigation bars and hot keys 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 DB2 objects (including create / edit / drop operations)
Managing database schemas
+
+
Managing tables and all their subobjects: fields, primary, unique and foreign keys, indexes, triggers, and check constraints
+
+
Managing views and all their subobjects: fields and triggers
+
+
Managing materialized query tables
+
+
Managing procedures, functions, sequences and packages
+
+
Managing user-defined types and structure types
+
+
Managing nicknames and aliases
+
+
Managing users, groups and user mappings
+
+
Managing tablespaces, buffer pools and partition groups
+
+
Managing event monitors
+
+
Managing servers and wrappers
+
+
Duplicating database objects
+
+
Viewing dependencies between database objects
+
+
Rapid database management and navigation
Multiple database connections
+
+
Registering selected databases to work with
+
+
Projects to work with the selected database objects only
+
+
Multiple user-defined tabs for any tree object to access it in one-click
+
+
Working with multiple selected objects at a time
+
+
Grouping / Ungrouping registered databases by node name
+
+
Advanced data manipulation tools
Unicode support
+
+
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
+
–
Ability to continue working with SQL Manager while data are being fetched from the DB2 server
+
+
A fetching process taking too long to execute can be aborted
+
+
Effective security management
Grant manager displaying all database object grants in the form of a grid
+
+
Easy management of database users, groups and user mappings
+
+
Excellent visual and text tools for query building
Multiple SQL Editors of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features
+
+
Visual query builder allows you to build complicated queries without any knowledge of SQL syntax
+
–
Large script execution (SQL script editor) with UNICODE support
+
+
Ability to view query plan as diagram
+
–
SQL Formatter (available from SQL Editor context menu)
+
–
Favorite Queries (save and use your frequently used queries easily)
+
–
Ability to continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder
+
+
A query taking too long to execute in SQL Editor or Query Builder can be aborted
+
+
Impressive data export and import capabilities
Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF, etc.
+
–
Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
+
–
Background mode execution makes it possible to continue working with SQL Manager while an import or export process is being performed
+
–
Report designer with a 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
+
–
Easy-to-use wizards for running DB2 services
Back up and restore database
+
+
Rollforward database
+
+
Stop, start and restart database
+
+
Quiesce and unquiesce database
+
+
Reorganize database tables and indexes
+
+
Run database statistics
+
+
Background mode execution makes it possible to continue working with SQL Manager while any of DB2 services is being performed
+
+
Most of DB2 server versions support
Support of 8.1 and 8.2 DB2 server versions
+
+
Support of most DB2 server platforms (LUW, z/OS, etc.)
+
+
Powerful Visual Database Designer
Two diagram notations (IDEF1x and IE)
+
–
Useful diagram navigation tool
+
–
Reverse engineering
+
–
Several pages in one diagram to divide the diagram into different subject areas
+
–
Ability to create/edit/drop database objects, visually set links between them
+
–
Virtual objects such as comments and virtual relationship
+
–
Saving as image or printing database diagram
+
–
A lot of visual personalization options
+
–
Other useful tools to make your work with DB2 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 of your database quickly
+
–
Dependency tree tool allows to view dependencies between database objects
+
+
...and other useful features
Keyboard templates
+
+
External Tools editor
+
+
To-do list
+
+

Products Navigation

SQL Manager for DB2

Our Partnership Status

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