Skip to content

Settings and activity

1 result found

  1. 168 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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