 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
Rapid SQL Integrated Environment for Database and Web Programming
Rapid SQL is an integrated development environment that enables developers to create, edit, version, tune, and deploy server-side objects residing on Oracle®, Microsoft® SQL Server, IBM® DB2® and Sybase® databases. Its HTML and Java programming facilities create a unified development environment for database and Web programming, while its extensive graphical facilities simplify SQL scripting, object management, reverse-engineering, database project management, version control, and schema deployment. Rapid SQL contains extensive code templates that eliminate the need to memorize and type SQL syntax. In addition, its graphical browsing capabilities allow you to understand the structure and dependencies of database objects with a click of a mouse. Armed with Rapid SQL, programmers can develop and maintain high-quality, high-performance client/server and Web-based applications in less time, and with greater accuracy. Productivity Enhancements
Schema Development Rapid SQL’s standardized, multi-tabbed, graphical object editors
for each database object type allow you to move effortlessly from
managing a SQL Server or Sybase® schema to managing an Oracle®
schema – and vice-versa. The product contains full knowledge
of the underlying DBMS system catalog, syntax, and alteration rules.
SQL Scripting and Development Rapid SQL offers powerful visual tools for creating and analyzing complex SQL statements and server-side code objects such as stored procedures, triggers, etc. Using the Query Builder, you can construct even the most complicated SQL statements with point-and-click ease. As you select the objects and methods to use for SQL statements, Rapid SQL automatically generates the code. The built-in syntax-checking facility ensures that all SQL statements are built to run correctly the first time. Rapid SQL’s feature-rich ISQL facility allows you to create, save, and execute all SQL code against your databases with ease. Built-in hotkeys and code completion features help you code SQL as quickly as possible. To analyze and debug your code, Rapid SQL provides built-in explain
and performance execution analysis as well as cross-platform code
debuggers (purchased and licensed separately) that you can use to
troubleshoot server-side code objects. For unattended SQL capture
and execution analysis, you can use the optional SQL Profiler component
(purchased and licensed separately). Finally, to tune inefficient
SQL code, Rapid SQL integrates with the Embarcadero SQL Tuner to
automatically rewrite poorly performing code into fully optimized
SQL. Database Project Management Working with off-line SQL code as opposed to live database objects helps safeguard your environment. Rapid SQL organizes and categorizes database objects into an off-line SQL source code repository that you can manage via a graphical tree interface. You can easily work with original SQL source code as opposed to live database objects. A powerful reverse-engineering facility can extract a predefined subset of existing objects from a live database into a Rapid SQL project, producing an individual file for each database object. Built-In Version Control Rapid SQL provides seamless integration with most commercial version-control packages, such as Microsoft Source Safe®, PVCS™, and Clear Case. You can place projects under a central version control system with just a few mouse clicks, enabling multiple developers to work on the same project. All version control operations, such as get, checkout, check-in, history, and diff are supported. Visual SQL Statement Creation and Data Editing Rapid SQL offers powerful visual tools for creating SQL statements and editing data. Using the Query Builder, you can construct even the most complicated SQL statements with point-and-click ease. As you select the objects and methods for SQL statements, Rapid SQL automatically generates the code. The built-in syntax checking facility ensures that all SQL statements are built and run correctly the first time. The Data Grid allows you do ad-hoc data editing within Rapid SQL. You can add, change, or remove data on a row-by-row basis, or you can save all modifications and send them as one unit of work to the database. All referential integrity constraints are enforced in every editing session. Web Development Facilities Web programmers developing with Java and HTML will find that Rapid SQL offers many of the tools necessary to create database-aware Web applications. Using Rapid SQL, you can simultaneously browse data in an Oracle database, debug a PL/SQL procedure in the Oracle database, compile a Java program, and edit a Web page. Rapid SQL’s Web-oriented productivity features include:
Code Analyst Tuning Integration Rapid SQL provides integration with Embarcadero SQL Tuner. You
can use Embarcadero SQL Tuner to obtain the best possible performing
query by taking a set of SQL and sending it directly to Embarcadero
SQL Tuner. Once the SQL is tuned, it can be returned to Rapid SQL
with a click of a button. Stored procedures, Triggers, and other
database code can be properly tuned the first time before being
rolled out into production. This functionality is available within
Rapid SQL’s ISQL Editor and Query Builder. Optional Debugging and Profiling Functionality
Non-Invasive Installation Unlike other Development tools, Rapid SQL does not install any
objects on production database servers so you have no product footprint
to manage. DBMS Support Rapid SQL supports the following DBMS versions running on UNIX®, Linux and Windows NT®-based servers:
System Requirements
Home --> Products --> Ensure --> Rapid SQL |
|
||||||||||||
