Released: Sep 1, 2025

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 clustered keys...

Released: Apr 8, 2025

18.9 での更新項目

機能

• 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.

Released: Nov 19, 2024

18.8 での更新項目

機能

• Added support of authorizations for PostgreSQL through Google Cloud.

不具合の修正

• [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.

Released: Jul 30, 2024

18.7 での更新項目

機能

• [Oracle] Enhanced DB PowerStudio Security authorizations - Users can now leverage multi-factor authentication (MFA) using the identity provider Microsoft Entra, formerly Azure Active Directory (AD), when connecting to Oracle. When logging into Oracle, you can gain the inherent security policies and procedures from Microsoft Entra by entering your password only once.
• Updated the Monitor button to open a separate tab rather than simply a frame.
• [Snowflake] Now displays syntax that has been...

Released: Feb 27, 2024

18.6 での更新項目

機能

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

Released: Nov 28, 2023

18.5 での更新項目

機能

• Added binary column support for Db2 for LUW.
• Updated stored procedures functionality when using Redshift.
• Added support for the following database versions:
  • Db2 for LUW 11.5.x.
  • MySQL 8.0 and later.
  • PostgreSQL 14.x.

不具合の修正

• [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.

Released: May 24, 2023

18.4 での更新項目

機能

• Now includes native Git version control. Users may use Git version control to:
  • 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.

不具合の修正

• [DB2] Output from migration does not create table.
• [SQL Server] Error message "Incorrect syntax near 'Index'" appears when dropping the Foreign Key between two tables.
• [Azure SQL] Unable to drop an index on Azure SQL DB.
• [Azure SQL and Oracle] Descending sort order...

Released: Dec 8, 2022

18.3 での更新項目

機能

• Added support for the latest version of Log4j.
• Improved profiling session capability which alerts users to potentially problematic SQL ahead of time.

不具合の修正

• [Oracle] DDL validation failing after reordering columns.
• [SQL Server] Windows Authentication not working with Access Analyst.
• [Azure SQL] Cannot connect to Azure SQL using MFA.
• [Azure SQL] User would like additional features for Azure support.
• [PostgreSQL] Receiving an error when trying to connect to PostgreSQL.
• [Sybase ASE] Profiling...

Released: Jul 20, 2022

18.2 での更新項目

機能

• Added support for Microsoft Windows 11.

Released: Apr 16, 2022

18.1 での更新項目

機能

• 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.

不具合の修正

• [Sybase ASE] Sybase ASE Syntax Drop Login, Alter Login not presenting with DDL Extract.
• [Sybase ASE] Format SQL Clears out commands.
• [Oracle and SQL Server] Stored Procedure is not extracting correctly with Rapid SQL 17.1.1.