Options
Sub set compare
masterbaker
Posts: 19
Hi,
Our data is getting larger and larger, is this tools kit can be programed so that it will only compare to a certain sub set?? Say, certain month of data? thanks
Our data is getting larger and larger, is this tools kit can be programed so that it will only compare to a certain sub set?? Say, certain month of data? thanks
Comments
In four words: compare, no, synchronize, yes. Using the data compare library, you must compare all data horizontally. Verically you can still exclude columns fairly easily. But all rows in those columns must be compared.
When it comes to the synchronization, though, you can use a selectiondelegate function to filter certain rows out of the synchronization script automatically. This does tend to slow the script generation down quite a lot, though, because you must compare each record to a list of records that you want to synchronize. The implementation of a selectiondelegate is also a fairly challenging affair, in my opinion.
There is an example of horizontal filtering using Toolkit in http://www.red-gate.com/messageboard/vi ... php?t=1067.