208565: "Could not load file or assembly 'Microsoft.Identity.Client'" error is encountered when trying to connect to the Azure server with the Azure Active Directory authentication type
Trust server certificate option is added under the “Connection options” dialog
The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions
Known limitations:
218747: "The 'ApexSOLCompareJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started
218749: There are no responses when any of the application options are selected from the "Extensions" drop-down list in Visual Studio 2019 16.7 version
ApexSQL Data Diff
Release: 2022.01.0564
Date: March 21, 2022
Enhancements:
A new warning is added in the Synchronization wizard, alerting the user that the synchronization process will fail when synchronizing a table with a unique index and ‘where' clause that only allows one record per parent to be the primary record is used
Import and Export filter controls are added in the Object filter tab in the New project window
198861: Tables with data including the leading quotes are not synchronized when a live database is the data source and a script folder is the destination data source
198438: Data difference view window shows incorrect differences when the data is sorted by a column with the ‘int' data type
201564: "Unable to cast object of type 'System.DBNull' to type 'System.String'" message is shown when comparing two databases while one database has an external data source
205993: The actions list in the Summary and warnings step of the Synchronization wizard is incorrectly displayed when returning to the Synchronization direction step and updating the synchronization direction
205992: "There was an error generating the XML document" error is encountered when the editor is changed in the Output options tab in the Synchronization wizard
199215: Redundant return code 11 error for unsupported edition appears when using CLI
198862: The additional objects appear in the script folder and NULL is shown in the Data difference view window for the fields when the synchronization is finished while using the live database vs script folder
198439: The application clientis unresponsive when using mouse scroll in the Data difference view window for product version 2019 R2
197148: Incorrect link is used when using Help button in the Resources tab
193158: "The 'Stub2019' package did not load correctly" error is encountered when the Visual Studio 2019 is started
188883: "The ConnectionString property has not been initialized" message is shown when trying to synchronize live database with Git repository
188692: Wrong results are shown in the HMTL interactive report when single row is checked
188691: Wrong results are shown in the HMTL simple report when single row is checked
170335: "Make sure correct username and password are specified" message is shown when Git source control password is changed in host and updated in the application connection configuration
165269: Custom mapped object pairs are not shown in the Object filter tab of the New project window
165267: Custom schema mapping is not saved after the comparison process is finished, after the Edit button is clicked from the Home tab and switched to the Object mapping tab
161562: All rows for a compared table are checked in the Data difference view panel, upon refresh action is performed after the check-uncheck sequence of events occur
163434: Records are not synchronized when a project file is saved from the Object filter tab in the New project window and used in the CLI
140586: The main application windows disappear in the case when the primary monitor displaying it is disconnected while sub-application windows are displayed on a secondary monitor
151315: The custom object mapping pairs become unpaired when the Refresh button is clicked under the Object mapping tab in the New project window
165265: Objects that belong to a schema mapping pair that is removed from the Object mapping tab are compared and shown in the Results grid
211792: The state of the check box in the main grid and in the data difference view is not consistent when uncheck columns in the data difference view
211791: "Select for synchronization" message in the Output options tab of Synchronization dialog is cut-off when comparing the script folder with path containing more than 40 characters with database
Trust server certificate option is added under the Connection options dialog
The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016
The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015
ApexSQL Diff
Release: 2022.01.1167
Date: March 21, 2022
Fixes:
211637: "Specified source control project path "$/" does not exist" CLI message appears when trying to synchronize the database with an empty Git source control repository located on non-main TFS branch
211793: The Git repository hosted on Azure DevOps Services is empty when default branch name is customized during synchronization of a live database with Git repository through CLI
206641: The “Schema” column is not populated with related schemas when Left-aligned view is used in the main grid
169039: The location path of a created backup is missing in the CLI execution summary
213732: The error messages in the Result dialog are now red color-coded
178387: "Selected script folder does not have corresponding folder structure" error is encountered when an empty script folder is used as a destination for comparison
209257: "Object reference not set to an instance of an object" error is encountered when trying to synchronize database with empty Subversion source control repository using CLI
215974: Exported comparison HTML file for SSIS package is not interactively structured
209519: "Error occurred while creating objects from script file" error is encountered when comparing the source control repository which containing objects defined via “WITH RESULT SETS” command
181277: The “Identity” column is not recognized correctly when the column is created via the “IDENTITY NOT NULL PRIMARY KEY” statement
210397: Comparing the Script folder with the Backup file difference view indicate on NULL parameters although the columns in the Script folder do not have it
