Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
minLevel2

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.5 Fixed issues

Issue NumberDescriptionDBMS
DBA-34618Resolves an issue causing an error for some PostgreSQL 12.3 users when they double-click a domain to open the editorPostgreSQL 12.3
DBA-34657Resolves an issue causing DBArtisan to not display all Redshift parameter modes when creating a Stored Procedure Amazon Redshift
DBA-34658Resolves an issue preventing some Redshift users from editing parameters for Stored ProceduresAmazon Redshift
DBA-34814Adds support MySQL 8.0 or latest releaseMySQL
DBA-34844Adds support Db2 LUW - 11.5.xDb2 for LUW
DBA-34859Adds support PostgreSQL 14.xPostgreSQL
DBA-34863Resolves an issue with DBArtisan where BINARY and VARBIN string types are not supportedDb2 for LUW
SC-14832CHANGE MANAGER: Resolves an issue causing only two tables to appear in Mapping and Materialized Query TablesDb2 for LUW

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.

18.4 Fixed issues

Issue Number

Description

DBMS

DBA-34810Output from migration does not create tableDB/2
DBA-34792Error message "Incorrect syntax near 'Index'" appears when dropping the Foreign Key between two tablesSQL Server
DBA-34788Unable to drop an index on Azure SQL DBAzure SQL
DBA-34784Descending sort order is missing when editing properties of an indexAzure SQL, Oracle

18.3 New features

Updates Azure cloud monitoring capability in DBArtisan

The monitoring capability for Microsoft Azure cloud is updated in DBArtisan. This functionality includes multi-tabbed process monitoring and management as well as allows you to catch performance issues before they arise.

Supports the latest version of Log4j

DB PowerStudio 18.3 includes support for the latest version of Apache Log4j, which is essential for proper logging and diagnostics of applications. 

Improves multiple areas within DBArtisan and Rapid SQL

DB PowerStudio 18.3 includes updates to the following areas within DBArtisan and Rapid SQL:

  • Extraction operations on roles for PostgreSQL allows users to have higher control over their data security.
  • Handling procedures with cascaded parameters on Redshift provides additional usage options with those parameters.
  • Connections to Azure SQL using multi-factor authentication provides more secure access.
  • Connections to PostgreSQL via Java Database Connectivity (JDBC) provides native connectivity for quicker access.
  • Reordering columns for Data Definition Language (DLL) validation allows the flexibility to rerun or reuse in scripts.

Improves multiple areas within DB Change Manager

  • Validation of Dump Devices, Linked Servers, Remote Servers and Server Triggers on Azure enables higher quality of those features.
  • Reuse of connection settings on logins when a node is accessible in SQL Server Management Studio (SSMS) allows faster user connections.
  • Fully populating database nodes on Azure for completeness.

Updates profiling session capability in DB Optimizer

DB Optimizer 18.3 updates profiling session capability, which alerts users to potentially problematic SQL ahead of time.

18.3 Fixed issues

Issue NumberDescriptionDBMS
DBA-34744Log4J Upgrade all of DB PowerStudio
DBA-34743DDL validation failing after reordering columnsOracle
DBA-34682Windows Authentication not working with Access AnalystSQL Server
DBA-34605Cannot connect to Azure SQL using MFAAzure SQL
DBA-34524Receiving an error when trying to connect to PostgreSQLPostgreSQL
DBA-34244User would like additional features for Azure supportAzure SQL
OPT-5352Profiling session does not finish and seems to stallSybase ASE

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 NumberDescriptionDBMS
DBA-34677Issue when importing .xlsx files in DBArtisan 18.0Sybase ASE
DBA-34675Issue when opening tables in the DB2 Servers database
DBA-34674Issue in DBArtisan when using Audit Unified Policies tree nodes in Oracle 19c and 21cOracle
DBA-34673Performance issues in DBArtisan 18.0Oracle
DBA-34672DBArtisan is missing security roles and MQT extractionDB2 for LUW
DBA-34667Sybase ASE Data Cache window does not properly show bound objects in the cacheSybase ASE
DBA-34666DBArtisan displays incorrect Create Date for individual loginsSybase ASE
DBA-34665DBArtisan does not recognize "lockless" cache typesSybase ASE
DBA-34662Permissions error when using Capacity AnalystSybase 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 NumberDescriptionDBMS
DBA-34651Update OpenJDK 11.0.7 to the latest OpenJDK 11 release
DBA-34650Update PostgreSQL support to version 13PostgreSQL
DBA-34649Update Oracle support to version 21cOracle
DBA-34646Provide 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-6188Stored Procedure is not extracting correctly with Rapid SQL 17.1.1Oracle, 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 NumberDescription
SC-14793Comparison Results tab user interface is incorrect
SC-14784

Stored Procedures comparison shows there are differences but View Differences shows none

SC-14783Date comparison between Oracle and SQL Server is incorrect
SC-14782Change 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-14765Schema Comparison displays different results

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

17.0.4 Fixed issues

There are no customer-reported issues fixed in the DB Optimizer 17.0.4 release.

17.0.3 Fixed issues

...

17.0.2 Fixed issues

There are no customer-reported issues fixed in the DB Optimizer 17.0.2 release.

17.0.1 Fixed issues

Issue #DescriptionDBMS
OPT-5017SQL Editor problems do not appear in Problems viewSQL Server
OPT-5082Error log does not show errors reported by tuning sessionAll
OPT-5086SQL tuning session cost color preference not workingAll
OPT-5087SQL tuning session cost color preference also applied to elapsed timeAll
OPT-5088SQL tuning session stops if the elapsed time is longer than the originalAll
OPT-5097SQL tuning session offers obvious selection criteria for picking winnerAll
OPT-5098SQL tuning session should highlight # winners found and % improvementAll
OPT-5103DBO needs a priv grant wizard like DBArtisan's capacity analystOracle
OPT-5106Saving a tuning session does not persist/save user selectionsAll
OPT-5121"Tables/Views/Synonyms" are not getting resolved in SQL Server and Sybase when it exists in schema other than DBOSQL Server, Sybase
OPT-5122Sybase: table name is getting resolved but not executedSybase
Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse