Toad® for IBM DB2® LUW		Home > Products > Toad® for IBM DB2® LUW > Features and Benefits		Print Page		Request a Quote		Email Page

Features and Benefits

Greater efficiency when performing daily tasks
Greater accuracy when writing, debugging and tuning code
Flexibility to perform many development and administration tasks from a single tool
A smooth workflow that allows users to move from one task to another easily
Extensive reporting capabilities that produce quantifiable data and documentation
Access to DB2 expertise through various Toad user communities

Features	Toad Standard	Toad Professional	Toad Xpert	Toad Database Administration
Browse/Edit data	X	X	X	X
Catalog Browser	X	X	X	X
Data Compare/Sync		X	X	X
Data Import/Export	X	X	X	X
Data Report Designer	X	X	X	X
ER Diagrammer	X	X	X	X
Knowledge Xpert		X	X	X
Master Detail (RI) Browser	X	X	X	X
Project Manager	X	X	X	X
Query Builder	X	X	X	X
Script Automation	X	X	X	X
SQL Editor	X	X	X	X
Stored Procedure Debugger		X	X	X
Version Control Integration	X	X	X	X
Web Browser	X	X	X	X
SQL Optimizer
Automatic SQL Rewrite			X
Index Analysis			X
Scans Source Code for Problematic SQL			X
Advanced Administration
Attach/Detach Table Partitions				X
Catalog Statistics Update				X
Compare and Synchronize (Schema Objects)				X
Display Active Applications with SQL Text				X
Drop Impact Analysis				X
Extended Alters				X
Object Migration				X
Partitioned Table Analysis				X
Space Calculator				X
Space Estimator				X
Space Exception Report				X
Statistics Migration				X
Space Usage Detail				X
Other
Citrix Support	X	X	X	X
Technical Support	X	X	X	X