Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Other: Need a performant compare

Palaniyappan Kumarappan User

We would like to have full compare done over the weekend for our DB's (which contains 32 schema's mostly for each DB) and we have 8 DB's in all.

We are doing a bulk compare (FULL) at present - but these are yielding differences - which when investigated further - we find the data to be in SYNC. But when we try the FULL compare with ROW WISE compare option, this is taking a longer time (almost 7 hours per schema) - with this we will not be able to complete the FULL compare (using ROW-WISE compare) during the weekend for all our DB's.

We would like to have a better compare solution from HVR. This has been discussed with Steve woods, Frank Knot and Hermen in our last weekly call.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Mark Van de Wiel User

    Hi There,

    Can you combine the use of Action Restrict CompareCondition with a filter on a stable column (i.e. one that does not change) to compare a meaningful incremental data set on a regular basis?

    Thanks,
    Mark.