How can we help you today? How can we help you today?

Exclude column(s) from comparison (globally)

We have DateModified column on all tables. As you can guess I don't care about differences there....
Right now I have to go through all tables to exclude this columns from "Columns in Comparison".

Would it be possible to add some kind of exclusion list where I can put columns (name and maybe datatype) I don't care about when comparing data? (DateModified, LastModifiedBy etc)


Thank you

Art
Art
0

Comments

1 comment

Sort by
  • David Atkinson
    Thanks for the suggestion. We'll definitely consider this.

    If you've got programming skills you might want to consider generating the exclusions directly in the .sdc project file (to find this select Locate On Disk from the right click menu in Comparison Projects), assuming you have a list of your tables. Look for the items:

    <value version="1" type="SelectTableEvent"><action>DeselectColumn</action><ColumnName>youcolumnname:youcolumnname</ColumnName><TableName>[dbo].[yourtablename]:[dbo].[yourtablename]</TableName></value>

    and you could add your own, one for each of your tables.

    It's not the easiest way to do it, but if you have hundreds of tables, it would probably be worth a shot.

    David Atkinson
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.