What are the challenges you face when working across database platforms? Take the survey

Ignore columns with a particular column name

Hi, I am fairly new to SQL Data Compare. I compare a lot of SQL DB's with the same schema, and have disabled 'Include Identity Columns' and 'Include timestamp columns' but still getting a lot of tables with a 'ModifiedDate' and 'ModifiedUser' column - which of course tend to be different. I'd like to exclude these. Is there a way to configure Data Compare to ignore columns with a particular column name? I preferably want to use the Data Compare UI - thought there may be an XML or INI file where I might be able to enter these few columns

Best Answers


Sign In or Register to comment.