Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
minLevel2

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

...

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

Version History

Table of Contents
maxLevel3
minLevel3

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

...

Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse