SQL Change Automation PowerShell 4.1 release notes
Published 12 November 2019
4.1.20014 - January 14, 2020
Improvements:
- Updated SQL Compare Engine to 14.1.9.14577
4.1.20006 - January 6, 2020
Improvements:
- Updated SQL Compare Engine to 14.1.8.14375
- SCA-2674 - We now raise an error during build for unnamed primary key constraints in addition to existing unnamed constraint scenarios to
produce deterministic comparison behavior. Note that this may cause scripts which previously passed build validation to start failing.
Fix this by using e.g.ID INT NOT NULL, CONSTRAINT [MY_PK] PRIMARY KEY ([ID])in place ofID INT NOT NULL PRIMARY KEY.
4.1.19350 - December 17, 2019
Improvements:
- Updated SQL Compare Engine to 14.1.6.14245
4.1.19344 - December 11, 2019
Improvements:
- Updated SQL Compare Engine to 14.1.6.14149
4.1.19336 - December 3, 2019
Improvements:
- Updated SQL Compare Engine to 14.1.5.14025
4.1.19330 - November 26, 2019
Improvements:
- Updated SQL Compare Engine to 14.1.5.13997
4.1.19324 - November 20, 2019
Improvements:
- Updated SQL Compare Engine to 14.1.4.13897
- Added support for SQL Compare option
OnlineIndexBuild
4.1.19316 - November 12, 2019
Improvements:
- Updated SQL Compare Engine to 14.1.3.13803
- Added support for SQL Compare option
IgnoreDynamicDataMasking
Fixes:
- The shadow connection string defined in the .user file will not take precedence over the -TemporaryDatabaseServer when calling Invoke-DatabaseBuild.
