Page History
| Warning |
|---|
DB Optimizer 17.0.1 and later cannot use any workspaces produced by previous DBO versions, nor use any files created by those older workspaces. |
DB Optimizer provides the following new features and fixed issues.
...
17.0.1 New features
Continued Licensing Updates
DB Optimizer 17.0.1 includes additional licensing updates to bring it into standard with other IDERA products.
Redesigned Components
DB Optimizer 17.0.1 contains the following redesigned components for a better user experience:
- Main toolbar
- Data Source tab
- Project Explorer tab
- Main window tab right-hand mouse options
SQL Server Enhancements
DB Optimizer 17.0.1 offers a number of SQL Server-related enhancements including:
- The Tuning Statement window includes a drop-down list of schemas when viewing SQL Server databases.
- The DB Optimizer Profiler now properly displays SQL statement detail.
- Improved error messages.
17.0.1 Fixed issues
Backup Status tool
This release corrects an issue causing the Backup Status tool to unnecessarily increase memory consumption.
17.0.0 New Features
Updated Licensing
DB Optimizer includes a new licensing process to bring it into standard with the rest of the DB PowerStudio products.
Updated Installer
The installer for DB Optimizer now:
- Verifies that a supported version of windows OS exists on the machine before continuing with the installation
- Offers offline .MSI files for installation
Removed Auto-Update and Install New Software Features from Help Menu
This version of DB Optimizer includes an updated Help menu that no longer includes Auto-Update and Install New Software options.
For items introduced or fixed in an earlier release, see Previous features and fixed issues.
18.6 New features
Allows users to connect to PostgreSQL through Azure Active Directory
This release of DB PowerStudio allows users to connect to PostgreSQL through Azure Active Directory.
Adds support for PostgreSQL profiling in DB Optimizer
DB Optimizer 18.6 allows users to select PostgreSQL for a profiling session.
Adds multi-factor authentication for MS SQL Server in DB Optimizer and DB Change Manager
DB Optimizer and DB Change Manager users now can use multi-factor authentication for Microsoft SQL Server.
18.6 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34549 | Resolves an issue where some MySQL users received an error when trying to create a new user account. | MySQL |
| DBA-34656 | Resolves an issue preventing some Amazon Redshift users from being able to select a '''Database''', '''Owner''', or '''Object''' when using the Paste SQL wizard in the SQL Editor. | Amazon Redshift |
| DBA-34686 | Resolves an issue causing an error when a user attempts to delete any collection programmed into Capacity Analyst or any task programmed in DBArtisan using root user and administrator user. | Sybase ASE |
| DBA-34758 | Resolves Performance Analyst issues causing some Sybase users to receive an invalid column name error and an occasional DBArtisan crash when exiting the Performance Analyst. | Sybase ASE |
| DBA-34767 | Resolves an issue resulting in an empty Migrations Options screen. | |
| DBA-34820 | Resolves an issue preventing indexes from being dropped or appearing in the table editor. | |
| DBA-34851 | Resolves an issue where the DBArtisan project file was not created when you create a new project from the Version Control Project. | |
| DBA-34865 | Resolves an issue where DBArtisan cannot properly identify the Sybase client install in the machine. | Sybase ASE |
| DBA-34871 | Resolves an issue causing the system to create extended alter statements for any modification on a table. | Db2 for LUW |
| DBA-34874 | Adds support for connecting to PostgreSQL through Azure AD. | PostgreSQL |
| DBA-34875 | Adds support for authentication for Amazon Redshift through IAM. | Amazon Redshift |
| OPT-5351 | Adds support for Postgres profiling session. | PostgreSQL |
| OPT-5379 | Adds support for multi-factor authentication for DB optimizer for SQL Server. | SQL Server |
| RAP-6222 | Resolves an issue preventing users from being able to highlight multiple tables at once. | |
| SC-14820 | Resolves an issue causing a blank Refinements page when creating the Configuration Comparison job when two Azure SQL DB data sources are registered. | Azure SQL |
| SC-14833 | Resolves an issue preventing the display of more than 1,000 Objects in the Database Objects explorer. | |
| SC-14835 | Adds support for multi-factor authentication for Change Manager for SQL Server. | SQL Server |
...
Automate SQL tuning and profiling with DB Optimizer. Learn more > >
...