Welcome to Embarcadero® Rapid SQL Developer™ 2.0.1

Embarcadero Technologies Home | Technical Support


Embarcadero Rapid SQL Developer simplifies SQL development for application developers with many features for improving productivity and reducing errors. A rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object validation tools help streamline coding tasks. Rapid SQL Developer’s user interface helps improve overall productivity with database object look up functionality and side-by-side views of application code and SQL code. Power SQL offers native support for IBM® DB2® for LUW, Oracle®, Microsoft® SQL Server and Sybase® as well as JDBC support for other DBMS. Rapid SQL Developer is available as a stand-alone application or as an Eclipse plugin.

What's New in Rapid SQL Developer 2.0

Improvements to SQL Editor

Debugging Functionality

Enhancements to Data Source Explorer

SQL Templates

Data Source Indexing

SQL Execution

Text File Encoding (Unicode Support)

SQL Server 2008 Support

Release Notes

Important Advisory Notes

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Rapid SQL Developer 2.0

Improvements to SQL Editor

Code Quality Check and Code Assist functionality have been improved in Rapid SQL Developer 2.0 to provide further comprehension and more fluid code development while working in the environment:

Debugging Functionality

Rapid SQL Developer now features a fully-contained debug process, for the purpose of debugging stored routines in the development environment prior to execution. The debug process is managed via the Debug view, and enables users to manage common debug functionality such as breakpoints and step over, as well as providing variable and dependency views. Additionally, Rapid SQL Developer fully supports cross-platform debugging, which enables you to debug SQL procedures embedded inside Java code.

Enhancements to Data Source Explorer

Rapid SQL Developer 2.0 provides enhancements to Data Source Explorer. This includes improvements to auto-discovery and import functionality, search, and filtering functionality.

SQL Templates

This version of Rapid SQL Developer introduces a selection of 267 fully-customizable code templates that enable developers to select a DML or DDL statement schematic and drop it into SQL Editor. Placeholder syntax can be replaced manually with statement variables, or otherwise customized to meet development needs.

Data Source Indexing

The Data Source Cache has been renamed the Data Source Index to better reflect the nature of its functionality. In addition to the name change, it has been greatly improved and provides faster indexing, as well as automatic incremental updating on CREATE, ALTER, and DROP statements, and indexing options that enable users to specify indexing for individual data sources.

SQL Execution

The SQL execution process has been enhanced to provide more comprehensive Result views. This includes the ability of a user to select different file format options when viewing and saving execution output results.

Text File Encoding (Unicode Support)

Rapid SQL Developer 2.0 provides options for changing the file encoding format used when saving text files. You can set encoding formats globally, or for specific files, or groups of files within the development environment.

SQL Server 2008 Support

Rapid SQL Developer 2.0 provides full support for SQL Server 2008. This includes syntax, compound operators, new data types, Dynamic Management Views, and Functions.

Release Notes

Important Advisory Notes

Rapid SQL Developer can be installed as a standalone application (RCP installation) or as an Eclipse plug-in (Plug-in Installation). Eclipse is an open source development framework that supports application plug-ins to provide additional functionality.

The Eclipse plug-in version of Rapid SQL Developer requires Eclipse version 3.3 or higher, and Sun Java Standard Edition 5.0 Update 11 or later in addition to regular system requirements.

Before installing the plug-in version of Rapid SQL Developer, ensure that Eclipse and Java is installed on your machine. You can download Eclipse from the following Web site: http://www.eclipse.org/downloads.

Bug Fixes


Bugs fixed in Rapid SQL Developer 2.0.1
Bug DBMS Version Description
8629 All All The Eclipse plug-in version cannot be uninstalled.
8637 All All Debugging a procedure requires an SA role.
8730 All All Semantic validation does not take synonyms under consideration.
Bugs fixed in Rapid SQL Developer 2.0
Bug DBMS Version Description
7216 All All Application freezes if connecting to a slow data source and opening a SQL file at the same time.
7215 All All Embedded comments not terminated correctly causes error.
8236 Sybase All Code Assist doesn't pop up column names after user type "." in where clause.
8290 Sybase 12.5.4 Explain plan cannot be computed for the select statement. Reason: Invalid column name 'N'.
6553 SQL Server All SQL_Execution: Error returned when specifying Korean language table name - SELECT * FROM db.tbl.

Additional Resources

Licensing Your Embarcadero Technologies Product

This product includes a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact sales@embarcadero.com, or uk.sales@embarcadero.com for sales in the EMEA region.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, FAQs, discussion groups, and the Embarcadero KnowledgeBase.

Go to www.embarcadero.com/support or click any of the links below to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.