Full version	Lite version
New state-of-the-art graphical user interface
The possibility to choose different visual schemes
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		up to 5
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
Ping database		–
Most of DB2 server versions support
Support of DB2 LUW servers from 8.1 to 9.7
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		–
Working with projects. Ability to create databases even without connecting to the server
Creating projects - virtual set of locally stored database objects		–
Editing, adding and deleting project objects		–
Working with projects in Visual Database Designer (VDBD)		–
Creating scripts generated by comparing the project structure with the actual database		–
Fast publication of the project either to an existing or newly created database		–
Ability to duplicate project objects and to add actual databases objects to the project		–
Uploading and printing project metadata		–
Generating HTML reports of the project		–
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		–
Support of Team Development		–
Create Tag Wizard to remember the current database state		–
Check Repository Wizard reveals differences between a database and its description in the repository		–
Get Change Script Wizard allows you to get a script removing differences between two database states		–
History of changes made to a database or an object		–
CLP console
Database Comparer Wizard		–
...and other useful features
Keyboard templates
External Tools editor
To-do list