Search:
Product Details
Embarcadero Rapid SQL XE2 boxshot.

Embarcadero Rapid SQL XE2

Published By: 

Embarcadero

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.

Product Variants

Rapid SQL XE2, Licence *UK ONLY*

Rapid SQL XE2, Maintenance *UK ONLY*

Rapid SQL XE2, Upgrade *UK ONLY*

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.



Vendor Showcases
Intel Logo

Embarcadero Logo

Flexera Logo

GFI Logo

MindJet Logo

TechSmith Logo

ABBYY Logo

SmartDraw Logo

TechSmith Logo

Becrypt Logo

Paessler Logo

Netop Logo
© 2003 - 2012 Sigma Software Distribution. Registered office: Prigg Meadow, Ashburton, Devon, TQ13 7DF, UK. Registered in England. Company no: 1671407. VAT no: GB 384904621.