Product Feature Matrix

This is quite an expansive matrix. While dbOrchestra is easy to use it offers a rich and exhaustive set of features.

Features/Functions
Connection
Industry Standard JDBC
Application Can Connect to Multiple Remote/Local Databases
Data Object Browser
One Click Access to Multiple Remote and/or Local Databases
Create User Defined Tab to Connect to Database
Saves Session Context Automatically
Automatically Connects to Last Used Database at Startup
Six Custom Application "Look and Feel" to Select
Easy Access to Database Objects
Tables
SQL Scripts
Views
Stored Procedures
Foreign Key Constraints
Functions
User Defined Types
System Tables
Build Data Driven SQL Code by Template
Data Object Browser Functions/Features
Auto build SQL Select (single table or complex join)
Auto Build SQL Insert
Auto Build SQL Update
Auto Build SQL Delete
Auto Build SQL Cursor
View Table Schema
Customize Database Connection Tabs
Launch Table Data Editor	Except Community Edition
Launch Index Builder	Except Community Edition
Launch ForeignKey Constraint Builder	Except Community Edition
Create User Defined Directories for SQL Code/Templates
SQL Code Example Bundle Provided
Object Search
Single Click Object to View Code
Single Click Code to Execute
Schema Management	Except Community Edition
Table Schema Editor	Except Community Edition
Easy to Use Point-and-Click Interface
Drop Column
Modify Column
Rename Column
New Column
Modify PKey
Drop Check, New Check
Drop Default, New Default
Schema Difference Manager	Except Community Edition
Report Schema Differences Between Source and Target Database by Object
Report Schema Differences Between Source and Target Database by Entire Database
Schema Extractor	Except Community Edition
All Objects
Table
Foreign Key
Index
Views
Stored Procedures
Rules
Triggers
Functions
Offers Numerous Output Options
Index Builder	Except Community Edition
Easy to Use Point and Click Interface
Build Direct
Generate Script
Foreign Key Builder	Except Community Edition
Easy to Use Point and Click Interface
Build Direct
Generate Script
Schema Migration	Except Community Edition
Generate Schema Migration Scripts to "Sync Up" Source and Target Systems
Scripts Can be Run in Part of in Whole Within the DB Builder
Misc
Modify Primary Key
Modify Foreign Key
Enable/Disable Foreign Key
Check/Report Foreign Key Violations
Data Management
Table Data Editor	Except Community Edition
Easy to Use Point and Click Interface
Directly Update a Row
Directly Insert New Row Using Existing Row as a Template
Directly Delete Single or Multiple Rows
Build Scripts for Insert, Update, Delete
Easily Filter Rows
SQL Editor
Write/Exec SQL code
Directly Execute and View Results Within Editor
Save Work to File
Execute Script and Save Results Directly to Excel
Can Have Multiple Editors Running
Works with the "Database Object Browser" Allowing You to Let dbOrchestra Initially Create Code
Works in Concert with dbOrchestra "File Manager"	Except Community Edition
Works in Concert with dbOrchestra "Table Manager"	Except Community Edition
Show Execution Plan
Selectable Code Formatting Preferences
Enable Line Numbers
Find, Search/Replace
Stop Query Execution
Execute Query Directly to "Table Editor"	Except Community Edition
Single Key Access to Schema From Query
Single Key Create Insert, Update, or Delete Script from a Select Statement
Table Manager	Except Community Edition
Manage Dependencies Parent-Child
Manage dependencies child-parent
Build queries using easy point and click interface
Object relationships (i.e, View to Table, etc...)
Execute query return selectable record set that can be further used to...
Generate Insert, Update, Delete scripts
Perform Direct Execution of Insert, Update, Delete
Perform Bulk Update (Search and Replace in Selected Rows)
Produce Results to Excel
Build Stored Procedures
Table Data Difference Manager	Except Community Edition
Report Data Differences Between Source and Target Database by Object
Report Data Differences Between Source and Target Database by Entire Database
Bulk Data Entry
Import Data From Directory by Bulk Insert
Import Data From File
Import Data From Excel
Import Data Using DB Builder
Database Management
Information
Cursors
Events
Indexes
Latches
Sessions
Tables
Users
Tablespaces
Object Browser by Date/Time
Object Counts
Object Dependencies by Type
Caches Tables
Disabled Foreign Keys
System Parameters
System Statistics
Last Update Statistics
Buffer Hit Ratio
Memory Usage
Show Compilation Errors
Show Invalid Objects
Activities
Build SQL by Template
Create Database
Drop Database
Backup Database
Missing Foreign Key Indexes Command
Outdated Statistics Command
Event 10046 Trace Command
Build Session Trace Command
Drop Invalid Objects Command
Missing Foreign Key Indexes Command
Recompile Invalid Objects
Drop Index
Delete Table
Truncate Table
Modify Primary/Foreign Key
Disable Primary/Foreign Key
Copy Table
Kill User Sessions
Performance	Except Community Edition
Show Query Execution Plan
Deadlock Detection and Testing
CRUD Stress Load Testing
Performance testing of Stored Procedures and Queries
Testing Index Efficiency
Thread Testing to Simulate System Utilization Conditions
Support
Documentation
On-line Documentation Within Application
Quick Start Guide
Cheat Sheets
FAQ's in Support Area at Website
Secure Internet Support Area
Education
Independent Study Modules
On-site Education	CALL
Communication
User Forums
Bug Fix Reporting
Email support	Except Community Edition
Phone Support	CALL
On-site	CALL
Product Updates	Free for 12 months of data of purchase.