Page History

Versions Compared

Key

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

Table of Contents

maxLevel	2
minLevel	2

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		1+ GHz
Random Access Memory (RAM)		3 GB
Storage Disk Space		1 GB
Operating System	Microsoft Windows	11 10 8.1 8 7
Operating System	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

maxLevel	3
minLevel	3

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 SQLUpdates supported database versions

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-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools