Command line data compare

MC

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

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

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?

richardjm

I'll make sure this is considered as a feature for a future release.

Hope this helps.
Richard Mitchell