Ignore certain column types in comparrison

jam13007

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

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.

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?

Brian Donahue wrote:

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.