Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

DB Change Manager provides the following new features and fixed issues. For items introduced or fixed in an earlier release, see Previous features and fixed issues.

18.

...

4 New features

Updates Azure cloud monitoring capability in DBArtisan

The monitoring capability for Microsoft Azure cloud is updated in DBArtisan. This functionality includes multi-tabbed process monitoring and management as well as allows you to catch performance issues before they arise.

Supports the latest version of Log4j

DB PowerStudio 18.3 includes support for the latest version of Apache Log4j, which is essential for proper logging and diagnostics of applications. 

Improves multiple areas within DBArtisan and Rapid SQL

DB PowerStudio 18.3 includes updates to the following areas within DBArtisan and Rapid SQL:

  • Extraction operations on roles for PostgreSQL allows users to have higher control over their data security.
  • Handling procedures with cascaded parameters on Redshift provides additional usage options with those parameters.
  • Connections to Azure SQL using multi-factor authentication provides more secure access.
  • Connections to PostgreSQL via Java Database Connectivity (JDBC) provides native connectivity for quicker access.
  • Reordering columns for Data Definition Language (DLL) validation allows the flexibility to rerun or reuse in scripts.

Improves multiple areas within DB Change Manager

  • Validation of Dump Devices, Linked Servers, Remote Servers and Server Triggers on Azure enables higher quality of those features.
  • Reuse of connection settings on logins when a node is accessible in SQL Server Management Studio (SSMS) allows faster user connections.
  • Fully populating database nodes on Azure for completeness.

Updates profiling session capability in DB Optimizer

DB Optimizer 18.3 updates profiling session capability, which alerts users to potentially problematic SQL ahead of time.

...

Adds native Git support

DBArtisan now includes native Git version control. You must have Git installed on the system where you want to use DBArtisan 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

DBArtisan 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 now includes sign-on capability for AzureAD for PostgreSQL, MySQL, and SQL Server.

Includes support for PostgreSQL identity columns

DBArtisan now includes 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.

18.4 Fixed issues

Issue NumberDescriptionDBMS
DBA-3474434810Output from migration does not create tableDB/2Log4J Upgrade all of DB PowerStudio
DBA-34743DDL validation failing after reordering columnsOracle34792Error message "Incorrect syntax near 'Index'" appears when dropping the Foreign Key between two tablesDBA-34682Windows Authentication not working with Access AnalystSQL Server
DBA-3460534788Cannot connect to Unable to drop an index on Azure SQL using MFADBAzure SQL
DBA-34524Receiving an error when trying to connect to PostgreSQLPostgreSQL
DBA-34244User would like additional features for Azure supportAzure SQL
34784Descending sort order is missing when editing properties of an indexAzure SQL, OracleOPT-5352Profiling session does not finish and seems to stallSybase ASE
Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse