Page History
DB Optimizer Change Manager provides the following new features and fixed issues.
17.0.4 New features
Added support for latest SQL Server version
DB Optimizer 17.0.4 adds support for SQL Server 2019.
17.0.3 New features
There are no new features in DB Optimizer 17.0.3. This release does include a number of fixed issues that you may review in Fixed issues.
17.0.2 New features
Updated version
DB Optimizer 17.0.2 is simply an update to the version number.
17.0.1 New features
Continued licensing updates
DB Optimizer 17.0.1 includes additional licensing updates to bring it into standard with other IDERA products.
Redesigned components
DB Optimizer 17.0.1 contains the following redesigned components for a better user experience:
- Main toolbar
- Data Source tab
- Project Explorer tab
- Main window tab right-hand mouse options
SQL Server enhancements
DB Optimizer 17.0.1 offers a number of SQL Server-related enhancements including:
- The Tuning Statement window includes a drop-down list of schemas when viewing SQL Server databases.
- The DB Optimizer Profiler now properly displays SQL statement detail.
- Improved error messages.
17.0.0 New features
Updated licensing
DB Optimizer includes a new licensing process to bring it into standard with the rest of the DB PowerStudio products.
Updated Installer
The installer for DB Optimizer now:
- Verifies that a supported version of windows OS exists on the machine before continuing with the installation
- Offers offline .MSI files for installation
Removed Auto-Update and Install New Software features from Help menu
...
For items introduced or fixed in an earlier release, see Previous features and fixed issues.
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.
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-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 |