Rapid SQL

Overview
Details
Tec Specs
Resources
Compare
Tour
Download

Create high-performing SQL code on major DBMSs from one interface
Easily build complex SQL statements with visual query builder
Quickly construct, analyze and execute SQL code with code analyst
Simplify debugging SQL code, functions, and stored procedures
Collaborate effectively across development teams with version control

Develop Performant SQL Code for Major DBMSs from One UI

Create high-performing SQL code on all major DBMSs (Oracle, SQL Server, Db2 and SAP Sybase) from a single common interface. Reduce training requirements and streamline collaboration among teams across the organization. Manage multiple Oracle-specific schema object types and SQL Server advanced object properties including in-memory tables, natively compiled triggers / procedures / functions, column-store indexes, data compression, temporal tables, and data masking.

Easily Build Complex Statements

Save time and start developing SQL code immediately with Visual Query Building tools. Rapid SQL gives you the ability to construct complex SQL statements with point-and-click ease using the Visual Query Builder.

Quickly Construct and Execute SQL Code

The SQL IDE is a development environment, ideal for creating and modifying SQL code geared to the needs of application developers. Real-time quick fixes flag and correct inefficient SQL automatically. The IDE is also equipped with SQL code assist, real-time SQL syntax validation, and project level SQL file cataloging and search features.

Simplify Debugging

SQL Debugger simplifies the task of finding coding errors and lets you debug SQL Server, Oracle, Sybase or Db2 stored procedures and functions. The SQL Debugger features basic execution, line-by-line execution, breakpoint support, and other common debugging features.

Effectively Collaborate

Collaborate with your team with version control, reverse-engineering, and source code repository capabilities. Rapid SQL incorporates version control functions and build management facilities to help you manage and build projects. It provides seamless integration with most commercial version control packages and support for all operations including get, check-out, check-in, history, and differences.

SQL Scripting & Editing

Visual Query Builder

Construct even the most complicated SQL statements with point-and-click ease.

Code Templates

Eliminate the need to memorize and type SQL syntax.

SQL Editor

Code folding, code collapse/roll-up, syntax coloring, hot key assignments, configurable auto replace of objects, bind variable support, selective statement execution.

Context-Sensitive DBMS Actions

DBMS actions, such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor.

Advanced Code Assist

See context-sensitive suggestions as you type (e.g., tables, columns, procedures, functions, and code templates) and is available offline.

Code Formatting

Code folding, syntax coloring, comment toggling, and other auto formatting features make it easy to read, navigate, and edit large SQL files.

Syntax & Semantic Validation

Validate SQL files and flags all DBMS-specific parser violations or references to objects not found in the target database.

Quick Fixes

Real-time parsing provides code quality suggestions for improving SQL performance as you type.

Debugging & Performance Optimization

Code Analyst

Perform detailed response time analysis on the execution of stored procedures and functions.

SQL Debugger

Debug programmable objects such as stored procedures, functions, packages, and triggers. Debug Java, step seamlessly into SQL (i.e. stored procedure) and back into Java again – true system-wide, round-trip debugging.

SQL Profiler

Capture metrics of various PL/SQL programmable objects on Oracle 8.1.5 and higher.

Execution Plan

Graphical and user-customizable display of a database’s internal processing order and priorities for queries. Provides built-in explain and performance execution analysis.

Object Support

Graphical Object Editors

Create, drop, or alter a wide variety of database objects, including tables, constraints, indexes, views, procedures, functions, triggers, and packages. Editors are common for all objects (across all platforms).

Wizard-Driven Object Creation

Wizards guide users through the creation of objects, prompting for the options that are applicable to objects found on the selected database platforms.

Grouped Object Command Execution

Execute database commands against a select grouping of objects (drop, compile, analyze, etc.).

Extended Alter Support

Generate complex scripts as a result of object manipulation (inserting a column in the middle of a table).

Enterprise Manangement

Multi-Platform Interface

Develop high-performance SQL code on major DBMSs (Oracle, SQL Server, Db2 and Sybase) from a single common interface. Use the tool on all supported platforms from a single license.

Intuitive Interface

Streamline and automate common and repetitive tasks with an easy-to-use GUI and powerful wizards.

Troubleshooting Assistance

Use the automated IDERA Error Report feature to create a zip file containing important details about your Oracle or SQL Server installation, such as product information, hardware metrics, and necessary database information for troubleshooting.

Unicode Support Full Unicode character support throughout the application.

System Requirements

Minimum Hardware Requirements

1 GHz or faster processor
3 GB of RAM
1 GB of free disk space
1024 x 768 display

Supported Operating Systems

Windows 10, Windows 8.1, Windows 8, Windows 7 (32- and 64-bit)
Windows Server 2008 SP1 & 2008 R2 (32- and 64-bit)
Windows Server 2012 & 2012 R2
Windows Server 2016

Supported Database Platforms

Microsoft Azure SQL Database
Microsoft SQL Server 2008, 2012, 2014, 2016*, 2017*
Microsoft SQL Server 2019* (experimental support)
MySQL 4.x, 5.7, 8.0
Oracle 10g, 11g, 12c, 12cR2, 18c, 19c
PostgreSQL 9.3-9.10, 10.7, 11.2
Sybase ASE 15.7, 16.0
Sybase IQ 15.4, 16.0
Greenplum
IBM Db2 for z/OS 10.x and 11.x*
IBM Db2 LUW 10.x and 11.x*

