Exclude column(s) from comparison (globally)
Art
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
Art
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
Comments
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
Product Manager
Redgate Software