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

Ignore certain column types in comparrison

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

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • madhav20
    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.
    madhav20
    0

Add comment

Please sign in to leave a comment.