Custom mapped columns issue

jmeyerjmeyer Posts: 70 Bronze 2
edited October 26, 2016 2:35PM in SQL Data Compare
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.

Comments

  • Hi Jens,

    Thanks for your post!

    I have logged a support ticket for you and will email you shortly.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • jmeyerjmeyer Posts: 70 Bronze 2
    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.
  • We've released a fix to our frequent updates channel, version 12.0.34. Does this version solve your problem?
    Software Developer
    Redgate Software
  • jmeyerjmeyer Posts: 70 Bronze 2
    This issue is fixed in the latest version 12.0.34
Sign In or Register to comment.