| 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 Foreign Key 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" |
|
| 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 |
|
| 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. |