Cloud

Rapid SQL runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports database instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).

NOTE: SQL Profiler is only available for installations of Oracle version 8.1.5 or higher. Debugging in Rapid SQL is only available for Db2 LUW, Oracle, MS SQL Server and Sybase.
*For these databases, Rapid SQL supports a subset of this database version’s features/functions.

Version History

Version 17.0.4

SQL Server 2019 (experimental support), PostgreSQL 11.2, Oracle 18c and 19c database support
Bug fixes

Version 17.0.3

Greenplum database support
Sybase 16.0 database and debugger support
Bug fixes

Version 17.0

Platform updates:
- SQL Server 2017 database and Windows Server 2016 OS support
- MySQL bug fixes and support up through 5.7.18
- PostgreSQL up through 9.6.x, plus SQL code completion
- Greenplum support for SQL code completion
- Removal of support for Firebird and InterBase platforms
Additional SQL Server platform support:
- Enhanced execution plans – pre & post views, display modes
- Support for advanced object properties including In-Memory Tables, Natively Compiled Triggers / Procedures / Functions, Column-Store Indexes, Encryption, Data Compression, Temporal Tables, Data Masking
- Debugger updated for local databases for latest releases
- Problem report generation extended to SQL Server environments
.msi version available for UI-free “headless” installation

Version 16.6

Additional Oracle object types
- Audit Policies
- Unified Auditing
- Resource Plans
Improved Oracle Explain Plan support

Version 16.5

Rapid SQL now has a single edition that includes all available features and has been rebranded for IDERA.
Oracle enhancements include additional schema object types, partitioning options, and set current schema.
Usability improvements for visibility to data in the database, internal SQL statements, and ability to capture system and product details in an automated error report.

Version 16.0

SQL Analytics for SQL Server

Performance insights – Generates syntax performance hints and suggests syntax construction changes where suboptimal SQL statement construction has been used, which leads to poor performance
Index suggestions – Analyzes the system to look for Missing Indexes and suggests indexes to improve performance where the existing indexes insufficiently cover the query and cause excessive data scans
Cardinality & data skew – Shows the user just how poor performance of the SQL statements would be when run against the worst cardinality with the highest data skew

Team Server Integration

Designate Team Server as the data source catalog
Login to your data source using your Team Server credentials

Rapid SQL Datasheet

Everything you need you need to know, all in one downloadable PDF.

DOWNLOAD THE DATASHEET

The Word on the Streets

See what our customers say about Rapid SQL.

DOWNLOAD THE CASE STUDY

View a Democast

Let a pro show you some tips and tricks, live and free!

Compare the leading database development tools

IDERA is focused on delivering the industry’s most complete solution for database development. Rapid SQL offers extensive capabilities for single- and multi-platform database code development, profiling, and debugging.

Compare, side by side, the features and functionalities of some of the database development tools the market has to offer. Download a free trial of Rapid SQL today!

Capability	Microsoft SSMS	PL/SQL Developer
Multi-platform IDE	SQL Server only	Oracle only
Discover data sources
Database search
Job management
Schema creation and editing
Robust and user-friendly scripting
Execution / explain plans
SQL query builder
Isolate query window to designated data source
SQL code editing and formatting
SQL code analysis
SQL code profiling
SQL debugger

With a rich set of features and several unique capabilities, IDERA Rapid SQL aligns with a database developer’s workflow to address many common tasks with a user-friendly interface. Try it free!

Rapid SQL Product Tour

Develop SQL code quickly and efficiently: The SQL IDE development environment is ideal for creating and modifying SQL code geared toward your needs. Real-time quick fixes flag and correct inefficient SQL automatically. The IDE is also equipped with SQL code assist, real-time SQL syntax validation, and project-level SQL file cataloguing and search features.

Visually accelerate query building: Save time and start developing SQL code immediately with integrated query building tools. Rapid SQL gives you the ability to construct complex SQL statements with point-and-click ease using the Visual Query Builder.

Debug SQL code, functions, and stored procedures: The SQL Debugger simplifies the task of finding coding errors and helps you debug SQL Server, Oracle, Sybase ASE or Db2 stored procedures and functions. The SQL Debugger features basic execution, line-by-line execution, breakpoint support, and other common debugging features.

Generate SQL code automatically: Use this SQL abstraction API to cr-eate functions for application developers to call instead of them directly using SQL code operations. This simplifies coding for application developers and allows the project manager to control SQL programming more efficiently.

Identify differences between files or database objects: Quickly see the differences between two procedures, two tables, or two SQL scripts. The Visual Diff tool highlights the fields that do not match between the two objects. You can quickly navigate between the differences to locate all of them.

Create High Performing SQL Code

Download Rapid SQL Today!

Easily build complex SQL statements on multiple DBMSs
Fully functional for 14 days. No credit card required (but all fields are).

Overview

Create high-performing SQL code on major DBMSs from one interface
Easily build complex SQL statements with visual query builder
Quickly construct, analyze and execute SQL code with code analyst
Simplify debugging SQL code, functions, and stored procedures
Collaborate effectively across development teams with version control