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. For items introduced or fixed in an earlier release, see Previous features and fixed issues.
19.0 New features
Enhances Tablespace compression for Oracle
Tablespace extraction now defaults to COMPRESS BASIC, offering improved performance and storage efficiency for schema export/import operations.
Introduces PostgreSQL function reporting
Report generation now includes support for PostgreSQL functions, improving visibility, documentation, and auditing in complex environments.
Improves DDL Extraction
The DDL Extract tab now correctly displays all primary key constraints, including clustered keys, ensuring complete and accurate schema archives.
Modernizes the user interface
The New Data Source wizard is updated for Windows 11, providing a more intuitive and visually-consistent experience.
Improves role management in DB Optimizer
The DB Optimizer Users and Roles tab now supports seamless role modification, streamlining user and permission management, and enhancing security workflows.
Streamlines PostgreSQL query profiling
The Explain Plan in DB Optimizer now opens directly from the SQL tab in the profiling editor, enabling faster and more accurate performance tuning.
Clarifies Oracle data comparison
When comparing Live and Archive Oracle datasources in DB Optimizer, empty or null properties now display more clearly, improving report accuracy and eliminating misleading Not Found labels.
Improves MAXDOP formatting for index creation
Large numeric values for MAXDOP in DB Change Manager are now auto-formatted with commas, enhancing readability, reducing syntax errors, and improving compliance with SQL Server standards.
Adds support for PostgreSQL 17
DBArtisan 19.0 adds support for PostgreSQL 17.
19.0 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
DBA-34819, | Resolves issues occurring when using COMPRESS functionality during an SQL extract. | Oracle |
| DBA-34857 | Reduces security vulnerabilities. | |
| DBA-34881 | Resolves an issue causing a comma (,) to appear as the MAXDOP value after setting a number containing more than three digits when creating an index. | |
| DBA-34910 | Returns the reporting functionality for PostgreSQL functions. | PostgreSQL |
| DBA-34939 | Resolves an issue causing DBArtisan to not display all existing databases on the Indexes tab. | Sybase ASE |
| DBA-34959 | Resolves an issue causing DBArtisan to stop working when attempting to modify Default Role values on the Users/Roles tab. | Oracle |
| DBA-34975 | Resolves an issue causing some users to receive an "Error in Execute Method" message when attempting to add a column to a table. | Oracle |
| OPT-5384 | Resolves a DB Optimizer issue preventing the Explain Plan from opening for a statement on the SQL tab of the Profiling Editor. | PostgreSQL |
| RAP-6261 | Resolves a Rapid SQL issue causing errors with Alter tables in Rapid SQL 18.8.1 and 18.9 using Oracle 19c Enterprise Edition. | Oracle |
| SC-14847 | Resolves a Change Manager issue preventing to DDL Extract tab from displaying the PK constraint and clustered PK when generating the Schema Archive job. | MySQL |
| SC-14848 | Resolves a Change Manager issue causing properties with no value to appear as "Not Found" when comparing Live and Archive Oracle Datasource. | Oracle |