Exclude column(s) from comparison (globally)

ArtArt Posts: 2
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



  • 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
    Product Manager
    Redgate Software
Sign In or Register to comment.