|
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 |
|
|
Launch Index Builder |
|
|
Launch Foreign Key Constraint Builder |
|
|
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 |
|
|
Table Schema Editor |
|
|
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 |
|
|
Report Schema Differences Between Source
and Target Database by Object |
|
|
Report Schema Differences Between Source
and Target Database by Entire Database |
|
|
Schema Extractor |
|
|
All Objects |
|
|
Table |
|
|
Foreign Key |
|
|
Index |
|
|
Views |
|
|
Stored Procedures |
|
|
Rules |
|
|
Triggers |
|
|
Functions |
|
|
Offers Numerous Output Options |
|
|
Index Builder |
|
|
Easy to Use Point and Click Interface |
|
|
Build Direct |
|
|
Generate Script |
|
|
Foreign Key Builder |
|
|
Easy to Use Point and Click Interface |
|
|
Build Direct |
|
|
Generate Script |
|
|
Schema Migration |
|
|
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 |
|
|
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" |
|
|
Works in Concert with dbOrchestra "Table
Manager" |
|
|
Show Execution Plan |
|
|
Selectable Code Formatting Preferences |
|
|
Enable Line Numbers |
|
|
Find, Search/Replace |
|
|
Stop Query Execution |
|
|
Execute Query Directly to "Table Editor" |
|
|
Single Key Access to Schema From Query |
|
|
Single Key Create Insert, Update, or
Delete Script from a Select Statement |
|
|
Table Manager |
|
|
Manage Dependencies Darent-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 |
|
|
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 |
|
|
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 |
CALL |
|
Phone Support |
CALL |
|
On-site |
CALL |
|
Product Updates |
Free for 12 months of data of purchase. |
$199.95 30 Day Money Back Guarantee. 
Secure Payment Options