What's New in 18.6

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.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

Version 17.1.0

  • Supports Windows Server 2019 and 2012 R2
  • Supports Oracle 11g R2
  • Supports PostgreSQL 9.6
  • Supports SQL Server 2014 SP2

Version 17.0.4

  • Supports SQL Server 2019, Oracle 19c

Version 17.0.3

There are no new features for this product version release.

Version 17.0.2

  • Version number update

Version 17.0.1

  • Continued licensing updates
  • Redesigned components:
    • Main toolbar
    • Data Source tab
    • Project Explorer tab
    • Main window tab mouse options
  • SQL Server enhancements
    • Tuning Statement window includes schemas
    • Profiler detail improved
    • Improved error messages

Version 17.0.0

  • Updated licensing
  • Updated installer
  • Removed Auto-Update and Install New Software from the Help menu

Version 16.6.0

  • Supports Db2 LUW 11 and Sybase 16.x

Version 16.5 (2016+)

  • IDERA rebranding
  • Product licensing changes
  • Supports 64-bit installations
  • Supports Java 1.8 update 91 and Eclipse 4.5.2 

Version 6.3.3 (2016)

  • Supports:
    • Microsoft SQL Server 2012
    • Oracle 12c
    • Sybase ASE 15.7
  • Updated tuning


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