SyncFx 2.1 batch and filter

• Question

• 

  

  0

  Sign in to vote

  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