Released: Jul 29, 2021

Updates in SQL Change Automation 4.3.21210

Features

• Updated SQL Compare Engine to 14.5.20.19531.

Fixes

• Fixed extended properties of programmable objects not being idempotent unless the object itself was changed.

Released: Jul 14, 2021

Updates in SQL Change Automation 4.3.21195

Features

• Updated SQL Compare Engine to 14.5.17.19404.

Fixes

• Fixed issue where creation of extended properties of programmable objects would not be scripted as idempotent for certain types of values.

Released: Jul 7, 2021

Updates in SQL Change Automation 4.3.21187

Features

• Project verification errors will now be considered warnings, allowing the build/deployment to continue even if TransactSql.ScriptDom parser failed to validate the scripts.
• Updated SQL Compare Engine to 14.5.16.19384.

Released: Jun 23, 2021

Updates in SQL Change Automation 4.3.21174

Features

• Updated SQL Compare Engine to 14.5.14.19325.

Fixes

• Fixed non-idempotent extended properties for programmable objects with multiline string parameters.

Released: Jun 9, 2021

Updates in SQL Change Automation 4.3.21160

Features

• Updated SQL Compare Engine to 14.5.12.19214.

Fixes

• Fixed parsing of sql scripts to include the CONNECTION_OPTIONS clause in External Data Source objects.
• Added link to help page to warning text that migration may fail when user chooses to migrate External Data Source with credentials.

Released: Jun 2, 2021

Updates in SQL Change Automation 4.3.21152

Features

• RGTEMP environment variable can now be used to override temporary directory path used by SQL Change Automation.
• Updated SQL Compare Engine to 14.5.10.19205.

Released: May 27, 2021

Updates in SQL Change Automation 4.3.21147

Features

• Updated SQL Compare Engine to 14.5.8.19095.

Fixes

• Fixed idempotent extended properties for programmable objects inside "Create or change" script.

Released: May 5, 2021

Updates in SQL Change Automation 4.3.21125

Features

• Updated SQL Compare Engine to 14.5.6.18966.
• Added warning about migration possibly failing when user selects to migrate External Data Source with credentials.

Released: Apr 28, 2021

Updates in SQL Change Automation 4.3.21118

Features

• Updated SQL Compare Engine to 14.5.6.18850.

Fixes

• Using "Azure Active Directory - Password" authentication method should no longer cause "The server terminated an operation because it encountered a client request loop." exception.
• Database loading fix during verification SCA project based on an SQL Source Control project as a development source.

Released: Apr 12, 2021

Updates in SQL Change Automation 4.3.21098

Fixes

• Drift preservation script (NEW INCREMENTAL MIGRATIONS section in DriftRevertScript.sql) now contains statements opposite to the ones from drift reversion script.