Page History
DB Change Manager provides the following new features and fixed issues. For items introduced or fixed in an earlier release, see Previous features and fixed issues.
18.
...
7 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.
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.
Enhances DB2 performance in DB Change Manager
DB Change Manager 18.7 users can take advantage of the added options in DB2 Data Synchronization to optimize performance, by maintaining data integrity, and therefore avoiding bottlenecks by making sure the data is accurate. There also are additional options that improve comparisons of Triggers and Sequence Columns, providing the user the benefit of constancy across schemas.
18.7
...
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. |
| 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 | ||
| 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 |