Released: Sep 2, 2025

19.0 での更新項目

機能

DB Optimizer 19.0

• 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.

Rapid SQL 19.0

• 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.

DB Change Manager 19.0

• Enhances Tablespace compression for Oracle
  • Tablespace extraction now defaults to COMPRESS BASIC, offering improved performance and storage efficiency for schema export/import operations.
• 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 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.

不具合の修正

DB Optimizer Multiplatform 19.0

• Reduces security vulnerabilities.
• 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.
• [Oracle] Resolves issues occurring when using COMPRESS functionality during a SQL extract.
• [Oracle] Resolves an issue causing some users to receive an "Error in Execute Method" message when attempting to add a column to a table.
• [PostgreSQL] Resolves a DB Optimizer issue preventing the Explain Plan from opening for a statement on the SQL tab of the Profiling Editor.

Rapid SQL All-Platforms 19.0

• Reduces security vulnerabilities.
• 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.
• [Oracle] Resolves issues occurring when using COMPRESS functionality during a SQL extract.
• [PostgreSQL] Returns the reporting functionality for PostgreSQL functions.
• [Oracle] Resolves an issue causing some users to receive an "Error in Execute Method" message when attempting to add a column to a table.
• [Oracle] Resolves a Rapid SQL issue causing errors with Alter tables in Rapid SQL 18.8.1 and 18.9 using Oracle 19c Enterprise Edition.

DB Change Manager Multiplatform 19.0

• Reduces security vulnerabilities.
• 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.
• [MySQL] Resolves a Change Manager issue preventing to DDL Extract tab from displaying the PK constraint and clustered PK when generating the Schema Archive job.
• [Oracle] Resolves issues occurring when using COMPRESS functionality during a SQL extract.
• [Oracle] Resolves an issue causing some users to receive an "Error in Execute Method" message when attempting to add a column to a table.
• [Oracle] Resolves a Change Manager issue causing properties with no value to appear as "Not Found" when comparing Live and Archive Oracle Datasource.