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

Ignore certain column types in comparrison

jam13007jam13007 Posts: 4
edited February 21, 2013 3:18PM in SQL Compare Previous Versions
I want to ignore a certian type of difference.

When one column is varchar and the other is nvarchar. It doeas not affect the changes we are making.

I want to excldue this difference from the results to see other differences as we are comparing abour 120 tables.

Is that possible ?

Thanks

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    There are many options in SQL Compare for ignoring cretain attributes of a table, such as key names and column order, but you cannot ignore the datatype.

    Hope this helps.
  • Options
    Hi
    I have a date column with same name in all tables in source and target databases, I wanted to exclude the column from data comparison. Is there any option for this requirement in SQL compare 10?
    There are many options in SQL Compare for ignoring cretain attributes of a table, such as key names and column order, but you cannot ignore the datatype.

    Hope this helps.
Sign In or Register to comment.