Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result found

  1. Filter columns to compare across all tables

    162 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    10 comments  ·  SQL Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Russell Speight supported this idea  · 
    An error occurred while saving the comment
    Russell Speight commented  · 

    I had the same problem with 700+ tables and a column names row_version but I figure out a quick workaround. Setup your compare and save the project. Then use the below SQL script (changing column name) to generate the column deselection XML. Open your project's scp file and paste generate XML at the end of the TableActions element.

    select
    '<value version="1" type="SelectTableEvent">' + CHAR(13) + CHAR(10) +
    ' <action>DeselectColumn</action>' + CHAR(13) + CHAR(10) +
    ' <ColumnName>row_version:row_version</ColumnName>' + CHAR(13) + CHAR(10) +
    '<TableName>[dbo].[' + s.table_name + ']:[dbo].[' + s.table_name + ']</TableName>' + CHAR(13) + CHAR(10) +
    '</value>' + CHAR(13) + CHAR(10)
    from INFORMATION_SCHEMA.TABLES as s
    order by s.TABLE_NAME