Sub set compare

masterbakermasterbaker Posts: 19
edited January 20, 2006 9:47AM in SQL Toolkit Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    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.
Sign In or Register to comment.