| Toad for Data Analysts Comparison Chart |
| |
Freeware |
Trial |
| Data Sources |
| Connect to nearly any ODBC data source (see Release Notes) |
X |
X |
| Connect natively to Oracle, SQL Server, DB2, MySQL, Sybase |
|
X |
| Understand |
| Database Explorer for object browsing and navigation |
X |
X |
| ER Diagrammer |
|
X |
| Query |
| Query Builder |
X |
X |
| Reverse engineer SQL into a Query Builder model |
X |
X |
| SQL Editor |
X |
X |
| Editing capabilities: snippets, Intellisense, syntax highlight, code folding |
X |
X |
| Visual SQL explain plan |
|
X |
| SQL Recall (SQL History) |
|
X |
| Sharing common standards and templates |
X |
X |
| Customizable code formatting |
|
X |
| Convert embedded SQL to other programming environments languages (Delphi, C, C++, Java, Pearl and visual basic etc.) |
|
X |
| Report |
| Generate customizable database reports in PDF, HTML format |
|
X |
| Charts & pivot table reports |
|
X |
| Save to Microsoft Excel for reporting |
X |
X |
| Automate |
| Graphical automation engine for scripts, imports/exports and more |
|
X |
| Automate report generation and distribution |
|
X |
| Import & Export |
| Export data into Microsoft Excel formats (CSV, text, XLS, fixed width) |
X |
X |
| Export data into non-Microsoft Excel sources (XML data, HTML, SQL Inserts) |
|
X |
| One-Click Export to Microsoft Excel |
|
X |
| Import data from Microsoft Excel, CSV, Text and other sources |
|
X |
| Save and execute Import & Export templates |
|
X |
| Data Compare & Sync |
| Data Compare and Sync wizard |
|
X |
| Synchronize data across database platforms |
|
X |
| Other Tools |
| Manage project files and resources |
X |
X |
| Display table data representing Parent-Child dependencies (Master Detail Browser) |
|
X |
| Reverse engineer object DDL |
|
X |
| General |
| Read-only mode |
|
X |
| Restrict access to Toad features (Toad Security) |
|
X |
| Macro/action record and playback to share, schedule and automate tasks |
|
X |
| Integrates with version control systems |
|
X |
| 5-user limit within an organization |
X |
|
| 120-day expiration |
X |
|
