| Features |
SQL IDE |
SQL IDE Pro |
| Database Back end Requirements |
| Utilizes Microsoft® SQL Server database |
|
X |
| Stand- alone application does not require Microsoft® SQL Server database |
X |
|
| Version Control |
| Integrates with Microsoft® Visual SourceSafe® and any SCC compliant version control system |
X |
X |
| Check out and check in, and add or remove objects from version control directly from within Speed SQL IDE |
X |
X |
| Uses colors to quickly identify version control status |
|
X |
| Programming, testing and debugging |
| Test-run (Verify) a SQL script, view the results immediately and undo |
X |
X |
| Check, verify or run a selected block of SQL code and view the results immediately |
X |
X |
| Generate select ... into ... and insert into ... statements interactively |
X |
X |
| Use aliases for servers |
X |
X |
| Automatically script database objects |
X |
X |
| Store SQL Scripts. Edit and execute the scripts from a the SQL Editor window. |
X |
X |
| Code Snippets- organize your informal scripts (code snippets) into a shared database. Classify snippets into multiple categories. Drag and drop Code Snippets to your object code |
|
X |
| Group objects |
X |
X |
| Debugging facility |
X |
X |
| Editing features |
| Edit code objects using multiple windows |
X |
X |
| Search for text across a whole database, or multiple databases, or multiple servers |
X |
X |
| Instantly duplicate an object |
X |
X |
| Pick table, field and variable names from IntelliSense® -like lists as you type (Code Complete) |
X |
X |
| Drag and drop, or copy and paste, code between windows and the Object Browser |
X |
X |
| Record and play back a keyboard macro |
X |
X |
| Use up to ten quick jump bookmarks in every code object |
X |
X |
| Restore clipboard contents from the complete Microsoft® Windows® clipboard history |
X |
X |
| Extensive keyboard shortcuts |
X |
X |
| Restore deleted objects instantly |
|
X |
| Correct commonly misspelled words as you type using 'Auto-Correct' |
|
X |
| Insert blocks of code or templates using short names ('Auto-complete') |
|
X |
| Everyday operations |
| Design table with Speed SQL IDE's full-featured, easy to use table designer |
X |
X |
| Edit data directly from the Data Editor |
X |
X |
| Build queries visually |
X |
X |
| View script output in a variety of formats |
X |
X |
| View execution plans |
X |
X |
| View and edit permissions for an object |
X |
X |
| Define Create templates for each code object type to standardize and simplify object coding |
X |
X |
| Generate reports in a variety of formats including text, PDF, RTF and HTML |
|
X |
| Database and Server Management |
| Simple server connection and connection management |
X |
X |
| Create and drop databases |
X |
X |
| Attach and Detach databases |
X |
X |
| Backup and Restore |
X |
X |
| Quick Backup and Quick Restore |
X |
X |
| Speed SQL IDE history and Change History |
| Maintain a history of each and every change within Speed SQL IDE. View and switch back to any version of any object |
|
X |
| Review Change History for a database over a specified period |
|
X |
| Online resources and documentation |
| Context-sensitive online help |
X |
X |
| Comprehensive user guide |
X |
X |
| Features in Development |
| Users, Roles and Permissions management |
X |
X |
| ER Diagram Tool |
X |
X |
| Code Auditing |
|
X |
| Deploy (release builder) |
|
X |
| Templates |
|
X |
| Doco (database documentation) |
|
X |
| Data Version Control |
|
X |
