Filtering rows for compare
Thanks for your post. There are two ways to go about synchronizing a subset of data. The easiest is to create an indexed view on the table in your databases, then compare the indexed views.
The second way would be in code using the SQL Toolkit. You could write some code to compare the entire table, but synchronize only the rows of data matching your criteria using a SelectionDelegate object.
Please let me know if you need more information.