Rapid SQL

Embarcadero Rapid SQL helps developers and DBAs produce high quality SQL code faster. A rich development environment simplifies SQL scripting, query building, object management, project management, and version control in live databases or offline source code repositories.

Rapid SQL is now available in three product editions: Standard, Professional and XE. For details on the differences between the editions, see the Product Editions Snapshot or Rapid SQL Datasheet.

With Rapid SQL you can:

• Create high-quality SQL code in less time
• Develop SQL for up to seven popular database platforms – from a single interface
• Support team collaboration and resource sharing
• Increase application developer productivity

Intuitive SQL editing, debugging, and optimization tools help create high performance SQL code. One easy-to-use interface lets developers work across multiple database platforms so development teams can standardize on one solution and maximize database development efficiency. Rapid SQL supports all major databases including IBM® DB2® for LUW, DB2® for z/OS, Firebird, InterBase, Microsoft® SQL Server, MySQL®, Oracle®, and Sybase®.

New in Rapid SQL 7.7 - ISQL Editor enhancements include on-the-fly SQL syntax alerts, semantic validation, and SQL parsing

• Go global with full Unicode and ehanced currency support
• Code complete with dynamic "walk-throughs"
• InterBase and Firebird Support

Object creation, visual query builder and SQL editing - full knowledge of the underlying DBMS system catalog, syntax, and alteration rules – for up to 7 major DBMSes

• Graphical object editors for object creation, drop, and extended alter
• Visual query builder
• Code templates

Collaboration and Project Management - comprehensive set of features to support team code management

• Reverse-engineering
• Version Control
• Source Code Repository

Rich SQL Programming IDE

• Highly productive environment with SQL code generation, multiple workspaces and customizable code templates
• Comprehensive scripting support including syntax checking, auto-code complete, and built-in hot keys
• Visual tools for ad-hoc data editing and simple to complex query building

Schema Development

• Database platform and version specific graphical object editors with full knowledge of underlying DBMS

Sophisticated Database Project Management

• The ability to work with off-line SQL source code, instead of live databases
• Extraction of predefined subsets to create single files for specific database objects

Version Control

• Seamless integration with most commercial version control packages
• Support for all operations including get, checkout, check-in, history, and diff

Code Debugging, Optimization, and Profiling

• Debugging for programmable objects such as stored procedures, functions and triggers
• Response time analysis and benchmarking capabilities with code analyst (Rapid SQL Professional and XE only)

Windows XP (32-bit and 64-bit), Windows Vista (32-bit and 64-bit), Windows 7 (32-bit and 64-bit)

Support for 64-bit environments require installation of a 32-bit DBMS client

1024 MB memory

512 MB disk space

DBMS Client connectivity utilities

For ODBC, an ODBC supported driver