DB PowerStudio Rapid SQL Technical Specifications

What's New in 18.6

For the new features and fixed issues in the latest version of Rapid SQL, see What's New.

System Requirements

* Rapid SQL supports only a subset of features and functions for this database version.

** Support for this version is nearing end of life and may not be available in subsequent Rapid SQL releases. 

Version History

Version 18.6

• Provides full GIT support
• Allows users to connect to PostgreSQL through Azure Active Directory
• Allows Redshift authentication through IAM
• Adds support for PostgreSQL profiling in DB Optimizer
• Adds multi-factor authentication for MS SQL in DB Optimizer and DB Change Manager

Version 18.5

• Adds binary column support for Db2 for LUW
• Improves synchronization script in DB Change Manager
• Improves efficiency in DBArtisan, DB Change Manager, and Rapid SQL
• Updates stored procedures functionality when using Redshift
• Updates supported database versions

Version 18.4

• Adds native GIT support
• Supports SQL Server 2022
• Includes sign-on for AzureAD for PostgreSQL, MySQL, and SQL Server
• Includes support for PostgreSQL identity columns
• Updates Azure SQL for Data Copying in DB Change Manager

Version 18.3

• Updates Azure cloud monitoring capability in DBArtisan
• Supports the latest version of Log4j
• Improves multiple areas within DBArtisan and Rapid SQL
• Improves multiple areas within DB Change Manager
• Updates profiling session capability in DB Optimizer

Version 18.2

• Adds support for Snowflake in DBArtisan and Rapid SQL

• Adds support for Windows 11

• Updates database platform support for the following database platforms:

  • DB2 LUW 11.5

  • Sybase IQ 16.1

• Updates trial licensing in DB Optimizer to limit the number of suggestions a user can submit

Version 18.1

• Adds support for Oracle 21c and PostgreSQL 13

Version 18.0

• Adds support for Amazon Redshift cloud data warehouse

Version 17.1.0

• Supports:
  • Windows Server 2019
  • SQL Server 2014 SP2
  • Oracle 11g R2
  • PostgreSQL 12

Version 17.0.4

• Supports:
  • Oracle 19c
  • PostgreSQL 11.2
  • SQL Server 2019

Version 17.0.3

There are no new features for this product version release.

Version 17.0.2

There are no new features for this product version release.

Version 17.0.0

• Improved SQL Server feature plan
  • Table and index compression
  • Columnstore index support
  • Primary and secondary XML index support
  • Spatial index support
  • Data Masking support
  • Temporal tables support
  • In-memory tables support
  • Natively-compiled procedures support
  • Table encryption support
  • Check constraints support
• Improved Execution Plan support
• Supports visual file group, data file, and log file
• Improved Databases Summary Detail screen
• Improved server roles 
• Added print capability to Index CREATE and ALTER scripts

Version 16.6.1

• Improved data dictionary lookup and caching
• Performance improvements
• Completes support for Oracle 12c

Version 16.6.0

• Extract, Migrate, and Report functionality completed for Oracle object types added in v16.5
• Supports additional Oracle object types
• Improved Explain Plan support
• Supports Db2 LUW 11 and Sybase 16

Version 16.5 (2016+)

• IDERA rebranding
• Product licensing changes
• Single Java directory for multiple IDERA products
• Improved password security
• Error reporting for troubleshooting
• Improved performance and exception handling
• Support Set Current schema
• Updated Database Explorer schema object types
• Supports newer partitioning options

Version 16.0 (2016)

• PostgreSQL object management
• Supports Team Server 16.0 (2016)
• Missing indexes
• ISQL performance

IDERA |  Products | Purchase | Support |  Resources |  About Us  | Legal