Custom mapped columns issue

jmeyer

DataCompare latest version:
I am comparing two tables where I did a custom mapping of two columns due to the column names not matching. In a first comparison I compared all columns. Afterwards, I ran a second comparison but deselected a couple of columns (including the two custom-mapped columns) from the comparison. However,t eh comparison then did compare the custom columns. Also, when going back in the project editor the column counter now increase by 2 and the two custom columns are checked again. So, somehow, in case of custom columns the un-checking of the comparison is being ignored.

Anu D

Hi Jens,

Thanks for your post!

I have logged a support ticket for you and will email you shortly.

jmeyer

SQL Data Compare v12.0.32.3340

Script to reproduce:
USE tempdb;
GO

IF EXISTS ( SELECT 1
FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[RedGateTableC1]')
AND type IN (N'U') )
DROP TABLE dbo.RedGateTableC1;

SET ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_PADDING ON;
GO

CREATE TABLE dbo.RedGateTableC1 (id INT IDENTITY(1, 12)
NOT NULL
, ColumnA VARCHAR(20) NOT NULL
, ColumnB VARCHAR(20) NOT NULL
, PRIMARY KEY CLUSTERED (id ASC) ON [PRIMARY])
ON
[PRIMARY];
GO

Then I compare the same table on the same system with itself after manually mapping ColumnA to ColumnB. Afterwards, I manually select the manually mapped column comparison of ColumnA/ColumnB so that the only comparison would happen on the ID primary key field. If I then re-check the selected comparison columns my manually mapped column is selected again.

sam.blackburn

We've released a fix to our frequent updates channel, version 12.0.34. Does this version solve your problem?

jmeyer

This issue is fixed in the latest version 12.0.34