Ignore columns with a particular column name

ChrisMacSki

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

sam.blackburn

If the schema is the same across all these databases, your best bet is probably to exclude the columns in the Tables & Views tab, save a project file and then reuse this project file against other databases.  Does that work for you?

Tianjiao_Li

Hi @ChrisMacSki

I'm sorry if you already knew this, just adding a bit more about @sam.blackburn 's suggestion here. 

ChrisMacSki

Hi everyone,

yeah those ideas do work, and I have done as suggested... I was more so looking for a global way to do it - its a bit of work to turn this off for 150-200 tables!

but in short, yeah this works.

avitalit

is there a way to exclude the columns in the CLI exec?