DB Optimizer Multiplatform Releases

Released: Feb 27, 2024

Updates in 18.6

Funktionen

  • Now allows users to connect to PostgreSQL through Azure Active Directory.
  • Adds support for PostgreSQL profiling.
  • Adds multi-factor authentication for Microsoft SQL Server.

Released: Nov 28, 2023

Updates in 18.5

Funktionen

  • Added binary column support for Db2 for LUW.
  • Updated stored procedures functionality when using Redshift.
  • Added support for the following database versions:
    • Db2 for LUW 11.5.x.
    • MySQL 8.0 and later.
    • PostgreSQL 14.x.

Fehlerkorrekturen

  • [Amazon Redshift] Resolved an issue preventing some Redshift users from editing parameters for Stored Procedures.
  • [PostgreSQL] Resolved an issue causing an error for some PostgreSQL 12.3 users when they double-click a domain to open the editor.

Released: May 24, 2023

Updates in 18.4

Funktionen

  • Now includes native Git version control. 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.

Fehlerkorrekturen

  • [DB2] Output from migration does not create table.
  • [SQL Server] Error message "Incorrect syntax near 'Index'" appears when dropping the Foreign Key between two tables.
  • [Azure SQL] Unable to drop an index on Azure SQL DB.
  • [Azure SQL and Oracle...

Released: Dec 8, 2022

Updates in 18.3

Funktionen

  • Added support for the latest version of Log4j.
  • Improved profiling session capability which alerts users to potentially problematic SQL ahead of time.

Fehlerkorrekturen

  • [Oracle] DDL validation failing after reordering columns.
  • [SQL Server] Windows Authentication not working with Access Analyst.
  • [Azure SQL] Cannot connect to Azure SQL using MFA.
  • [Azure SQL] User would like additional features for Azure support.
  • [PostgreSQL] Receiving an error when trying to connect to PostgreSQL...

Released: Jul 20, 2022

Updates in 18.2

Funktionen

  • Added support for Microsoft Windows 11.

Released: Apr 16, 2022

Updates in 18.1

Funktionen

  • Updated OpenJDK 11.0.7 to the latest OpenJDK 11 release.
  • Added support for PostgreSQL 13.
  • Added support for Oracle 21c.
  • Added the ability to open multiple files from the command line.

Fehlerkorrekturen

  • [Sybase ASE] Sybase ASE Syntax Drop Login, Alter Login not presenting with DDL Extract.
  • [Sybase ASE] Format SQL Clears out commands.
  • [Oracle and SQL Server] Stored Procedure is not extracting correctly with Rapid SQL 17.1.1.

Released: Oct 14, 2021

Updates in 18.0

Funktionen

  • Added support for PostgreSQL database management system.

Released: Oct 17, 2020

Updates in 17.1

Funktionen

  • Updated real-time syntax checking and code formatting.

Fehlerkorrekturen

  • [Oracle] Errors with the following commands for Oracle: UNION, INTERSECT, and MINUS.
  • [SQL Server] DBO gives a COUNT field incorrect error.

Released: Aug 28, 2019

Updates in 17.0.4

Funktionen

  • Adds SQL Server 2019 (experimental support).
  • Adds Oracle 18c and 19c database support.
  • Adds Sybase 16.0 database support.

Released: Dec 13, 2017

Updates in 17

Funktionen

  • Added SQL Server 2017 database and Windows Server 2016 OS support.
  • Versionless licensing for easier upgrades.
  • .msi version available for UI-free “headless” installation.

Fehlerkorrekturen

  • Bug fix for null pointer errors on shutdown.