ApexSQL Compare

Enhancements:

• Application telemetry now collects anonymous data on the use and performance of applications and application components

Fixes:

• 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

Changes:

• The activation model is now switched to Subscription
• 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

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
• New ApexSQL Updater allows users to configure advanced updating settings of all installed ApexSQL products
• Application telemetry now collects anonymous data on the use and performance of applications and application components

Fixes:

• 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

Changes:

• The activation model is switched to Subscription
• Error handling and send logs functionality has been modified
• 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

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

Changes

• The activation model is switched to Subscription
• 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

• 219624 "The 'ApexSOLDiff_InstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started