Exclude column(s) from comparison (globally)

Art · November 18, 2008 8:40AM

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

David Atkinson · November 18, 2008 9:03AM

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

Exclude column(s) from comparison (globally)

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk