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