18.2 New features
Adds support for Snowflake in DBArtisan and Rapid SQL
DB PowerStudio 18.2 adds support for Snowflake in DBArtisan and Rapid SQL.
Adds support for Windows 11
DB PowerStudio now supports the Microsoft Windows 11 operating system.
Updates database platform support in DBArtisan and Rapid SQL
This release of DB PowerStudio includes updated support in DBArtisan and Rapid SQL for the following database platforms:
- DB2 LUW 11.5
- Sybase IQ 16.1
Updates trial licensing in DB Optimizer
This release of DB PowerStudio includes updated trial licensing support for DB Optimizer to limit the number of suggestions a user can submit.
18.2 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34677 | Issue when importing .xlsx files in DBArtisan 18.0 | Sybase ASE |
| DBA-34675 | Issue when opening tables in the DB2 Servers database | |
| DBA-34674 | Issue in DBArtisan when using Audit Unified Policies tree nodes in Oracle 19c and 21c | Oracle |
| DBA-34673 | Performance issues in DBArtisan 18.0 | Oracle |
| DBA-34672 | DBArtisan is missing security roles and MQT extraction | DB2 for LUW |
| DBA-34667 | Sybase ASE Data Cache window does not properly show bound objects in the cache | Sybase ASE |
| DBA-34666 | DBArtisan displays incorrect Create Date for individual logins | Sybase ASE |
| DBA-34665 | DBArtisan does not recognize "lockless" cache types | Sybase ASE |
| DBA-34662 | Permissions error when using Capacity Analyst | Sybase ASE |
18.1 New features
Adds support for Oracle 21c and PostgreSQL 13 in DBArtisan and Rapid SQL
DBArtisan and Rapid SQL 18.1 add support for Oracle 21c and PostgreSQL 13. This release also includes a number of fixed issues that you may review in the Release Notes.
18.1 Fixed issues
There are no new features in this release of DB Change Manager, but there are the following fixed issues in DB PowerStudio.
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34651 | Update OpenJDK 11.0.7 to the latest OpenJDK 11 release | |
| DBA-34650 | Update PostgreSQL support to version 13 | PostgreSQL |
| DBA-34649 | Update Oracle support to version 21c | Oracle |
| DBA-34646 | Provide ability to open multiple files from the command line | |
| DBA-34644 | Sybase ASE Syntax Drop Login, Alter Login not presenting with DDL Extract | Sybase ASE |
| RAP-6189 | Format SQL Clears out commands | Sybase ASE |
| RAP-6188 | Stored Procedure is not extracting correctly with Rapid SQL 17.1.1 | Oracle, SQL Server |
18.0 New features & fixed issues
There are no new features in this release of DB Change Manager, but there are the following fixed issues.
| Issue Number | Description |
|---|---|
| SC-14793 | Comparison Results tab user interface is incorrect |
| SC-14784 | Stored Procedures comparison shows there are differences but View Differences shows none |
| SC-14783 | Date comparison between Oracle and SQL Server is incorrect |
| SC-14782 | Change Manager reports differences of the CREATE line when running a live comparison |
| SC-14771 | Simple Alter is allowed for a default change and making a decimal bigger, but Change Manager chooses Extended Alter for both the Extended Alter and Simple Alter |
| SC-14765 | Schema Comparison displays different results |