What's New in 18.7

For the new features and fixed issues in the latest version of DB Optimizer, see What's New.

System Requirements

Type

PlatformVersion
CPU
  • 1+ GHz

Random Access Memory (RAM)


  • 3 GB
Storage Disk Space
  • 1 GB
Operating SystemMicrosoft Windows
  • 11
  • 10
  • 8.1
  • 8
  • 7
Microsoft Windows Server
  • 2019
  • 2016
  • 2012 R2
  • 2012
  • 2008 SP1
  • 2008 R2
Cloud
  • Amazon Elastic Compute Cloud (EC2)
  • Amazon Redshift
  • Microsoft Azure SQL Database with AAD Support
  • Microsoft Azure Virtual Machine (VM)
  • Oracle Autonomous Database (Profiling only)
  • Oracle Cloud Infrastructure***
  • Snowflake
n/a
Database (Execution, Tuning, and DBMS) IBM Db2 LUW
  • 11.x*
  • 10.x

JDBC (Execution only)n/a

Microsoft SQL Server
  • 2022*
  • 2019*
  • 2017*
  • 2016*
  • 2014 SP2
  • 2014
  • 2012
  • 2008**

Oracle
  • 19c
  • 18c
  • 12c R2
  • 12c
  • 11g R2
  • 11g**
  • 10g**

PostgreSQL
  • 9.6

Sybase ASE
  • 16.x
  • 15.7
Database (Profiling and DBMS) IBM Db2 LUW
  • 11.x*
  • 10.x

Microsoft SQL Server
  • 2022*
  • 2019*
  • 2017*
  • 2016
  • 2014 SP2
  • 2014
  • 2012
  • 2008**

Oracle
  • 19c
  • 18c
  • 12c R2
  • 12c
  • 11g R2
  • 11g**
  • 10g**

Sybase ASE
  • 16.x
  • 15.7

* DB Optimizer supports only a subset of features and functions for this database version.

** Support for this version is nearing end of life and may not be available in subsequent DB Optimizer releases. 

*** Support for Oracle Cloud Infrastructure must have SYSDBA privileges only on Database VM/Baremetal.

Version History

Version 18.7

  • Enhances security authorizations
  • Adds support for Azure DevOps for source control
  • Enhances DB2 performance in DB Change Manager

Version 18.6

  • Allows users to connect to PostgreSQL through Azure Active Directory
  • Adds support for PostgreSQL profiling in DB Optimizer
  • Adds multi-factor authentication for MS SQL in DB Optimizer and DB Change Manager

Version 18.5

  • Improves synchronization script in DB Change Manager
  • Improves efficiency in DBArtisan, DB Change Manager, and Rapid SQL

Version 18.4

  • Supports SQL Server 2022

Version 18.3

  • Updates profiling session capability in DB Optimizer

Version 18.2

  • Updates trial licensing in DB Optimizer to limit the number of suggestions a user can submit

Version 18.1

There are no new features for this product version release.

Version 18.0

  • Supports PostgreSQL 


IDERA |  Products | Purchase | Support |  Resources |  About Us  | Legal