Page History
...
This build of DB Optimizer includes many fixed issues, including the following updates.
18.4 New features
Adds native Git support
DBArtisan and Rapid SQL now include native Git version control. You must have Git installed on the system where you want to use DB PowerStudio to utilize the native Git version control functionality.
Users may use Git version control to:
- create projects
- get the latest version
- add a file or project
- remove a file or project
- check in a file or project
- get history logs of files
Supports SQL Server 2022
DB PowerStudio 18.4 includes support for SQL Server 2022.
Improves space, capacity, and performance for Azure SQL and PostgreSQL
This release of DBArtisan includes updates that improve space, capacity, and performance for Azure SQL and PostgreSQL.
Includes sign-on for AzureAD for PostgreSQL, MySQL, and SQL Server
DBArtisan and Rapid SQL now include sign-on capability for AzureAD for PostgreSQL, MySQL, and SQL Server.
Includes support for PostgreSQL identity columns
DBArtisan and Rapid SQL now include support for PostgreSQL identity columns.
Updates Azure SQL for Data Copying in DB Change Manager
DB Change Manager/Data Compare includes updated support for Azure SQL for data copying. For more information about DB Change Manager, see DB Change Manager Wiki.
18.4 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34810 | Output from migration does not create table. | Db2 |
| DBA-34792 | Error message "Incorrect syntax near 'Index' " appears when dropping the Foreign Key between two tables. | SQL Server |
| DBA-34788 | Unable to drop an index on Azure SQL DB. | Azure SQL |
| DBA-34784 | Descending sort order is missing when editing properties of an index. | Azure SQL, Oracle |
18.3 New features
Updates Azure cloud monitoring capability in DBArtisan
...
DB Optimizer 18.3 updates profiling session capability, which alerts users to potentially problematic SQL ahead of time.
18.3 Fixed issues
| Issue Number | Description | DBMS |
|---|---|---|
| DBA-34744 | Log4J Upgrade all of DB PowerStudio | |
| DBA-34743 | DDL validation failing after reordering columns | Oracle |
| DBA-34682 | Windows Authentication not working with Access Analyst | SQL Server |
| DBA-34605 | Cannot connect to Azure SQL using MFA | Azure SQL |
| DBA-34524 | Receiving an error when trying to connect to PostgreSQL | PostgreSQL |
| DBA-34244 | User would like additional features for Azure support | Azure SQL |
| OPT-5352 | Profiling session does not finish and seems to stall | Sybase ASE |
18.2 New features
Adds support for Snowflake in DBArtisan and Rapid SQL
...