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.

...

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

...

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.

Enhances DB2 performance in DB Change Manager

DB Change Manager /Data Compare includes updated support for Azure SQL for data copying18.7 users can take advantage of the added options in DB2 Data Synchronization to optimize performance, by maintaining data integrity, and therefore avoiding bottlenecks by making sure the data is accurate. There also are additional options that improve comparisons of Triggers and Sequence Columns, providing the user the benefit of constancy across schemas.

18.

...

7 Fixed issues

Issue NumberDescriptionDBMS
DBA-34810Output from migration does not create tableDB/2DBA-34792Error message "Incorrect syntax near 'Index'" appears when dropping the Foreign Key between two tablesSQL ServerDBA-34788Unable to drop an index on Azure SQL DBAzure SQLDBA-34784Descending sort order is missing when editing properties of an indexAzure SQL,
DBA-34685Updates 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


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