| Full version | Lite 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 packages | + | + | ||
| Managing global variables | + | + | ||
| 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: simple text, RTF text, sequence of hexadecimal values, image, HTML page, XML document | + | – | ||
| 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 | + | + | ||
| Support of LBAC (Label Based Access Control) | + | + | ||
| Possibility to work with private contexts, security policies, audit policies and roles | + | + | ||
| 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 | ||||
| Backing up and restoring database | + | + | ||
| Rollforward of database | + | + | ||
| Stopping, starting database manager | + | + | ||
| Restarting database | + | – | ||
| Quiescing and unquiescing database | + | + | ||
| Reorganizing database tables and indexes | + | + | ||
| Running database statistics | + | + | ||
| Support of DB2 server tools: IMPORT, EXPORT, MOVE, LOAD | + | – | ||
| 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 DB2 server versions from 8.1 to 9.5 | + | + | ||
| 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 | + | + | ||
| Active database connections Monitor | + | – | ||
| ...and other useful features | ||||
| Keyboard templates | + | + | ||
| External Tools editor | + | + | ||
| To-do list | + | + | ||
