Options
Custom mapped columns issue
jmeyer
Posts: 70 Bronze 2
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.
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.
Comments
Thanks for your post!
I have logged a support ticket for you and will email you shortly.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
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.
Redgate Software