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 | Platform | Version |
|---|
| CPU |
| |
Random Access Memory (RAM) |
| |
| Storage Disk Space |
| |
| Operating System | Microsoft Windows | |
| 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 | |
| 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 | |
| Sybase ASE | |
| Database (Profiling and DBMS) | IBM Db2 LUW | |
| Microsoft SQL Server | - 2022*
- 2019*
- 2017*
- 2016
- 2014 SP2
- 2014
- 2012
- 2008**
|
| Oracle | - 19c
- 18c
- 12c R2
- 12c
- 11g R2
- 11g**
- 10g**
|
| Sybase ASE | |
* 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
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
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 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