This build of DB Optimizer includes many fixed issues, including the following updates.
18.7 New features
Enhances Security authorizations
DB PowerStudio 18.7 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 users gain the inherent security policies and procedures from Microsoft Entra by entering your password only once.
Adds support for Azure DevOps for source control
This release of DBArtisan and Rapid SQL includes support for Azure DevOps for source control. Users gain the benefits of planning, collaborating, and code development using Azure DevOps Git repository for Project management. This feature allows developers to log in to Azure DevOps via a token and manage their code for history, check-in, and checkout capabilities.
18.7 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34685 | Updates the Monitor button to open a separate tab rather than simply a frame. | |
DBA-34842 | Resolves an issue where extracting DDL for a Job returns single rather than double quotation marks. | Oracle |
DBA-34905 OPT-5381 SC-14846 | Supports multi-factor authentication for Oracle through Microsoft Entra. | Oracle |
DBA-34906 | Displays syntax changed in the parser. | Snowflake |
DBA-34907 | Adds support for Azure DevOps Services. | |
RAP-6226 | Resolves an issue causing a data Cache size discrepancy in DBArtisan. | Sybase ASE |
SC-14840 | [Change Manager] Allows users to use native database tools in synchronization scripts when moving data. | |
SC-14841 | [Change Manager] Adds a new Compare option to Ignore Identity Properties in your Schema Comparison jobs. | |
SC-14844 | [Change Manager] Provides better comparison results by parsing Trigger content rather than comparing whole text. | DB2 for LUW |
SC-14849 | [Change Manager] Resolves an issue with an incorrect syntax of the CREATE TABLE SQL statement. | DB2 for LUW |
SC-14850 | [Change Manager] Allows users to choose whether to use the DBA or ALL view of Permissions in Oracle sys Tables. | Oracle |
18.6 New features
Allows users to connect to PostgreSQL through Azure Active Directory
This release of DB PowerStudio allows users to connect to PostgreSQL through Azure Active Directory.
Adds support for PostgreSQL profiling in DB Optimizer
DB Optimizer 18.6 allows users to select PostgreSQL for a profiling session.
Adds multi-factor authentication for MS SQL Server in DB Optimizer and DB Change Manager
DB Optimizer and DB Change Manager users now can use multi-factor authentication for Microsoft SQL Server.
18.6 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34549 | Resolves an issue where some MySQL users received an error when trying to create a new user account. | MySQL |
| DBA-34656 | Resolves an issue preventing some Amazon Redshift users from being able to select a '''Database''', '''Owner''', or '''Object''' when using the Paste SQL wizard in the SQL Editor. | Amazon Redshift |
| DBA-34686 | Resolves an issue causing an error when a user attempts to delete any collection programmed into Capacity Analyst or any task programmed in DBArtisan using root user and administrator user. | Sybase ASE |
| DBA-34758 | Resolves Performance Analyst issues causing some Sybase users to receive an invalid column name error and an occasional DBArtisan crash when exiting the Performance Analyst. | Sybase ASE |
| DBA-34767 | Resolves an issue resulting in an empty Migrations Options screen. | |
| DBA-34820 | Resolves an issue preventing indexes from being dropped or appearing in the table editor. | |
| DBA-34851 | Resolves an issue where the DBArtisan project file was not created when you create a new project from the Version Control Project. | |
| DBA-34865 | Resolves an issue where DBArtisan cannot properly identify the Sybase client install in the machine. | Sybase ASE |
| DBA-34871 | Resolves an issue causing the system to create extended alter statements for any modification on a table. | Db2 for LUW |
| DBA-34874 | Adds support for connecting to PostgreSQL through Azure AD. | PostgreSQL |
| DBA-34875 | Adds support for authentication for Amazon Redshift through IAM. | Amazon Redshift |
| OPT-5351 | Adds support for Postgres profiling session. | PostgreSQL |
| OPT-5379 | Adds support for multi-factor authentication for DB optimizer for SQL Server. | SQL Server |
| RAP-6222 | Resolves an issue preventing users from being able to highlight multiple tables at once. | |
| SC-14820 | Resolves an issue causing a blank Refinements page when creating the Configuration Comparison job when two Azure SQL DB data sources are registered. | Azure SQL |
| SC-14833 | Resolves an issue preventing the display of more than 1,000 Objects in the Database Objects explorer. | |
| SC-14835 | Adds support for multi-factor authentication for Change Manager for SQL Server. | SQL Server |
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 Number | Description | DBMS |
|---|---|---|
| DBA-34863 | Resolves an issue with DBArtisan where BINARY and VARBIN string types are not supported | Db2 for LUW |
| DBA-34859 | Adds support PostgreSQL 14.x | PostgreSQL |
| DBA-34844 | Adds support Db2 LUW - 11.5.x | Db2 for LUW |
| DBA-34814 | Adds support MySQL 8.0 or latest release | MySQL |
| DBA-34658 | Resolves an issue preventing some Redshift users from editing parameters for Stored Procedures | Amazon Redshift |
| DBA-34657 | Resolves an issue causing DBArtisan to not display all Redshift parameter modes when creating a Stored Procedure | Amazon Redshift |
| DBA-34618 | Resolves an issue causing an error for some PostgreSQL 12.3 users when they double-click a domain to open the editor | PostgreSQL |
| SC-14832 | CHANGE MANAGER: Resolves an issue causing only two tables to appear in Mapping and Materialized Query Tables | Db2 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. For more information about DB Change Manager, see DB Change Manager Wiki.
18.4 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34810 | Output from migration does not create table. | Db2 |
| DBA-34792 | Error message "Incorrect syntax near 'Index' " appears when dropping the Foreign Key between two tables. | SQL Server |
| DBA-34788 | Unable to drop an index on Azure SQL DB. | Azure SQL |
| DBA-34784 | Descending sort order is missing when editing properties of an index. | Azure 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 Number | Description | DBMS |
|---|---|---|
| DBA-34744 | Log4J Upgrade all of DB PowerStudio | |
| DBA-34743 | DDL validation failing after reordering columns | Oracle |
| DBA-34682 | Windows Authentication not working with Access Analyst | SQL Server |
| DBA-34605 | Cannot connect to Azure SQL using MFA | Azure SQL |
| DBA-34524 | Receiving an error when trying to connect to PostgreSQL | PostgreSQL |
| DBA-34244 | User would like additional features for Azure support | Azure SQL |
| OPT-5352 | Profiling session does not finish and seems to stall | Sybase 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 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
| 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
The DB Optimizer 18.0 release includes no customer-reported bug fixes.