DB PowerStudio DBA Edition Releases

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.

DB Optimizer 19.0

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

Rapid SQL 19.0

• 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

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

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.

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.

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

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

DB Optimizer 19.0

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

Rapid SQL 19.0

• 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

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

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.

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.

DB Optimizer 19.0

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

Rapid SQL 19.0

• 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

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

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.

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.

DBArtisan

• Improved the Recent Project menu selection:
  • Increased the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.
• Added the ability to keep NOT TRUSTED when modifying FK constraints:
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.
• Improved performance for DB2 users - this release of DBArtisan can take advantage of performance improvements for DB2 users with updates to:
  • 'tablespaces' now allows null values, allowing users to formulate queries easily to allow for calculations by not including empty rows.
  • 'tablespaces' are now partitioned by range, ensuring accurate data and avoiding bottlenecks.

DB Optimizer

• Added the ability to keep NOT TRUSTED when modifying FK constraints:
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.

Rapid SQL

• Added the ability to keep NOT TRUSTED when modifying FK constraints
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.

DBArtisan

• Improved the Recent Project menu selection:
  • Increased the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.

DBArtisan

• Improved the Recent Project menu selection:
  • Increased the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.

DBArtisan

• Improved the Recent Project menu selection:
  • Increased the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.

DB Optimizer

• Included enhanced Sybase optimization in DB Optimizer:
  • DB Optimizer users will notice updated profiling to accurately show the sessions.

DBArtisan

• Improved the Recent Project menu selection:
  • Increased the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.
• Added the ability to keep NOT TRUSTED when modifying FK constraints:
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.
• Improved performance for DB2 users - this release of DBArtisan can take advantage of performance improvements for DB2 users with updates to:
  • 'tablespaces' now allows null values, allowing users to formulate queries easily to allow for calculations by not including empty rows.
  • 'tablespaces' are now partitioned by range, ensuring accurate data and avoiding bottlenecks.

DB Optimizer

• Added the ability to keep NOT TRUSTED when modifying FK constraints:
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.
• Included enhanced Sybase optimization in DB Optimizer:
  • DB Optimizer users will notice updated profiling to accurately show the sessions.

Rapid SQL

• Added the ability to keep NOT TRUSTED when modifying FK constraints
  • DB2 for LUW users now can use the NOT TRUSTED function when modifying foreign key (referential) constraints. Trusted/not trusted context affects how your application server interacts with the database server.