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 |
18.9 New features
Improves the Recent Project menu selection
DBArtisan 18.9 increases the number of projects appearing in the Recent Projects. This increase improves the user experience by providing more choices for a quick selection.
Adds 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.
Improves performance for DB2 users
This release of DBArtisan and Rapid SQL can take advantage of performance improvements for DB2 users with updates to:
- tablespaces to allow null values, allowing users to formulate queries easily to allow for calculations by not including empty rows.
- the tablespace partition by range, ensuring accurate data and avoiding bottlenecks.
Includes enhanced Sybase optimization in DB Optimizer
DB Optimizer users will notice updated profiling to accurately show the sessions.
18.9 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34820 | Resolves an issue preventing indexes from appearing on the Indexes table of a Table. | Azure SQL DB |
| DBA-34912 | Adds a new NOT TRUSTED function when modifying foreign key (referential) constraints. | DB2 for LUW |
| DBA-34914 | Resolves an issue causing Tablespaces to display null values when running queries against DB2 databases. | DB2 for LUW |
| DBA-34916 | Resolves an issue causing an empty Space tab when viewing some database segments. | |
| DBA-34920 | Provides the ability to increase the number of files in the Recent Project menu. | |
| DBA-34948 | Resolves an issue preventing some users from opening or extracting Views. | ALL |
| DBA-34950 | Supports UI text size comparable to the browser font size. | |
| OPT-5390 | Resolves a DB Optimizer issue preventing some Sybase users from viewing content when performing a session profile. | Sybase |
| RAP-6257 | Resolves a Rapid SQL installation error indicating you must install MS Visual C++ redistributables. | ALL |
18.8 New features
Adds support of authorizations for PostgreSQL through Google Cloud
This release of DB PowerStudio provides authorizations for PostgreSQL through Google Cloud for all DB PowerStudio products (DBArtisan, Rapid SQL, DB Change Manager, and DB Optimizer).
18.8 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34801 | Resolves an issue preventing the Login tab from showing the correct value for Password Expire. | Sybase ASE |
DBA-34831 | Resolves an issue causing DBArtisan to crash after unregistering an Azure SQL DataSource and refreshing. | SQL Azure |
DBA-34877 | Resolves an issue causing DBArtisan to crash when clicking Refresh after unregistering a DataSource. | |
DBA-34930 | Resolves an issue preventing Varchar(max) from displaying more than 8kb of data. | SQL Server |
SC-14845 | [Change Manager] Resolves an issue preventing PDF exports. | |
SC-14858 | [Change Manager] Resolves an issue caused when attempting to generate a Configuration Archive report. | |
SC-14861 | [Change Manager] Allows users to use Schema Compare on a Sybase table with defaults. | Sybase ASE |
18.7 New features
Enhances Security authorizations
DB PowerStudio 18.7 users can now leverage multi-factor authentication (MFA) using the identity provider Microsoft Entra, formerly Azure Active Directory (AD), when connecting to Oracle. When logging into Oracle, you can users gain the inherent security policies and procedures from Microsoft Entra by entering your password only once.
Adds support for Azure DevOps for source control
This release of DBArtisan and Rapid SQL includes support for Azure DevOps for source control. Users gain the benefits of planning, collaborating, and code development using Azure DevOps Git repository for Project management. This feature allows developers to log in to Azure DevOps via a token and manage their code for history, check-in, and checkout capabilities.
18.7 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34685 | Updates the Monitor button to open a separate tab rather than simply a frame. | |
DBA-34842 | Resolves an issue where extracting DDL for a Job returns single rather than double quotation marks. | Oracle |
DBA-34905 OPT-5381 SC-14846 | Supports multi-factor authentication for Oracle through Microsoft Entra. | Oracle |
DBA-34906 | Displays syntax changed in the parser. | Snowflake |
DBA-34907 | Adds support for Azure DevOps Services. | |
RAP-6226 | Resolves an issue causing a data Cache size discrepancy in DBArtisan. | Sybase ASE |
SC-14840 | [Change Manager] Allows users to use native database tools in synchronization scripts when moving data. | |
SC-14841 | [Change Manager] Adds a new Compare option to Ignore Identity Properties in your Schema Comparison jobs. | |
SC-14844 | [Change Manager] Provides better comparison results by parsing Trigger content rather than comparing whole text. | DB2 for LUW |
SC-14849 | [Change Manager] Resolves an issue with an incorrect syntax of the CREATE TABLE SQL statement. | DB2 for LUW |
SC-14850 | [Change Manager] Allows users to choose whether to use the DBA or ALL view of Permissions in Oracle sys Tables. | Oracle |
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 |