How can we help you today? How can we help you today?

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
ChrisMacSki
0

Comments

4 comments

Sort by
  • 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?
    sam.blackburn
    0
  • Tianjiao_Li
    Hi @ChrisMacSki

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



    Tianjiao_Li
    0
  • 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.
    ChrisMacSki
    0
  • avitalit
    is there a way to exclude the columns in the CLI exec?

    avitalit
    0

Add comment

Please sign in to leave a comment.