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

Command line data compare

Is there a way to implement filters in comparison? I deal with extremely large tables (DW) and I would like to compare for example only records that have value in a column larger then @parameter


MC
MC
0

Comments

3 comments

Sort by
  • richardjm
    At the moment the best way to do this is to create an indexed view for the table and compare and synchronise using the view instead of the table.

    Hope this helps.

    Richard Mitchell
    richardjm
    0
  • MC
    Hmm, what I wanted is to pass parameter to the compare. 'FilterString' for the table(s) or something similar. Should this go to the feature request?
    MC
    0
  • richardjm
    I'll make sure this is considered as a feature for a future release.

    Hope this helps.
    Richard Mitchell
    richardjm
    0

Add comment

Please sign in to leave a comment.