Introducing Rapid SQL

From RapidSQL
Jump to: navigation, search

Go Up to Prerequisites and Preliminary Tasks

Rapid SQL is an integrated development environment that enables developers to create, edit, version, tune, and deploy server-side objects residing on Microsoft SQL Server, Oracle, Sybase Adaptive Server, IBM DB2 for Linux, Unix, and Windows, and IBM DB2 for z/OS databases. Its unified database development environment provides extensive graphical facilities that simplify SQL scripting, object management, reverse engineering, database project management, version control, and schema deployment. 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.

About Rapid SQL

Your new application provides tools that can be used by a number of functions within an organization using DBMS from multiple vendors, in testing, development, or production environments.

Datasource management tools: Datasources must be registered. Datasources can be registered manually or semi-automatically. Storage can be registry-based or file-based, and a network storage option facilitates shared use of datasource catalogs.

Object management tools: Your application supports a wide range of database objects and related elements for each DBMS. You can create new objects, edit existing objects, and use a range of object operations that support common, general or DBMS-specific actions.

Coding Environments/Editors: Fully-featured environments dedicated to SQL, DDL and Active Script development are provided. Execution options are available as appropriate, and environment-specific related features, such as rollback/commit and query plan options, are provided. Related coding aids include on-the-fly semantic and syntactic validation, text substitution shortcuts, and visual query building tools. Related execution tools include script and file execution facilities.

Project Management, Version Control, and Script Library: Rapid SQL database project management facilities help you organize, alter, and keep track of changes to database objects or SQL scripts. The project management facilities act as a repository to maintain all source code for a database project. Rapid SQL also incorporates version control functions and build management facilities to help you manage and build projects.

Other Time-savers and Productivity Tools: Working within the Rapid SQL environment, you have access to database and file search facilities, use visual difference to compare files or database objects, and access the Microsoft Windows task scheduler.

License-specific Add-ons: Depending on the licenses you purchased, you have access to the following tools:

  • The Rapid SQL Code Analyst helps you identify time-consuming lines of code. It lets you perform detailed response time analysis, benchmark the execution of one or more procedures or functions, save response time metrics, and perform intelligent comparisons against current execution times.
  • Debuggers, available for IBM DB2 for Linux, Unix, and Windows, Oracle, Sybase, and SQL Server, let you test functions and procedures. A Profiler is available for Oracle datasources.