Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

Embarcadero Rapid SQL XE2 provides a powerful SQL IDE (Integrated Development Environment) to write high quality SQL code. Easily build queries using the visual query designer, add, view, edit and delete data and database objects, edit SQL with syntax highlighting and code folding support, and profile, debug and optimise SQL code.

Rapid SQL XE2 works across multiple database platforms, providing one common interface for maximum productivity. Supported databases include SQL Server, Oracle, MySQL, Sybase, Firebird, DB2 for LUW and DB2 for z/OS. It comes with centralised license management and tool deployment with Embarcadero ToolCloud and Embarcadero's industry leading 'zero-install' deployment capability with Embarcadero InstantOn.

Documents & Downloads

New Features

New in Rapid SQL XE2/8.0

New SQL Server feature support

• Synonym Support
• Table and Indexing Partitioning
• Full-text Search Support
• DDL Triggers.

New Oracle feature support

• DBMS_STATS Support
• Virtual Columns
• Unusable Index Partition Visibility
• Temporary Tablespace Group Support
• Invisible Indexes
• Read-Only Table Support
• Online Reorganise Tables Option
• Recycle Bin Support
• Flashback Table Action Support.

New Sybase feature support

• Login Trigger Support
• Support for sp_hidetext
• INSTEAD OF Triggers
• User-defined Functions.

Datasource/server updates

• JDBC Driver Updates
• Current Session Role Activation.

Unicode updates

• Improved encoding detection and options when saving and opening files
• Additional UTF-8, UTF-16, and UTF-32 encodings with BOM and endian variations are now available
• Handling of surrogate pairs and characters made up of multiple unicode (LTR scripts only) have been brought in line with Windows Vista and Windows 7 support.

SQL editor

• Query Options supporting Sybase Set Option Text format messages.

Features

Rich SQL Programming IDE

• Highly productive environment with SQL code generation, multiple workspaces and customisable 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, Optimisation, 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).

System Req.

• 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.