Options

identity column included in comparison

EricVWEricVW Posts: 2
edited February 14, 2006 1:23PM in SQL Data Compare Previous Versions
Hi,

I've just started using SQL Data Compare today.

I was wondering if it is possible to ignore the identity column when comparing data. The option 'Exclude IDENTITY columns' doesn't do that for me.

Any ideas?

Thx. in adv.

Eric
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Eric,

    I think the issue here may be that the identity column is also the primary key. In that case, the only way to not have it in the results is to go into the columns setting and un-check it.

    Please let me know if this doesn't work for you.
    · Share on Twitter
Sign In or Register to comment.