Options

Exclude columns from compare but display data

scotts0415scotts0415 Posts: 3
edited March 6, 2009 2:20PM in SQL Data Compare Previous Versions
Is there a way to exclude columns from the compare but still view them in the results?

I have some timestamp fields that I would like to sort by but not compare.

Using SQL Data Compare 7.1
· Share on Twitter

Comments

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    Sorry, I don't think this is possible. If columns are excluded, they are excluded from both the comparison row-matching process, the comparison results and also aren't considered for synchronization.

    However, we will consider this as a feature request. Can I ask why you need to sort by timestamp? Also, are you just looking to compare, or would you want to synchronize some rows as well?

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • Options
    scotts0415scotts0415 Posts: 3
    We are propagating 2 different databases with 2 different products. They each write to their respective databases, but one might be a little slower than the other. So the timestamp column is always an explainable difference. It does help to have the column in the results for troubleshooting when each was last updated when we do find a legitimate difference. Hope this makes sense.

    We are not really using the product to syncronize data after the compare, we are only using it for validation.
    · Share on Twitter
  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    Thank you for the clarification. We will consider this as a feature request.

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