Page History

...

This build of DB Optimizer includes many fixed issues, including the following updates.

18.5 New features

Includes improvements in support of Db2 for LUW

Adds binary column support for Db2 for LUW

This release of DB PowerStudio includes binary column support for Db2 for LUW, which enhances efficiency, performance, and storage utilization in DBArtisan, DB Change Manager, and Rapid SQL.

Improves synchronization script in DB Change Manager

When using Db2 for LUW in DB Change Manager, the synchronization script now applies the appropriate order to be more efficient.

Improves efficiency in DBArtisan, DB Change Manager, and Rapid SQL

DB PowerStudio 18.5 includes operational ease and efficiency improvements for DBArtisan, DB Change Manager, and Rapid SQL.

Updates stored procedures functionality when using Redshift

Redshift users of DBArtisan and Rapid SQL can take advantage of stored procedures which are now added to allow parameter nodes. You now can route these particular requests through the nodes if it satisfies the predicate, allowing more control for the user.

Updates supported database versions

DB PowerStudio 18.5 adds support for the following database versions:

• Db2 for LUW 11.5.x (DBArtisan, DB Change Manager, and Rapid SQL)
• MySQL 8.0 and later (DBArtisan and Rapid SQL)
• PostgreSQL 14.x (DBArtisan, DB Optimizer, and Rapid SQL)

18.4 New features

Adds native Git support

DBArtisan and Rapid SQL now include native Git version control. You must have Git installed on the system where you want to use DB PowerStudio to utilize the native Git version control functionality.

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

Supports SQL Server 2022

DB PowerStudio 18.4 includes support for SQL Server 2022.

Improves space, capacity, and performance for Azure SQL and PostgreSQL

This release of DBArtisan includes updates that improve space, capacity, and performance for Azure SQL and PostgreSQL.

Includes sign-on for AzureAD for PostgreSQL, MySQL, and SQL Server

DBArtisan and Rapid SQL now include sign-on capability for AzureAD for PostgreSQL, MySQL, and SQL Server.

Includes support for PostgreSQL identity columns

DBArtisan and Rapid SQL now include support for PostgreSQL identity columns.

Updates Azure SQL for Data Copying in DB Change Manager

DB Change Manager/Data Compare includes updated support for Azure SQL for data copying. For more information about DB Change Manager, see DB Change Manager Wiki.

18.4 Fixed issues

18.3 New features

Updates Azure cloud monitoring capability in DBArtisan

...