Feature
|
Pro
|
Lite
|
Pro versus Lite
|
|
|
Ability to register more than 3 servers
|
ü
|
|
Ability to register/use more than 5 databases per server
|
ü
|
|
Cross-Database Development
|
|
|
Ability to use multiple database systems
|
ü
|
|
Ability to connect to any ODBC or ADO data source
|
ü
|
|
Migrate meta data objects to the same and other database systems
|
ü
|
|
Migrate meta data objects from any ODBC or ADO data source
|
ü
|
|
Database development
|
|
|
Ability to view, create, modify and delete schema objects
|
ü
|
ü
|
Duplicate Object
|
ü
|
|
Create SUID Procedures
|
ü
|
|
View dependencies
|
ü
|
|
Search schema objects
|
ü
|
|
Run queries, scripts
|
ü
|
ü
|
Session Script Recorder
|
ü
|
|
Visual Query Builder
|
ü
|
ü
|
Edit and view data
|
ü
|
ü
|
Edit and view BLOB Data as images, OLE documents, text, HTML and Hex-data
|
ü
|
ü
|
Database design
|
|
|
Conceptual Data Model diagramming
|
ü
|
|
Physical Data Model diagramming
|
ü
|
|
Generate DBMS specific Physical Data Models from a Conceptual Data Model
|
ü
|
|
Reverse Engineer schemas to a diagram
|
ü
|
|
Testing
|
|
|
Test Data Generator
|
ü
|
|
Stored Procedure & Function Debugging1
|
ü
|
|
Trigger Debugging2
|
ü
|
|
Package Debugging3
|
ü
|
|
Data import, export and transfer
|
|
|
Export data to INSERT script and XML files
|
ü
|
ü
|
Export data to dBase, Text, Excel, CSV, Lotus 1-2-3 and DIF files
|
ü
|
|
Script INSERT statements from an ODBC data source
|
ü
|
|
Import data from CSV file
|
ü
|
|
DataPump tool
|
ü
|
|
Database administration
|
|
|
Perform database administrator tasks
|
ü
|
ü
|
Perform server administrator tasks
|
ü
|
ü
|
Monitor activity and performance
|
ü
|
|
Manager users, roles and groups
|
ü
|
ü
|
Grant Manager tool to manage SQL grants
|
ü
|
|
Printing
|
|
|
Print source code
|
ü
|
ü
|
Print table data or query result sets
|
ü
|
|
Print schema objects
|
ü
|
|
Productivity
|
|
|
Use object templates
|
ü
|
ü
|
Use code templates
|
ü
|
ü
|
SQL Insight
|
ü
|
ü
|
Multi-Level Clipboard
|
ü
|
|
Special Copy/Paste
|
ü
|
ü
|
Text File Compare Tool
|
ü
|
ü
|
SQL & Code Catalogs
|
ü
|
|