DB PowerStudio Developer Edition Multiplatform Releases

Released: Sep 2, 2025

Updates in 19.0

Features

DB Optimizer 19.0

  • Enhances Tablespace compression for Oracle
    • Tablespace extraction now defaults to COMPRESS BASIC, offering improved performance and storage efficiency for schema export/import operations.
  • Introduces PostgreSQL function reporting
    • Report generation now includes support for PostgreSQL functions, improving visibility, documentation, and auditing in complex environments.
  • Improves DDL Extraction
    • The DDL Extract tab now correctly displays all primary key constraints, including...

Released: Apr 8, 2025

Updates in 18.9

Features

DB Optimizer

  • Added the ability to keep NOT TRUSTED when modifying FK constraints:
    • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.
  • Included enhanced Sybase optimization in DB Optimizer:
    • DB Optimizer users will notice updated profiling to accurately show the sessions.

Rapid SQL

  • Added the ability to keep NOT TRUSTED when modifying...

Released: Nov 19, 2024

Updates in 18.8

Features

DB Change Manager

  • Added support of authorizations for PostgreSQL through Google Cloud.

DB Optimizer

  • Added support of authorizations for PostgreSQL through Google Cloud.

Rapid SQL

  • Added support of authorizations for PostgreSQL through Google Cloud.

Fixes

DB Change Manager

  • [Sybase ASE] Resolved an issue preventing the Login tab from showing the correct value for Password Expire.
  • [SQL Server] Resolved an issue preventing Varchar(max) from displaying more than 8kb of data.
  • Resolved an issue...

Released: Jul 30, 2024

Updates in 18.7

Features

DB Change Manager

  • Added a new Compare option to Ignore Identity Properties in your Schema Comparison jobs.
  • [Oracle] Users can now choose whether to use the DBA or ALL view of Permissions in Oracle sys Tables.
  • [Db2 for LUW] Enhanced DB2 Performance - Users can take advantage of the added options in DB2 Data Synchronization to optimize performance, by maintaining data integrity, and therefore avoiding bottlenecks by making sure the data is accurate. There also are additional options that...

Released: Feb 27, 2024

Updates in 18.6

Features

DB Optimizer

  • Now allows users to connect to PostgreSQL through Azure Active Directory.
  • Adds support for PostgreSQL profiling.
  • Adds multi-factor authentication for Microsoft SQL Server.

Rapid SQL

  • Provides full support of GIT by allowing the creation of projects inside of Rapid SQL. This allows users to view a project once created inside of the GIT Repository.

DB Change Manager

  • Now allows users to connect to PostgreSQL through Azure Active Directory.
  • Adds support for PostgreSQL profiling...

Released: Nov 28, 2023

Updates in 18.5

Features

DB Optimizer, Rapid SQL and DB Change Manager

  • Added support for the following database versions:
    • Db2 for LUW 11.5.x.
    • MySQL 8.0 and later.
    • PostgreSQL 14.x.

Fixes

DB Optimizer

  • [Amazon Redshift] Resolved an issue preventing some Redshift users from editing parameters for Stored Procedures.
  • [PostgreSQL] Resolved an issue causing an error for some PostgreSQL 12.3 users when they double-click a domain to open the editor.

Rapid SQL

  • [Amazon Redshift] Resolved an issue preventing some Redshift...

Released: May 24, 2023

Updates in 18.4

Features

DB Optimizer

  • Now includes native Git version control:
    • Create projects.
    • Get the latest version.
    • Add a file or project.
    • Remove a file or project.
    • Check in a file or project.
    • Get history logs of files.

Rapid SQL

  • Now includes native Git version control:
    • Create projects.
    • Get the latest version.
    • Add a file or project.
    • Remove a file or project.
    • Check in a file or project.
    • Get history logs of files.

DB Change Manager

  • DB Change Manager/Data Compare now includes updated support for copying data...

Released: Dec 8, 2022

Updates in 18.3

Features

Rapid SQL

  • Added support for the latest version of Log4j.
  • Improved extraction operations on roles for PostgreSQL.
  • Improved handling procedures with cascaded parameters for Redshift.
  • Added support for connecting to Microsoft Azure SQL using multi-factor authentication.
  • Added support for connection to PostgreSQL via Java Database Connectivity (JDBC).
  • You can now reorder columns for Data Definition Language (DLL) validation.

DB Change Manager

  • Added support for the latest version of Log4j...

Released: Jul 20, 2022

Updates in 18.2

Features

Rapid SQL

  • Added support for Snowflake.
  • Added support for Microsoft Windows 11.
  • Added support for DB2 LUW 11.5.
  • Added support for Sybase IQ 16.1.

DB Optimizer

  • Added support for Microsoft Windows 11.

Released: Apr 16, 2022

Updates in 18.1

Features

DB Change Manager

  • Updated OpenJDK 11.0.7 to the latest OpenJDK 11 release.
  • Added support for PostgreSQL 13.
  • Added support for Oracle 21c.
  • Added the ability to open multiple files from the command line.

DB Optimizer

  • Updated OpenJDK 11.0.7 to the latest OpenJDK 11 release.
  • Added support for PostgreSQL 13.
  • Added support for Oracle 21c.
  • Added the ability to open multiple files from the command line.

Rapid SQL

  • Added support for PostgreSQL 13.
  • Added support for Oracle 21c.
  • Updated OpenJDK...