SyncFx 2.1 batch and filter RRS feed

  • Question

  • some scenarios: sync sql-to-sql

    1. batch:

    there are tables with column with varchar(max). There is one record with a size of 170MB (pictures in xml data..)

    how can I filter that record by the size of the datarow. so that I don't need to set the batchsize as big

    2. more than one filter parameter:

    eg. somthing like this: serverProvWA.Tables["Orders" ].FilterParameters["@originState" ].Value = "WA" ;

    what can i do if have more values than WA

    3. or when the customer changes the filter value and want all records

    do I have to delete the filter template

    4. what if 2 clients have different filter values, how can I implement this.

    do we have to delete the filter template everytime when the filter has changed?

    thanks for some code samples
    • Moved by Robert Breitenhofer Friday, September 17, 2010 3:02 PM English instead German (From:Visual C#)
    Monday, September 6, 2010 5:23 PM