Exclude Pkey column comparing data tables

yanheguyanhegu Posts: 2
edited April 28, 2009 5:36PM in SQL Data Compare Previous Versions
I'm using SQL Data Compare 7.1 to compare data tables. Is there a way to exclude the Pkey column in my tables? It's an identitiy column that will not always be identical and I don't want the comparison result always showing difference in rows because Pkey not matching.

Thanks,
Yan
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,455 Rose Gold 2
    Yes, you can exclude any column from the comparison/synch from the Table and Views tab. However, if you remove the primary key, you'll have to select a replacement comparison key so SQL Data Compare knows how to match the records.

    Let us know if you have any problems with this.

    Kind regards,

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.