Develop SQL Code Quickly, Efficiently
The SQL IDE is a clean, slick development environment ideal for creating and modifying SQL code geared to the needs of application developers. Real-time quick fixes flag and correct inefficient SQL automatically. The IDE is also equipped with SQL code assist, real-time SQL syntax validation, and project-level SQL file cataloging and search features.
Visually Accelerate Query Building
Database developers can save time and start developing SQL code immediately with Visual Query Building tools. Rapid SQL gives you the ability to construct complex SQL statements with point-and-click ease using the Visual Query Builder.
Debug SQL Code, Functions, and Stored Procedures
SQL Debugger simplifies the task of finding coding errors. The SQL Debugger is another database productivity tool that lets you debug SQL Server, Oracle, Sybase ASE or DB2 stored procedures as well as Oracle functions. The Debugger features basic execution, line-by-line execution, breakpoint support, and other common debugging features.
Collaborate Effectively with Version Control
Collaborate with your team with version control, reverse-engineering, and source code repository capabilities. Rapid SQL incorporates version control functions and build management facilities to help you manage and build projects. The product provides seamless integration with most commercial version control packages and support for all operations including get, checkout, check-in, history, and diff.
Support Data Governance Initiatives through Improved Code Quality
Enhance the data quality of your organization with Rapid SQL's developer capabilities. Database developers can utilize Rapid SQL's SQL Debugger to improve SQL code and improve database performance. Rapid SQL provides an assortment of other developer features to improve productivity and code quality.
| General Features |
| Multi-platform Support |
Supports all major DBMSs from a single interface. Ability to use the tools on all supported platforms from a single license. |
| Embarcadero® AppWave™ |
Enables centralized license management and tool deployment |
| Unicode Support |
Full Unicode character support throughout the application |
| Intuitive Interface |
Automates common and repetitive tasks with easy-to-use SQL editors and wizards |
| SQL Scripting and Editing |
| Visual Query Builder |
Constructs even the most complicated SQL statements with point-and-click ease |
| Code Templates |
Eliminates the need to memorize and type SQL syntax |
| SQL Editor |
Code folding, code collapse/roll-up, syntax coloring, hot key assignments, configurable auto replace of objects, bind variable support, selective statement execution |
| Context-sensitive DMBS Actions |
DBMS actions, such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor |
| Debugging, Performance Optimization |
| Code Analyst |
Performs detailed response time analysis on the execution of stored procedures and functions |
| SQL Debugger |
Debugs programmable objects such as stored procedures, functions, packages, and triggers. Available for DB2 for LUW, Oracle, SQL Server, and Sybase |
| SQL Profiler |
Captures metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher. |
| Developer Features |
| Advanced Code Assist |
Lists context-sensitive suggestions as you type (e.g., tables, columns, procedures, functions, and code templates) and is available offline |
| Code Formatting and Profiles |
Code folding, syntax coloring, comment toggling, and other auto formatting features make it easy to read, navigate, and edit large SQL files. Customize and share various SQL formatting options by creating SQL formatting profiles |
| Context-sensitive DBMS Actions |
DBMS actions, such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor |
| Syntax & Semantic Validation |
Validate SQL files and flags all DBMS-specific parser violations or references to objects not found in the target database |
| Quick Fixes |
Real-time parsing provides code quality suggestions for improving SQL performance as you type |
| SQL Debugging |
Debug Java, step seamlessly into SQL (i.e. stored procedure) and back into Java again – true system-wide, round-trip debugging |
System Requirements
Minimum hardware requirements:
- Pentium 4-level processor
- 1 GB of Memory
- 1 GB of free disk space
- 1024 x 768 display
Rapid SQL supports the following operating systems:
- Windows XP SP2 (32-bit and 64-bit)
- Windows Vista (32-bit and 64-bit)
- Windows 7 (32-bit and 64-bit)
Rapid SQL Product Editions
Rapid SQL is available in two editions – Standard and Professional editions, both of which have platform-specific and XE versions.
Standard Edition – Designed for both the Business Analyst in need of analyzing data through SQL queries and the Database Developer who needs to write queries and create/modify schemas and objects.
Professional Edition – Designed for Database Developers who benefit from robust SQL debugging capabilities. Professional edition also includes a PL/SQL Profiler (Oracle only).
| Rapid SQL Standard | Rapid SQL Professional | Rapid SQL XE |
| Designed for |
Business Analyst, Database Developer |
Database Developer |
Database Developer working on multiple platforms |
| Latest Version |
8.2 |
8.2 |
XE3.5 |
| Previous Version |
March 2013 |
March 2013 |
March 2013 |
| SQL Scripting and Editing |
|
|
|
| Object Creation and Editing |
|
|
|
| Schema Development |
|
|
|
| Version Control |
|
|
|
| Debugger |
|
|
|
| Code Analyst |
|
|
|
| PL/SQL Profiler (Oracle only) |
|
|
|
| AppWave Licensing |
|
|
|
| Connect to all database platforms |
|
|
|
Platform-specific Versions – These products support one major platform. Rapid SQL for Oracle, Rapid SQL for SQL Server, Rapid SQL for Sybase, and Rapid SQL for DB2 are available.
XE Version – Grants the license holder the ability to connect to multiple supported database platforms within the same User Interface, with no need to purchase additional platform-specific software. These users can connect to Oracle, SQL Server, Sybase, and DB2 (LUW & z/OS) platforms simultaneously.
|