Ignore columns with a particular column name
ChrisMacSki
Posts: 2 New member
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
Tagged:
Best Answers
-
sam.blackburn Posts: 224 Gold 2If 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?Software Developer
Redgate Software -
Tianjiao_Li Posts: 684 Rose Gold 5Hi @ChrisMacSki
I'm sorry if you already knew this, just adding a bit more about @sam.blackburn 's suggestion here.
Answers
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.