SQL Data compare : Exclude some standard columns

Hi , is there a way to exclude some standard columns from data comparison from all tables selected?
We have a lot of tables and do not want to exclude several standard columns one by one for each table .

Tagged:

Best Answer

  • Alex BAlex B Posts: 556 Rose Gold 3
    Accepted Answer
    Hi @CoenGeurtsen,

    There is no bulk configuration for similar columns I'm afraid. 

    You could possibly edit the XML project file to do this, but this isn't supported.  

    Having said that, this may work for you-

    Whether a column is included or not is controlled in the <TableActions> tags.  I am comparing two databases abtest and abtestPROD, with tables Table_1 and Table_3 that both have a column "asdf".  I have deselected this in both tables and the XML looks like:
      <TableActions type="ArrayList" version="1">
    <value version="1" type="SelectTableEvent">
    <action>DeselectColumn</action>
    <ColumnName>asdf:asdf</ColumnName>
    <TableName>[dbo].[Table_1]:[dbo].[Table_1]</TableName>
    </value>
    <value version="1" type="SelectTableEvent">
    <action>DeselectColumn</action>
    <ColumnName>asdf:asdf</ColumnName>
    <TableName>[dbo].[Table_3]:[dbo].[Table_3]</TableName>
    </value>
    </TableActions>

    So it should just be a matter of copy/pasting the <value> </value> section and modifying the table name included.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Answers

Sign In or Register to comment.